Women's Clothing & Accessories

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 (2,696,697,1018,999,998,1059,846,839,765,698,1019,1083,1068,1067,1000,1379,1547,1061,1060,1546,1579,1082,840,1515,1039,1024,899,766,1014,937,900,1390,767,1317,1404) and p.products_status = 1 order by pd.CTR desc