UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support A List of Moderators to Forums

Does any one have a sql to show what moderators are moderating which forums and there user names ?

Mark = forum 4, 5, 6,11

Its a pain keeping track with 8 moderators and 60 forums.

I did try the sql but could only get this far.

SELECT * FROM `ubbt_MODERATORS` ORDER BY `ubbt_MODERATORS`.`USER_ID` ASC LIMIT 0, 300