Brands > PANSTAR INTL CORP
|
||||||||||||||||||||||||||||||||||||
SELECT `Products`.* FROM `ProductsSearch` inner JOIN `Products` ON `Products`.`ID` = `ProductsSearch`.`ID_Products`
WHERE (`Products`.`Brand` = 'PANSTAR INTL CORP') AND (`Products`.`Availability` = 1) GROUP BY `ProductsSearch`.`ID_Products` ORDER BY `Products`.`ProductID` Asc
