Shoes

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 (103,750,705,1454,752,813,755,754,751,1267,1268,1329,1358,1073,1040,1038,753,1382,1020,1037,804,774,706,1302,1430,1517,1021,1271,1303,1305,1353,1455,1470) and p.products_status = 1 order by pd.CTR desc
-26%
Rs. 4,469
5,969
10.5789.5
Rs. 4,524
Rs. 4,556
Rs. 7,037
Rs. 4,088
Rs. 4,556