Lubrication

SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '520'OR PC.CatID = '519'OR PC.CatID = '1414'OR PC.CatID = '1428'OR PC.CatID = '1435'OR PC.CatID = '554'OR PC.CatID = '111'OR PC.CatID = '112'OR PC.CatID = '643'OR PC.CatID = '1258'OR PC.CatID = '642'OR PC.CatID = '419'OR PC.CatID = '687'OR PC.CatID = '689'OR PC.CatID = '1023'OR PC.CatID = '418'OR PC.CatID = '421'OR PC.CatID = '837'OR PC.CatID = '849'OR PC.CatID = '852'OR PC.CatID = '420'OR PC.CatID = '686'OR PC.CatID = '851'OR PC.CatID = '1067'OR PC.CatID = '685'OR PC.CatID = '688'OR PC.CatID = '1464'OR PC.CatID = '1462'OR PC.CatID = '965'OR PC.CatID = '966'OR PC.CatID = '1465'OR PC.CatID = '1466'OR PC.CatID = '1571'OR PC.CatID = '1245'OR PC.CatID = '490'OR PC.CatID = '850'OR PC.CatID = '947'OR PC.CatID = '1065'OR PC.CatID = '1066'OR PC.CatID = '1068'OR PC.CatID = '1233'OR PC.CatID = '489'OR PC.CatID = '754'OR PC.CatID = '755'OR PC.CatID = '255') LIMIT 0,9;