Query to show top posters in specific forums

[glennybee]

Hi folks,

I'm trying to find out who are the top posters in the individual sections on my forum. I've been given this query but it returns 0 results. I'm not using a table prefix for the database. I'm running vb 3.8.7.

SELECT COUNT(postid) AS count, user.username
FROM post
LEFT JOIN user ON (user.userid = post.userid)
LEFT JOIN thread ON (thread.threadid = post.threadid)
WHERE thread.forumid = 108
GROUP BY post.username
ORDER BY count
DESC

I've attached a screen shot of the query.

Thanks for any advice or if there's a mod that I can use, that'd be great.

Thanks
Glen