Body Shop

SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '568'OR PC.CatID = '1409'OR PC.CatID = '1410'OR PC.CatID = '523'OR PC.CatID = '30'OR PC.CatID = '29'OR PC.CatID = '1056'OR PC.CatID = '1057'OR PC.CatID = '1058'OR PC.CatID = '1059'OR PC.CatID = '1055'OR PC.CatID = '803'OR PC.CatID = '804'OR PC.CatID = '1011'OR PC.CatID = '802'OR PC.CatID = '311'OR PC.CatID = '1061'OR PC.CatID = '569'OR PC.CatID = '842'OR PC.CatID = '841'OR PC.CatID = '1355'OR PC.CatID = '1354'OR PC.CatID = '844'OR PC.CatID = '1054'OR PC.CatID = '1060'OR PC.CatID = '843'OR PC.CatID = '591'OR PC.CatID = '592'OR PC.CatID = '590'OR PC.CatID = '80'OR PC.CatID = '81'OR PC.CatID = '82'OR PC.CatID = '83'OR PC.CatID = '84'OR PC.CatID = '478'OR PC.CatID = '79'OR PC.CatID = '92'OR PC.CatID = '93'OR PC.CatID = '227'OR PC.CatID = '259'OR PC.CatID = '925'OR PC.CatID = '91'OR PC.CatID = '99'OR PC.CatID = '100'OR PC.CatID = '557'OR PC.CatID = '98'OR PC.CatID = '611'OR PC.CatID = '363'OR PC.CatID = '365'OR PC.CatID = '366'OR PC.CatID = '369'OR PC.CatID = '370'OR PC.CatID = '372'OR PC.CatID = '969'OR PC.CatID = '362'OR PC.CatID = '368'OR PC.CatID = '765'OR PC.CatID = '766'OR PC.CatID = '367'OR PC.CatID = '200'OR PC.CatID = '201'OR PC.CatID = '202'OR PC.CatID = '258'OR PC.CatID = '270'OR PC.CatID = '361'OR PC.CatID = '364'OR PC.CatID = '1093'OR PC.CatID = '199'OR PC.CatID = '358'OR PC.CatID = '359'OR PC.CatID = '371'OR PC.CatID = '433'OR PC.CatID = '827'OR PC.CatID = '866'OR PC.CatID = '871'OR PC.CatID = '963'OR PC.CatID = '1319'OR PC.CatID = '203'OR PC.CatID = '1383'OR PC.CatID = '1385'OR PC.CatID = '477') LIMIT 0,9;