Cellphones & Telecommunications

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 (32,806,779,947,807,814,1124,1125,1355,1377,1526,1556,1559,1572,1573,903,837,795,784,781,780,790) and p.products_status = 1 order by pd.CTR desc
Rs. 4,895
Rs. 2,371
Rs. 3,146
Rs. 2,089
Rs. 3,279
Rs. 4,383
Rs. 4,325
Rs. 3,146
Rs. 3,279
Rs. 3,322
Rs. 4,383
Rs. 3,279
Rs. 3,146
Rs. 1,799
Rs. 2,058
Rs. 3,920
Rs. 3,146
Rs. 3,146
Rs. 4,383
Rs. 3,279
Rs. 4,383
Rs. 4,325
Rs. 4,383
Rs. 3,541
Rs. 3,322
Rs. 3,322
Rs. 3,322
Rs. 4,897
Rs. 4,897
Rs. 4,897
Rs. 4,325
Rs. 4,325
Rs. 3,920
Rs. 3,920
Rs. 3,024
Rs. 3,024