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 (758,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. 2,953
Rs. 2,995
Rs. 3,191
Rs. 3,191
Rs. 2,953
Rs. 2,995
Rs. 2,953
Rs. 2,953
Rs. 2,953
Rs. 3,315
Rs. 2,953
Rs. 2,995