select distinct m.manufacturers_id, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id where p.products_status = '1' and p.manufacturers_id != '0'and p.products_id in ('366','401','700','803','813','825','854','856','1079','1256','1500','1836','2339','2340','2342','4632','4635','4639','4644','4645','4646','4665','5499','5716','5804','5829','5830','5831','5832','5833','5834','5835','5836','5837','6266','6267','6268','6342','6343','6346','6578','7165','7420','7881','9179','9180','9181','10432','16954','23300','31134','31135','31136','36847','45503','46904','47154','49637','54179','54201','54316','54317','54322','54581','54696','55584','58315','58373','58518','58519','58520','58521','58527','59407','59445','59539','60300','60304','60919') order by m.manufacturers_name