Compressors

SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '806'OR PC.CatID = '808'OR PC.CatID = '809'OR PC.CatID = '810'OR PC.CatID = '811'OR PC.CatID = '1013'OR PC.CatID = '1022'OR PC.CatID = '805'OR PC.CatID = '821'OR PC.CatID = '1014'OR PC.CatID = '813'OR PC.CatID = '1015'OR PC.CatID = '1016'OR PC.CatID = '1017'OR PC.CatID = '814'OR PC.CatID = '1018'OR PC.CatID = '1019'OR PC.CatID = '1020'OR PC.CatID = '820'OR PC.CatID = '1021'OR PC.CatID = '822'OR PC.CatID = '1369'OR PC.CatID = '1367'OR PC.CatID = '1440'OR PC.CatID = '617'OR PC.CatID = '1630'OR PC.CatID = '1386'OR PC.CatID = '1198'OR PC.CatID = '1199'OR PC.CatID = '933'OR PC.CatID = '463'OR PC.CatID = '464'OR PC.CatID = '465'OR PC.CatID = '1370'OR PC.CatID = '1371'OR PC.CatID = '462'OR PC.CatID = '513'OR PC.CatID = '518'OR PC.CatID = '1208'OR PC.CatID = '1378'OR PC.CatID = '472'OR PC.CatID = '473'OR PC.CatID = '475'OR PC.CatID = '516'OR PC.CatID = '474'OR PC.CatID = '482'OR PC.CatID = '826'OR PC.CatID = '1024'OR PC.CatID = '1025'OR PC.CatID = '1026'OR PC.CatID = '1027'OR PC.CatID = '1028'OR PC.CatID = '481'OR PC.CatID = '502'OR PC.CatID = '503'OR PC.CatID = '504'OR PC.CatID = '505'OR PC.CatID = '506'OR PC.CatID = '1400'OR PC.CatID = '501') LIMIT 0,9;