Code
SELECT COUNT *
FROM ubbt_WATCH_LISTS
WHERE WATCH_ID = XX
AND WATCH_TYPE = 'f'

XX - the forum id you are concerned with