|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SELECT `Products`.*
FROM `ProductsSearch`
inner JOIN `Products` ON `Products`.`ID` = `ProductsSearch`.`ID_Products`
LEFT JOIN `tbl_items` `I` ON `Products`.`ProductID` = `I`.`ItemGroup`
WHERE (`ID_Categories` = '28' Or `ID_Categories` = '29' Or `ID_Categories` = '30' Or `ID_Categories` = '31' Or `ID_Categories` = '32') AND (`Products`.`Availability` = 1)
AND (`I`.`ShowOnlyLocal` = '1')
GROUP BY `ProductsSearch`.`ID_Products` ORDER BY `Products`.`ProductID` Asc
