Safety Products

SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '527'OR PC.CatID = '563'OR PC.CatID = '976'OR PC.CatID = '526'OR PC.CatID = '783'OR PC.CatID = '784'OR PC.CatID = '785'OR PC.CatID = '782'OR PC.CatID = '536'OR PC.CatID = '565'OR PC.CatID = '535'OR PC.CatID = '539'OR PC.CatID = '562'OR PC.CatID = '344'OR PC.CatID = '624'OR PC.CatID = '625'OR PC.CatID = '626'OR PC.CatID = '635'OR PC.CatID = '639'OR PC.CatID = '343'OR PC.CatID = '616'OR PC.CatID = '623'OR PC.CatID = '637'OR PC.CatID = '638'OR PC.CatID = '786'OR PC.CatID = '622'OR PC.CatID = '630'OR PC.CatID = '633'OR PC.CatID = '629'OR PC.CatID = '632'OR PC.CatID = '780'OR PC.CatID = '631'OR PC.CatID = '1442'OR PC.CatID = '187'OR PC.CatID = '627'OR PC.CatID = '628'OR PC.CatID = '636'OR PC.CatID = '640'OR PC.CatID = '186'OR PC.CatID = '985') LIMIT 0,9;