Sports & Entertainment

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 (128,1007,1004,831,822,748,763,1395,1475,1008,1482,1011,1010,1009,1016,1005,1017,1006,985,980,832,1292,1483,1500,1025,823,847,1387,1026,1417,1045,824,1510,1283,791,833,749,1324,1373,1412,764,1493,1396,1397,1476) and p.products_status = 1 order by pd.CTR desc