Sunglasses

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 = 771 and p.products_status = 1 order by pd.CTR desc