MyBB Community Forums

Hello all
I'm developping a plugin and i have a small problem
I'm trying to do this query on phpmyadmin, to get member posts count where the member is the thread starter :

SELECT COUNT(*) FROM mybb_threads as t, mybb_posts as p WHERE t.uid = p.uid AND t.uid = 1 

And tried this :

SELECT COUNT(*) FROM mybb_threads as t, mybb_posts as p WHERE p.username = 'AmazOuz' AND t.username = 'AmazOuz'

But i get biiiig numbers (119639...etc) 
I don't know where is the problem  
Please help
Thanks

---

I explain :

I have 10 threads
I have 30 posts
10 of these 30 posts = my own replies to my own threads.

I want a query to get the number of my own replies on my own threads Tongue
So i need to count the number of posts that have the same TID as the TID of my threads

I know it's difficult to understand Noh

---

Problem fixed !