Beauty & Health

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 (152,1149,986,965,897,1086,1096,1119,1136,1138,1145,1199,1459,1253,1150,987,1105,1319,1196,966,1332,1490,1197,1282,1333,1438,1491,898,1087,1148,1088,1097,1161,1179,1098,1180,1198,1339,1462,1120,1121,1122,1155,1137,1139,1432,1146,1176,1147,1177,1200) and p.products_status = 1 order by pd.CTR desc