Toys & Hobbies

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 (175,699,1054,1034,1032,990,873,707,689,1259,1354,1529,1569,700,1496,1057,1056,1055,1036,1035,1509,1058,1033,1533,1585,991,1508,874,877,948,708,690,1498,1260,1530,1570) and p.products_status = 1 order by pd.CTR desc