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 ('2803','2804','2805','6362','6363','7134','7139','7143','10417','32941','35451','35590','35606','35719','43260','46409','46410','46411','46412','58719','58720','58721','62360','62361','62362') order by m.manufacturers_name