Home & Garden

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 (683,976,969,955,882,879,861,851,802,772,684,1151,1248,977,1249,978,1094,1063,970,1205,1435,1064,1316,971,1301,1300,1206,1221,1242,1244,1245,1374,1436,956,1100,957,1101,1154,982,883,1413,983,1287,995,994,884,1429,1418,1414,880,1162,1272,881,1273,1074,889,862,1089,1113,1368,1075,890,1265,1079,1022,863,1402,1090,1102,1112,1359,1114,1190,1191,1192,1369,1582,981,858,853,852,859,864,901,1084,1126,1159,1252,1356,997,860,902,1085,1103,1160,1336,1357,939,872,803,1095,1447,1497,1499,1258,912,808,773,1130,1304,1331,962,914,913,1276,1131,1566,1028,960,929,712,709,703,687,685,1127,1134,1164,1170,1174,1181,1183,1214,1217,1227,1239,1567,1048,1029,961,1111,930,1376,726,713,1129,1132,1143,1144,1202,1204,1208,1211,1220,1434,717,716,715,711,710,704,1104,1185,721,720,702,688,1212,1213,1222,1223,1372,701,691,692,693,694,695,722,719,718,714,686,1168,1172,1173,1187,1203,1209,1375,1128,1133,1216,1135,1167,1166,1165,1169,1186,1229,1230,1235,1171,1224,1175,1201,1207,1210,1182,1195,1184,1225,1215,1218,1219,1340,1228,1240,1241,1568,1152,1424,1419,1422,1425,1420,1423,1444) and p.products_status = 1 order by pd.CTR desc