Men's Clothing & Accessories

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 (1,1047,1046,1041,844,996,992,967,927,921,919,848,733,758,954,845,993,1352,1536,975,974,968,928,922,1296,1378,920,1501,1266,849,819,734,972,838,834,770,759,1153,1580,809,771,1015,760,1115,1343,1466,1484,1586) and p.products_status = 1 order by pd.CTR desc
Rs. 3,002
Rs. 2,995
Rs. 6,862
Rs. 4,862
Rs. 2,953
Rs. 2,995
Rs. 3,191
Rs. 4,126