Tried it in PHPMyAdmin
It returns :
My Threads TID, each TID has his own POSTNUM which is the number of posts in that thread
And not all my threads are shown, only some of them
EDIT : I added AND p.uid = 1 in the WHERE condition
I get each TID with my posts number in that thread.
I just have now to delete the group by, and i get the postnum
I just have to do this to get what i need :
SELECT COUNT(p.pid) FROM mybb_posts p LEFT JOIN mybb_threads t ON( t.tid = p.tid ) WHERE t.uid = '1' AND p.uid = '1'
LOVE YOU SOZIN