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 ('2411','2414','2415','2417','2809','2810','2811','2812','2813','2814','2815','2816','2817','2818','2819','2820','2822','2823','2824','2825','2826','2827','2828','5983','6085','6086','6087','6088','6090','6091','6095','6246','6247','6883','7273','7275','7328','7329','8085','8132','9321','9322','9323','9638','10107','10109','10111','10113','10115','10205','10206','10207','18919','20221','20223','20224','20225','25824','36934','37880','37881','39765','39766','41261','41281','41605','41606','41785','41858','41859','43288','47521','47522','47524','54842','60173','60175','61856','61857') order by m.manufacturers_name