select p.products_id from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 order by pd.CTR desc

Ready to Dispatch Imported Products

Rs. 10,170
Rs. 5,899
Rs. 4,330
Rs. 4,136
Rs. 3,002
Rs. 1,367
Rs. 5,753
-52%
8,219
Rs. 4,024
Rs. 2,995
-28%
4,716
Rs. 3,416
Rs. 6,104
Rs. 3,229
-23%
1,209
Rs. 934
-6%
3,090
Rs. 2,913
Rs. 4,562
Rs. 5,074
Rs. 4,228
Rs. 2,370
-38%
4,604
Rs. 2,858
Rs. 3,811
Rs. 4,074
Rs. 8,393
Rs. 5,737
Rs. 6,203
-41%
8,282
Rs. 4,888
Rs. 4,602
-41%
4,712
Rs. 2,825
Rs. 4,456
Rs. 9,526
-43%
7,969
Rs. 4,573
Rs. 4,882
Rs. 4,374
Rs. 4,629
Rs. 6,561
Rs. 7,132
Rs. 4,960
Rs. 2,129
Rs. 4,304
-6%
695
Rs. 655
Rs. 3,418