COUNT (SQL) problem

Hello all
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 (the number of messages on my own threads)


And tried this :


But i get biiiig numbers (119639...etc)

I don't know where is the problem :noh:

Please help
Thanks

On my own threads. ok.

I am not really sure what you are trying to achieve.

Tell me what you want to count? Number of threads or posts or threads+posts by a user?

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
So i need to count the posts that have the same TID as the TID of my threads

I know it's difficult to understand :noh:

Then:


This should give you posts that you have made on each thread that you have made.

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