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 ('1480','1819','4978','4979','4980','5497','5498','5612','5613','5614','5615','5616','5617','5618','5906','6351','6883','7273','7275','9321','9322','9323','10413','10436','10438','39552','39553','39554','39555','40396','40397','40398','46991','46992','47174','49843','54841','58643','59128','59129','59130','59131','59132','59133','59134','59135','60369','62304','62305','62306','62319','62320','62321') order by m.manufacturers_name