Mother & Kids

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 (114,1051,1049,940,931,904,910,775,1140,1193,1346,1452,1485,1052,1053,1050,942,941,1370,1371,932,905,1344,1449,1468,906,1123,1456,1451,1345,1469,1535,911,776,1366,1367,1141,1364,1457,1450,1142,1467,1458,1194,1541,1347,1351,1534,1348,1453,1507,1486) and p.products_status = 1 order by pd.CTR desc