MyBB Community Forums

Hi,
there is a way to have the total number of views threads for forum with a mysql query?
I need to sum all views for the fid 6


Many thanks

SELECT SUM(views) FROM mybb_threads WHERE fid = '6';

Change the prefix if you have different.

Can you not just use
SELECT views FROM (posts table name) WHERE fid = 6;

EDIT:
Got beaten to the punch :p

Many thanks