Today, I was asked "Which forum is so&so (custom island) advert located in?"
It occured to me that I couldn't easily report on this.
I mean yes, I can go to the Custom Islands tab and see all of them - but I don't see which forums 'own' the advert.
And of course I can visit each forum, click on 'details' and then custom inserts - but with a lot of forums this would take a while.
Am I missing something here? Surely there is an easier way. (?)
I knocked this query up quickly and it works for what I need, but again, am I missing something?
SELECT FORUM_ID, FORUM_TITLE, FORUM_ISLAND_INSERT, PORTAL_ID, PORTAL_NAME FROM ubbt_FORUMS, ubbt_PORTAL_BOXES WHERE FORUM_ISLAND_INSERT = PORTAL_ID AND PORTAL_CUSTOM = '1'
