Lights & Lighting

select p.products_id from products p, products_description pd ,products_to_categories p2c where p.products_id = pd.products_id and p.products_id = p2c.products_id and p2c.categories_id IN (218,1080,979,841,835,1110,1116,1285,1322,1325,1393,1465,1427,1504,1081,842,836,1117,1286,1323,1337,1330,1326,1394,1512,1473,1428) and p.products_status = 1 order by pd.CTR desc