Luggage & Bags

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 (93,820,793,735,1327,1405,1460,973,821,894,1511,857,810,958,794,923,1001,850,843,805,738,737,736,1328,1514,1406,1461) and p.products_status = 1 order by pd.CTR desc