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 ('393','532','635','923','976','1578','1745','1831','1920','2171','2176','2177','2665','3015','4895','5387','5562','5695','5698','5859','6460','6461','7338','7476','7628','7788','8054','9749','10444','19588','23602','26857','32000','32012','38206','38595','40994','40995','41321','43179','45487','46604','46678','46882','47832','49407') order by m.manufacturers_name