Consumer Electronics

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 (58,1262,951,933,907,761,798,1349,1398,1522,1576,1263,1519,1264,1069,952,1250,1554,1070,953,1251,1555,934,1463,1538,1464,1539,1553,1002,908,1284,1027,1003,909,801,800,762,1360,1575,799,1091,1433,1525,1403,1350,1431,1399,1523,1524,1537,1577) and p.products_status = 1 order by pd.CTR desc