Janitorial, Material Handling & Leisure

SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '263'OR PC.CatID = '522'OR PC.CatID = '911'OR PC.CatID = '521'OR PC.CatID = '15'OR PC.CatID = '16'OR PC.CatID = '271'OR PC.CatID = '273'OR PC.CatID = '275'OR PC.CatID = '948'OR PC.CatID = '1255'OR PC.CatID = '14'OR PC.CatID = '18'OR PC.CatID = '392'OR PC.CatID = '17'OR PC.CatID = '1336'OR PC.CatID = '1337'OR PC.CatID = '1451'OR PC.CatID = '274'OR PC.CatID = '604'OR PC.CatID = '614'OR PC.CatID = '752'OR PC.CatID = '1201'OR PC.CatID = '530'OR PC.CatID = '342'OR PC.CatID = '1338'OR PC.CatID = '1350'OR PC.CatID = '276'OR PC.CatID = '534'OR PC.CatID = '533'OR PC.CatID = '44'OR PC.CatID = '46'OR PC.CatID = '85'OR PC.CatID = '1202'OR PC.CatID = '45'OR PC.CatID = '1332'OR PC.CatID = '314'OR PC.CatID = '1342'OR PC.CatID = '356'OR PC.CatID = '1353'OR PC.CatID = '355'OR PC.CatID = '120'OR PC.CatID = '140'OR PC.CatID = '228'OR PC.CatID = '619'OR PC.CatID = '823'OR PC.CatID = '1167'OR PC.CatID = '1171'OR PC.CatID = '119'OR PC.CatID = '147'OR PC.CatID = '121'OR PC.CatID = '122'OR PC.CatID = '644'OR PC.CatID = '914'OR PC.CatID = '920'OR PC.CatID = '934'OR PC.CatID = '919'OR PC.CatID = '1191'OR PC.CatID = '923'OR PC.CatID = '668'OR PC.CatID = '669'OR PC.CatID = '670'OR PC.CatID = '1185'OR PC.CatID = '1186'OR PC.CatID = '1188'OR PC.CatID = '1189'OR PC.CatID = '1190'OR PC.CatID = '1259'OR PC.CatID = '1275'OR PC.CatID = '1422'OR PC.CatID = '1184'OR PC.CatID = '1170'OR PC.CatID = '673'OR PC.CatID = '675'OR PC.CatID = '690'OR PC.CatID = '674'OR PC.CatID = '936'OR PC.CatID = '178'OR PC.CatID = '951'OR PC.CatID = '184'OR PC.CatID = '697'OR PC.CatID = '1469'OR PC.CatID = '967'OR PC.CatID = '984'OR PC.CatID = '761'OR PC.CatID = '762'OR PC.CatID = '764'OR PC.CatID = '760'OR PC.CatID = '763') LIMIT 0,9;