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 ('724','2039','2919','2921','2923','2924','2926','3227','3245','3649','3951','5360','5366','5367','5370','6573','6809','7510','7615','9169','39999','43134','44640','44641','45501','45724','50244','51391','54141','54306','54307','55906','55907','56108','56109','56111','59362','59533','59534','59541','59610','59612','59615','60298','60769','61062','63159','63160','63161','63162','63163','63166','63167','63168','63169','63170','63171') order by m.manufacturers_name