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 ('6505','6513','7236','7238','7465','7560','7561','7562','7564','9883','23260','26388','26389','40448','41118','41682','42012','45441','49678','49825','54548','55666') order by m.manufacturers_name