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 ('238','291','293','294','295','378','518','544','553','564','573','574','749','918','1199','1265','1313','1646','1648','1650','1651','1675','1941','1945','1947','1954','2055','2450','2555','2578','2579','2583','2584','2808','2847','2850','2853','2864','2865','2866','2867','2868','2869','2870','2871','2872','2873','2874','2875','3037','3038','3041','3042','3043','3045','3046','3063','3064','3133','3134','3135','3136','3304','3305','3306','3850','3859','3870','3871','3872','3875','4087','4088','4158','4161','4163','4394','4396','4397','4400','4403','4405','4407','4408','4409','4546','4636','4858','4882','4883','4884','4885','4886','4887','4891','4895','4897','4898','4899','4900','4901','4902','4903','4904','4906','4907','4908','4909','4910','4912','5294','5530','5531','5618','5926','5927','5928','6245','6250','6252','6280','6281','6303','6304','6341','6398','6556','6625','6814','6836','6837','6839','7220','7277','7401','7402','7441','7460','7555','7557','7558','7559','7578','7691','7726','8003','8142','8168','8267','8268','8269','9483','9484','9485','9486','9487','10468','10471','10474','18160','18161','18700','18753','21799','21802','21844','21845','21846','21848','21849','21850','21857','21858','21859','21860','21861','21864','21876','21878','21879','21880','21882','22785','23134','23885','23896','23899','23905','23909','23913','27187','28613','33665','33666','33667','34345','35237','35262','36755','36757','38176','39867','40378','40379','40380','40381','40383','40384','40386','40387','40389','40621','41020','45441','46849','46850','46851','46852','47553','48308','49431','49433','50301','50302','50303','50304','51393','51394','51395','51396','54447','54448','54449','54450','54451','54452','54453','54455','54457','54458','54521','54525','54528','54542','54561','54566','54650','54739','55655','55656','55664','55677','55680','55682','55684','55688','55689','55691','55692','55693','55694','55695','55701','55702','55967','55982','57926','58403','58652','58690','58691','58692','58693','58694','58695','58716','58876','58878','58927','59447','59448','59926','59928','59929','60501','60502','60503','60504','60561','60563','60980','61413','61414','61564','61958','61959','62070','62072','62074','62180','62352','62353','62354','62438','63102','63104','63787','64569','64570') order by m.manufacturers_name