MyBB Community Forums

Full Version: query forums
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am in need of help running a specific query. I want to gather the total threads from forum id's. Example below.

Forums to gather users total threads from;
1, 16, 12 and 3

I want to get the total threads the user has posted in the forums above and be able to display them on their profile as a separate field such as.

Total Game Reviews: x
x being the total threads the user has made in forums 1, 16, 12 and 3 (forum IDs) combined.

What's the SQL Query I should be running?

Any help please.
A lot of views but no answers.