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 ('819','1465','1519','1534','4860','4930','6005','6018','7529','19574','23592','25451','31054','31060','31062','43378','43772','46055','53756','54418') order by m.manufacturers_name