Vehicle Service 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 = '12'OR PC.CatID = '165'OR PC.CatID = '208'OR PC.CatID = '212'OR PC.CatID = '224'OR PC.CatID = '234'OR PC.CatID = '296'OR PC.CatID = '384'OR PC.CatID = '666'OR PC.CatID = '667'OR PC.CatID = '733'OR PC.CatID = '741'OR PC.CatID = '11'OR PC.CatID = '20'OR PC.CatID = '23'OR PC.CatID = '24'OR PC.CatID = '894'OR PC.CatID = '1241'OR PC.CatID = '19'OR PC.CatID = '34'OR PC.CatID = '179'OR PC.CatID = '436'OR PC.CatID = '657'OR PC.CatID = '658'OR PC.CatID = '662'OR PC.CatID = '664'OR PC.CatID = '683'OR PC.CatID = '706'OR PC.CatID = '714'OR PC.CatID = '719'OR PC.CatID = '720'OR PC.CatID = '726'OR PC.CatID = '728'OR PC.CatID = '729'OR PC.CatID = '730'OR PC.CatID = '742'OR PC.CatID = '745'OR PC.CatID = '877'OR PC.CatID = '1244'OR PC.CatID = '1450'OR PC.CatID = '1452'OR PC.CatID = '33'OR PC.CatID = '41'OR PC.CatID = '43'OR PC.CatID = '307'OR PC.CatID = '308'OR PC.CatID = '447'OR PC.CatID = '731'OR PC.CatID = '737'OR PC.CatID = '861'OR PC.CatID = '1117'OR PC.CatID = '40'OR PC.CatID = '1071'OR PC.CatID = '1103'OR PC.CatID = '1239'OR PC.CatID = '1246'OR PC.CatID = '1453'OR PC.CatID = '1454'OR PC.CatID = '1455'OR PC.CatID = '1456'OR PC.CatID = '1458'OR PC.CatID = '1070'OR PC.CatID = '49'OR PC.CatID = '382'OR PC.CatID = '383'OR PC.CatID = '759'OR PC.CatID = '970'OR PC.CatID = '1074'OR PC.CatID = '48'OR PC.CatID = '310'OR PC.CatID = '724'OR PC.CatID = '732'OR PC.CatID = '735'OR PC.CatID = '736'OR PC.CatID = '740'OR PC.CatID = '744'OR PC.CatID = '746'OR PC.CatID = '747'OR PC.CatID = '748'OR PC.CatID = '749'OR PC.CatID = '750'OR PC.CatID = '1238'OR PC.CatID = '1467'OR PC.CatID = '309'OR PC.CatID = '1240'OR PC.CatID = '1242'OR PC.CatID = '1457'OR PC.CatID = '1461'OR PC.CatID = '1115'OR PC.CatID = '723'OR PC.CatID = '971'OR PC.CatID = '1260'OR PC.CatID = '1460'OR PC.CatID = '1468'OR PC.CatID = '661'OR PC.CatID = '153'OR PC.CatID = '216'OR PC.CatID = '217'OR PC.CatID = '218'OR PC.CatID = '221'OR PC.CatID = '360'OR PC.CatID = '656'OR PC.CatID = '659'OR PC.CatID = '660'OR PC.CatID = '663'OR PC.CatID = '665'OR PC.CatID = '691'OR PC.CatID = '693'OR PC.CatID = '694'OR PC.CatID = '718'OR PC.CatID = '722'OR PC.CatID = '734'OR PC.CatID = '983'OR PC.CatID = '152'OR PC.CatID = '1656'OR PC.CatID = '1459'OR PC.CatID = '699'OR PC.CatID = '700'OR PC.CatID = '701'OR PC.CatID = '702'OR PC.CatID = '717'OR PC.CatID = '721'OR PC.CatID = '698'OR PC.CatID = '705'OR PC.CatID = '975'OR PC.CatID = '704') LIMIT 0,9;