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 ('1023','1194','1323','3947','3950','3951','3952','4667','5363','5834','6430','7358','7409','7410','41175','45502','46694','46928','50341','50342','54737','55900') order by m.manufacturers_name