COUNT (SQL) problem

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
http://prntscr.com/7l0jdh

---

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 <33