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 ('276','935','2020','2037','2038','2157','2577','2687','2883','2884','2885','2886','6273','6274','6275','7210','18976','18977','27117','27335','43255','50743','54541','59444') order by m.manufacturers_name