Motorcycle Tools

SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '1603'OR PC.CatID = '1311'OR PC.CatID = '1323'OR PC.CatID = '1324'OR PC.CatID = '1325'OR PC.CatID = '1328'OR PC.CatID = '1322'OR PC.CatID = '1448'OR PC.CatID = '1329'OR PC.CatID = '1237'OR PC.CatID = '1326'OR PC.CatID = '1116'OR PC.CatID = '146'OR PC.CatID = '753'OR PC.CatID = '145'OR PC.CatID = '1434'OR PC.CatID = '1433'OR PC.CatID = '167'OR PC.CatID = '1471'OR PC.CatID = '166'OR PC.CatID = '169'OR PC.CatID = '213'OR PC.CatID = '219'OR PC.CatID = '168'OR PC.CatID = '174'OR PC.CatID = '175'OR PC.CatID = '1313'OR PC.CatID = '1207'OR PC.CatID = '215'OR PC.CatID = '703'OR PC.CatID = '712'OR PC.CatID = '1463'OR PC.CatID = '214'OR PC.CatID = '282'OR PC.CatID = '684'OR PC.CatID = '707'OR PC.CatID = '708'OR PC.CatID = '709'OR PC.CatID = '710'OR PC.CatID = '711'OR PC.CatID = '713'OR PC.CatID = '1327'OR PC.CatID = '220') LIMIT 0,9;