How to query for the number of users that have subscribed to a forum

[ed762]

Hi all, just wonder if anyone has figured out how to query for the number of users that have subscribed to a particular forum. What do you query in SQL?

Thank you

[kh99]

I think this might work:
SELECT COUNT(*) FROM subscribeforum WHERE forumid = X

where X is the forumid.

[ozzy47]

Yes that should work.

If you want to do this on a thread level, there is this mod, [OzzModz] Users Subscribed To Thread Block (https://vborg.vbsupport.ru/showthread.php?t=305173)

[ed762]

Thank you. I will give it a shot.

[ozzy47]

Let me know if it is what you were after.