Jewelry & 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 (73,811,768,756,745,742,731,1314,1505,895,893,812,1578,787,783,782,785,769,788,1520,1542,1062,792,789,757,1361,1365,1516,888,878,747,746,1583,896,818,786,1023,743,744,1118,1584,1321,1334,1315,1506,1513) and p.products_status = 1 order by pd.CTR desc
Rs. 3,979
Rs. 4,390