I've created the extra active columns in the productcategory and productsubcategory tables and realised that the dynamic menu wizzard seems to only allow one filter selection. I already have a GroupID filter in productcategory and a nested filter in productsubcategory as shown in the screenshot.
The only place I can see to add the extra WHERE for the active columns is in the recordsets for menu.php as shown in the screenshot.
Is this the only way to achieve this, if so what is the correct SQL to add after the existing WHERE?