Home Improvement

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 (270,885,868,815,777,1107,1188,1400,886,887,963,915,869,964,916,1342,1341,871,870,1012,816,1256,1013,817,1257,778,1288,1108,1380,1289,1109,1381,1189,1401) and p.products_status = 1 order by pd.CTR desc