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 ('220','393','394','395','411','412','532','535','536','537','538','572','625','652','655','757','853','948','970','976','1098','1112','1135','1181','1184','1185','1224','1310','1366','1367','1437','1453','1454','1463','1468','1504','1526','1527','1528','1567','1578','1581','1582','1745','1767','1788','1792','1793','1831','1847','1856','1857','1863','1919','2171','2176','2177','2316','2594','2986','2990','2995','2997','3014','3015','3191','3192','3193','3196','3579','4108','4951','5433','5483','5526','5527','5547','5653','5698','5703','5724','5727','5738','5742','5743','5755','5994','5995','6003','6013','6016','6028','6073','6080','6265','6777','6779','6780','6861','7114','7189','7338','7350','7422','7457','7520','7628','7629','7642','7713','7765','7772','7788','7854','7882','7960','7977','8034','8035','8052','8053','8054','8256','8258','8259','9201','9344','9506','9510','9683','9687','9690','9693','9747','9749','9751','9757','9798','9802','9919','10138','10140','10198','10244','10246','10305','17015','17066','17083','17379','17422','18208','18780','18959','19290','19514','19546','19549','19554','19561','19588','19889','19893','20260','20262','20273','20284','20287','22709','23583','23586','23595','23602','23604','25510','26975','27572','27573','27579','28691','30853','33567','33679','35180','35193','35194','36190','38087','38091','38248','39977','40215','40289','40290','40991','40992','40994','40995','43179','43381','43466','43752','44692','45485','45576','45945','45949','46375','46390','46502','46529','46604','46702','46703','46954','46963','46964','47144','47145','47146','47529','47673','47827','47868','48085','48086','48088','49853','50248','50449','50450','50451','50452','50456','50474','50683','50687','50988','54002','54068','54374','54375','54784','54785','59227','59293','59774','60713','60714','61382','63762') order by m.manufacturers_name