Welding & Cutting

SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '1000'OR PC.CatID = '779'OR PC.CatID = '571'OR PC.CatID = '573'OR PC.CatID = '641'OR PC.CatID = '1419'OR PC.CatID = '1420'OR PC.CatID = '1421'OR PC.CatID = '570'OR PC.CatID = '96'OR PC.CatID = '97'OR PC.CatID = '297'OR PC.CatID = '1340'OR PC.CatID = '1341'OR PC.CatID = '95'OR PC.CatID = '610'OR PC.CatID = '999'OR PC.CatID = '609'OR PC.CatID = '634'OR PC.CatID = '157'OR PC.CatID = '1317'OR PC.CatID = '1318'OR PC.CatID = '1339'OR PC.CatID = '1444'OR PC.CatID = '1558'OR PC.CatID = '1194'OR PC.CatID = '997'OR PC.CatID = '1356'OR PC.CatID = '198') LIMIT 0,9;