Automobiles & Motorcycles

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 (207,1076,943,891,1279,729,1246,1309,1077,1312,1480,1078,1552,1313,1481,1495,945,944,1157,1448,946,1158,938,892,959,1156,1308,1338,1311,1407,1421,1494,1532,1548,1558,1581,1549,1280,1281,1269,730,1477,1270,1439,1478,1298,1247,1306,1415,1560,1299,1531,1557,1307,1479,1416,1565,1561,1310,1318,1562) and p.products_status = 1 order by pd.CTR desc