Invalid query: SELECT `Brands`.* FROM `Brands` INNER JOIN `CatItems` ON `Brands`.`__id` = `CatItems`.`Brand` WHERE `CatItems`.`Category` IN (1981) AND `CatItems`.`Active` = 1 GROUP BY `Brands`.`__id` ORDER BY `Brands`.`CustomOrder`Got error 28 from storage engine
SELECT `Brands`.* FROM `Brands` INNER JOIN `CatItems` ON `Brands`.`__id` = `CatItems`.`Brand` WHERE `CatItems`.`Category` IN (1981) AND `CatItems`.`Active` = 1 GROUP BY `Brands`.`__id` ORDER BY `Brands`.`CustomOrder`