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 ('5442','6458','6486','6487','6489','6776','7270','7554','7735','9826','9867','10439','10454','17101','21788','26608','26610','26611','26613','26614','28715','33750','33812','33813','33814','33815','33816','33820','33821','33823','33824','33827','41101','41102','41103','41829','41835','41836','43113','53704','54580','57927','58688','58928','62839','62840') order by m.manufacturers_name