Электронные устройства, стр. 9

SELECT `parent`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `parent` !='' AND `modx_site_content`.`id` IN ('269','317','155860','155861','158551','159963','160564','161335','161390','161892','162743','163924','165230','165387','165598','166977','166978','166979','167191','167276','238060','238220','238559','239019','239575','239866','239903','241971','241972','242093','243718','244035','244051','244267','244268','244472','246448','246829','248148','248149','248223','248277','248823','249130','249421','249769','251232','251610','252200','253666','256271','257075','262197','273670','277279','278778','281089','283535','283550','286797','293427','297810','302250','302251','153890','154979','157671','159796','159813','160284','160440','160566','160626','160896','161361','161515','162401','162984','163402','164364','164699','164828','164968','166601','166602','166603','166604','166605','167340','167396','167397','167398','167400','167401','167512','167918','232691','238078','239898','240915','241694','241695','241700','241901','241992','241995','242228','242349','242350','242532','242967','243075','243320','243321','243322','243323','243874','243995','244094','244108','244138','244323','244691','244968','244969','244970','244971','245171','245328','245573','245590','246094','246095','246167','246348','246349','246488','246917','247467','247706','247723','248106','249216','249808','249809','250066','250507','250616','251044','251454','251739','251990','253024','253406','254515','255170','255592','255593','255594','255614','256701','261951','261982','262400','262435','262591','264371','264372','264535','265175','265199','265329','265592','265593','267026','267999','268005','268179','269605','273367','274503','275255','275256','275426','275552','276083','276557','276565','277716','280472','282154','282214','282215','282216','282217','282218','282229','282241','282242','282243','282244','282877','283640','284615','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285340','285341','285453','285460','285461','285801','285863','286253','287791','288837','288838','289066','293522','295712','299053','299532','299900','303930','303931','303932','153135','157705','158873','160868','161043','161347','162200','162282','162332','162333','162397','162512','162513','163432','164120','164854','165064','165277','165578','166285','166609','167056','167303','167480','167513','167529','167560','167709','167757','167774','167775','167913','167919','167993','168309','168310','238017','238137','238155','239574','239962','240300','240904','241064','241876','241925','241926','241927','242229','242582','242614','243295','243299','243306','243472','243534','243614','243666','243981','245096','245572','245834','245874','246023','246341','246616','246789','246949','247048','247739','247994','248289','248290','248337','248412','248486','248503','248505','248546','248597','248917','249293','249403','249679','249778','250602','250604','250654','250692','250856','251212','251226','251592','251593','251594','251952','251973','251984','253061','253132','253494','254438','255177','255322','255376','255705','255813','256269','256270','256274','256275','256276','256731','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845','261846','261847','261848','261849','261850','261851','261852','261853','261854','261855','261856','261857','261858','261859','261860','261861','261862','261863','261864','261865','261866','261867','261868','261869','261870','261871','261872','261873','261874','261875','261876','261877','261878','261879','261880','261881','261882','261883','261884','261885','261886','261887','261888','261889','261890','261891','261892','261893','261894','261895','261896','261897','261898','261899','261900','261901','261902','261903','261904','261905','261906','261907','261908','261909','261910','261911','261912','261913','261914','261915','261916','261917','261918','261919','261920','261921','261922','261923','261924','261925','261926','261927','261928','261929','261930','261931','261932','261959','262001','262070','262501','262502','262662','262729','262730','262731','262732','262733','262734','262735','262736','262737','262858','263020','264559','264560','264561','264562','264563','264570','264571','264572','264573','264574','264575','264576','264577','264578','264579','264580','264581','264582','264583','264585','264586','264587','264589','264590','264591','264592','264593','264594','264595','264596','264597','264598','264599','264600','264601','264602','264603','264604','264605','264606','264607','264608','264609','264651','265014','265070','265098','265176','265177','265178','265211','265212','265213','265214','265215','265216','265217','265218','265219','265220','265221','265222','265223','265575','265816','265885','266109','266110','266192','266194','266207','266208','266209','266210','266211','266212','266213','266214','266215','266216','266217','266218','266517','266518','266519','266520','266521','266522','266523','266524','266525','266526','266527','266528','266529','266530','266531','266532','266533','266534','266535','266536','266537','266587','266596','266692','266777','266801','266802','266842','267406','267696','267697','267698','267898','267899','267900','267975','268170','268171','268172','268173','268174','268175','268176','268177','268178','268653','268654','268655','268656','268680','268717','268720','268721','268722','268723','268774','268870','269166','269202','269421','269546','273556','273596','273604','273661','273664','273779','273782','273811','273812','273813','273814','273815','273816','273817','273818','273819','273820','273821','273822','273823','273843','273922','273924','274273','274284','274335','274336','274379','274420','274421','274422','274644','274904','274926','274992','275004','275265','275295','275296','275855','275969','276144','276453','276454','276699','277022','277190','277891','277894','278178','278397','278683','278978','278985','279191','279222','279232','279562','280606','280980','282376','283706','284230','284376','284612','284863','284921','284922','284923','284924','285072','285330','285562','285598','285606','285607','285917','285972','286827','286828','286994','288115','288281','288758','288898','289457','289460','291588','291781','291785','291888','292058','292287','292437','292438','292439','292440','292441','292442','292443','292444','292445','292446','292447','292448','292449','292450','292451','292452','292453','292454','292455','292456','292457','292458','292459','292463','292464','292465','292467','292468','292541','293198','293382','293460','293510','293646','293928','294033','294217','294756','295296','295694','295695','297427','297685','297804','298371','299144','300994','300995','302168','161890','165416','165469','166094','166098','166890','167070','167322','241703','245418','245625','246251','246698','248473','254651','255111','262195','264860','265474','267116','267913','273945','274879','278884','282920','283118','284844','285690','286376','286441','287203','291635','292628','292780','293383','294218','294709','296198','297126','297190','297363','297444','298563','299080','295741','299040','303911') GROUP BY `parent` ORDER BY `parent` ASC

SELECT `parent`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `parent` !='' AND `modx_site_content`.`id` IN ('153135','153890','154979','155860','155861','157671','157705','158551','158873','159796','159813','159963','160284','160440','160564','160566','160626','160868','160896','161043','161335','161347','161361','161390','161515','161890','161892','162200','162282','162332','162333','162397','162401','162512','162513','162743','162984','163402','163432','163924','164120','164364','164699','164828','164854','164968','165064','165230','165277','165387','165416','165469','165578','165598','166094','166098','166285','166601','166602','166603','166604','166605','166609','166890','166977','166978','166979','167056','167070','167191','167276','167303','167322','167340','167396','167397','167398','167400','167401','167480','167512','167513','167529','167560','167709','167757','167774','167775','167913','167918','167919','167993','168309','168310','232691','238017','238060','238078','238137','238155','238220','238559','239019','239574','239575','239866','239898','239903','239962','240300','240904','240915','241064','241694','241695','241700','241703','241876','241901','241925','241926','241927','241971','241972','241992','241995','242093','242228','242229','242349','242350','242532','242582','242614','242967','243075','243295','243299','243306','243320','243321','243322','243323','243472','243534','243614','243666','243718','243874','243981','243995','244035','244051','244094','244108','244138','244267','244268','244323','244472','244691','244968','244969','244970','244971','245096','245171','245328','245418','245572','245573','245590','245625','245834','245874','246023','246094','246095','246167','246251','246341','246348','246349','246448','246488','246616','246698','246789','246829','246917','246949','247048','247467','247706','247723','247739','247994','248106','248148','248149','248223','248277','248289','248290','248337','248412','248473','248486','248503','248505','248546','248597','248823','248917','249130','249216','249293','249403','249421','249679','249769','249778','249808','249809','250066','250507','250602','250604','250616','250654','250692','250856','251044','251212','251226','251232','251454','251592','251593','251594','251610','251739','251952','251973','251984','251990','252200','253024','253061','253132','253406','253494','253666','254438','254515','254651','255111','255170','255177','255322','255376','255592','255593','255594','255614','255705','255813','256269','256270','256271','256274','256275','256276','256701','256731','257075','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845','261846','261847','261848','261849','261850','261851','261852','261853','261854','261855','261856','261857','261858','261859','261860','261861','261862','261863','261864','261865','261866','261867','261868','261869','261870','261871','261872','261873','261874','261875','261876','261877','261878','261879','261880','261881','261882','261883','261884','261885','261886','261887','261888','261889','261890','261891','261892','261893','261894','261895','261896','261897','261898','261899','261900','261901','261902','261903','261904','261905','261906','261907','261908','261909','261910','261911','261912','261913','261914','261915','261916','261917','261918','261919','261920','261921','261922','261923','261924','261925','261926','261927','261928','261929','261930','261931','261932','261951','261959','261982','262001','262070','262195','262197','262400','262435','262501','262502','262591','262662','262729','262730','262731','262732','262733','262734','262735','262736','262737','262858','263020','264371','264372','264535','264559','264560','264561','264562','264563','264570','264571','264572','264573','264574','264575','264576','264577','264578','264579','264580','264581','264582','264583','264585','264586','264587','264589','264590','264591','264592','264593','264594','264595','264596','264597','264598','264599','264600','264601','264602','264603','264604','264605','264606','264607','264608','264609','264651','264860','265014','265070','265098','265175','265176','265177','265178','265199','265211','265212','265213','265214','265215','265216','265217','265218','265219','265220','265221','265222','265223','265329','265474','265575','265592','265593','265816','265885','266109','266110','266192','266194','266207','266208','266209','266210','266211','266212','266213','266214','266215','266216','266217','266218','266517','266518','266519','266520','266521','266522','266523','266524','266525','266526','266527','266528','266529','266530','266531','266532','266533','266534','266535','266536','266537','266587','266596','266692','266777','266801','266802','266842','267026','267116','267406','267696','267697','267698','267898','267899','267900','267913','267975','267999','268005','268170','268171','268172','268173','268174','268175','268176','268177','268178','268179','268653','268654','268655','268656','268680','268717','268720','268721','268722','268723','268774','268870','269166','269202','269421','269546','269605','273367','273556','273596','273604','273661','273664','273670','273779','273782','273811','273812','273813','273814','273815','273816','273817','273818','273819','273820','273821','273822','273823','273843','273922','273924','273945','274273','274284','274335','274336','274379','274420','274421','274422','274503','274644','274879','274904','274926','274992','275004','275255','275256','275265','275295','275296','275426','275552','275855','275969','276083','276144','276453','276454','276557','276565','276699','277022','277190','277279','277716','277891','277894','278178','278397','278683','278778','278884','278978','278985','279191','279222','279232','279562','280472','280606','280980','281089','282154','282214','282215','282216','282217','282218','282229','282241','282242','282243','282244','282376','282877','282920','283118','283535','283640','283706','284230','284376','284612','284615','284844','284863','284921','284922','284923','284924','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285072','285330','285340','285341','285453','285460','285461','285562','285598','285606','285607','285690','285801','285863','285917','285972','286253','286376','286441','286797','286827','286828','286994','287203','287791','288115','288281','288758','288837','288838','288898','289066','289457','289460','291588','291635','291781','291785','291888','292058','292287','292437','292438','292439','292440','292441','292442','292443','292444','292445','292446','292447','292448','292449','292450','292451','292452','292453','292454','292455','292456','292458','292459','292463','292464','292465','292467','292468','292541','292628','292780','293198','293382','293383','293427','293460','293510','293522','293646','293928','294033','294217','294218','294709','294756','295296','295694','295695','295712','295741','296198','297126','297190','297363','297427','297444','297685','297804','298371','298563','299040','299053','299080','299144','299532','299900','300994','300995','302168','302250','302251','303911','303930','303931','303932') GROUP BY `parent` ORDER BY `parent` ASC

SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('269','317','155860','155861','158551','159963','160564','161335','161390','161892','162743','163924','165230','165387','165598','166977','166978','166979','167191','167276','238060','238220','238559','239019','239575','239866','239903','241971','241972','242093','243718','244035','244051','244267','244268','244472','246448','246829','248148','248149','248223','248277','248823','249130','249421','249769','251232','251610','252200','253666','256271','257075','262197','273670','277279','278778','281089','283535','283550','286797','293427','297810','302250','302251','153890','154979','157671','159796','159813','160284','160440','160566','160626','160896','161361','161515','162401','162984','163402','164364','164699','164828','164968','166601','166602','166603','166604','166605','167340','167396','167397','167398','167400','167401','167512','167918','232691','238078','239898','240915','241694','241695','241700','241901','241992','241995','242228','242349','242350','242532','242967','243075','243320','243321','243322','243323','243874','243995','244094','244108','244138','244323','244691','244968','244969','244970','244971','245171','245328','245573','245590','246094','246095','246167','246348','246349','246488','246917','247467','247706','247723','248106','249216','249808','249809','250066','250507','250616','251044','251454','251739','251990','253024','253406','254515','255170','255592','255593','255594','255614','256701','261951','261982','262400','262435','262591','264371','264372','264535','265175','265199','265329','265592','265593','267026','267999','268005','268179','269605','273367','274503','275255','275256','275426','275552','276083','276557','276565','277716','280472','282154','282214','282215','282216','282217','282218','282229','282241','282242','282243','282244','282877','283640','284615','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285340','285341','285453','285460','285461','285801','285863','286253','287791','288837','288838','289066','293522','295712','299053','299532','299900','303930','303931','303932','153135','157705','158873','160868','161043','161347','162200','162282','162332','162333','162397','162512','162513','163432','164120','164854','165064','165277','165578','166285','166609','167056','167303','167480','167513','167529','167560','167709','167757','167774','167775','167913','167919','167993','168309','168310','238017','238137','238155','239574','239962','240300','240904','241064','241876','241925','241926','241927','242229','242582','242614','243295','243299','243306','243472','243534','243614','243666','243981','245096','245572','245834','245874','246023','246341','246616','246789','246949','247048','247739','247994','248289','248290','248337','248412','248486','248503','248505','248546','248597','248917','249293','249403','249679','249778','250602','250604','250654','250692','250856','251212','251226','251592','251593','251594','251952','251973','251984','253061','253132','253494','254438','255177','255322','255376','255705','255813','256269','256270','256274','256275','256276','256731','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845','261846','261847','261848','261849','261850','261851','261852','261853','261854','261855','261856','261857','261858','261859','261860','261861','261862','261863','261864','261865','261866','261867','261868','261869','261870','261871','261872','261873','261874','261875','261876','261877','261878','261879','261880','261881','261882','261883','261884','261885','261886','261887','261888','261889','261890','261891','261892','261893','261894','261895','261896','261897','261898','261899','261900','261901','261902','261903','261904','261905','261906','261907','261908','261909','261910','261911','261912','261913','261914','261915','261916','261917','261918','261919','261920','261921','261922','261923','261924','261925','261926','261927','261928','261929','261930','261931','261932','261959','262001','262070','262501','262502','262662','262729','262730','262731','262732','262733','262734','262735','262736','262737','262858','263020','264559','264560','264561','264562','264563','264570','264571','264572','264573','264574','264575','264576','264577','264578','264579','264580','264581','264582','264583','264585','264586','264587','264589','264590','264591','264592','264593','264594','264595','264596','264597','264598','264599','264600','264601','264602','264603','264604','264605','264606','264607','264608','264609','264651','265014','265070','265098','265176','265177','265178','265211','265212','265213','265214','265215','265216','265217','265218','265219','265220','265221','265222','265223','265575','265816','265885','266109','266110','266192','266194','266207','266208','266209','266210','266211','266212','266213','266214','266215','266216','266217','266218','266517','266518','266519','266520','266521','266522','266523','266524','266525','266526','266527','266528','266529','266530','266531','266532','266533','266534','266535','266536','266537','266587','266596','266692','266777','266801','266802','266842','267406','267696','267697','267698','267898','267899','267900','267975','268170','268171','268172','268173','268174','268175','268176','268177','268178','268653','268654','268655','268656','268680','268717','268720','268721','268722','268723','268774','268870','269166','269202','269421','269546','273556','273596','273604','273661','273664','273779','273782','273811','273812','273813','273814','273815','273816','273817','273818','273819','273820','273821','273822','273823','273843','273922','273924','274273','274284','274335','274336','274379','274420','274421','274422','274644','274904','274926','274992','275004','275265','275295','275296','275855','275969','276144','276453','276454','276699','277022','277190','277891','277894','278178','278397','278683','278978','278985','279191','279222','279232','279562','280606','280980','282376','283706','284230','284376','284612','284863','284921','284922','284923','284924','285072','285330','285562','285598','285606','285607','285917','285972','286827','286828','286994','288115','288281','288758','288898','289457','289460','291588','291781','291785','291888','292058','292287','292437','292438','292439','292440','292441','292442','292443','292444','292445','292446','292447','292448','292449','292450','292451','292452','292453','292454','292455','292456','292457','292458','292459','292463','292464','292465','292467','292468','292541','293198','293382','293460','293510','293646','293928','294033','294217','294756','295296','295694','295695','297427','297685','297804','298371','299144','300994','300995','302168','161890','165416','165469','166094','166098','166890','167070','167322','241703','245418','245625','246251','246698','248473','254651','255111','262195','264860','265474','267116','267913','273945','274879','278884','282920','283118','284844','285690','286376','286441','287203','291635','292628','292780','293383','294218','294709','296198','297126','297190','297363','297444','298563','299080','295741','299040','303911') GROUP BY `manuf` ORDER BY `manuf` ASC

SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('153135','153890','154979','155860','155861','157671','157705','158551','158873','159796','159813','159963','160284','160440','160564','160566','160626','160868','160896','161043','161335','161347','161361','161390','161515','161890','161892','162200','162282','162332','162333','162397','162401','162512','162513','162743','162984','163402','163432','163924','164120','164364','164699','164828','164854','164968','165064','165230','165277','165387','165416','165469','165578','165598','166094','166098','166285','166601','166602','166603','166604','166605','166609','166890','166977','166978','166979','167056','167070','167191','167276','167303','167322','167340','167396','167397','167398','167400','167401','167480','167512','167513','167529','167560','167709','167757','167774','167775','167913','167918','167919','167993','168309','168310','232691','238017','238060','238078','238137','238155','238220','238559','239019','239574','239575','239866','239898','239903','239962','240300','240904','240915','241064','241694','241695','241700','241703','241876','241901','241925','241926','241927','241971','241972','241992','241995','242093','242228','242229','242349','242350','242532','242582','242614','242967','243075','243295','243299','243306','243320','243321','243322','243323','243472','243534','243614','243666','243718','243874','243981','243995','244035','244051','244094','244108','244138','244267','244268','244323','244472','244691','244968','244969','244970','244971','245096','245171','245328','245418','245572','245573','245590','245625','245834','245874','246023','246094','246095','246167','246251','246341','246348','246349','246448','246488','246616','246698','246789','246829','246917','246949','247048','247467','247706','247723','247739','247994','248106','248148','248149','248223','248277','248289','248290','248337','248412','248473','248486','248503','248505','248546','248597','248823','248917','249130','249216','249293','249403','249421','249679','249769','249778','249808','249809','250066','250507','250602','250604','250616','250654','250692','250856','251044','251212','251226','251232','251454','251592','251593','251594','251610','251739','251952','251973','251984','251990','252200','253024','253061','253132','253406','253494','253666','254438','254515','254651','255111','255170','255177','255322','255376','255592','255593','255594','255614','255705','255813','256269','256270','256271','256274','256275','256276','256701','256731','257075','261802','261803','261804','261805','261806','261807','261808','261809','261810','261811','261812','261813','261814','261815','261816','261817','261818','261819','261820','261821','261822','261823','261824','261825','261826','261827','261828','261829','261830','261831','261832','261833','261834','261835','261836','261837','261838','261839','261840','261841','261842','261843','261844','261845','261846','261847','261848','261849','261850','261851','261852','261853','261854','261855','261856','261857','261858','261859','261860','261861','261862','261863','261864','261865','261866','261867','261868','261869','261870','261871','261872','261873','261874','261875','261876','261877','261878','261879','261880','261881','261882','261883','261884','261885','261886','261887','261888','261889','261890','261891','261892','261893','261894','261895','261896','261897','261898','261899','261900','261901','261902','261903','261904','261905','261906','261907','261908','261909','261910','261911','261912','261913','261914','261915','261916','261917','261918','261919','261920','261921','261922','261923','261924','261925','261926','261927','261928','261929','261930','261931','261932','261951','261959','261982','262001','262070','262195','262197','262400','262435','262501','262502','262591','262662','262729','262730','262731','262732','262733','262734','262735','262736','262737','262858','263020','264371','264372','264535','264559','264560','264561','264562','264563','264570','264571','264572','264573','264574','264575','264576','264577','264578','264579','264580','264581','264582','264583','264585','264586','264587','264589','264590','264591','264592','264593','264594','264595','264596','264597','264598','264599','264600','264601','264602','264603','264604','264605','264606','264607','264608','264609','264651','264860','265014','265070','265098','265175','265176','265177','265178','265199','265211','265212','265213','265214','265215','265216','265217','265218','265219','265220','265221','265222','265223','265329','265474','265575','265592','265593','265816','265885','266109','266110','266192','266194','266207','266208','266209','266210','266211','266212','266213','266214','266215','266216','266217','266218','266517','266518','266519','266520','266521','266522','266523','266524','266525','266526','266527','266528','266529','266530','266531','266532','266533','266534','266535','266536','266537','266587','266596','266692','266777','266801','266802','266842','267026','267116','267406','267696','267697','267698','267898','267899','267900','267913','267975','267999','268005','268170','268171','268172','268173','268174','268175','268176','268177','268178','268179','268653','268654','268655','268656','268680','268717','268720','268721','268722','268723','268774','268870','269166','269202','269421','269546','269605','273367','273556','273596','273604','273661','273664','273670','273779','273782','273811','273812','273813','273814','273815','273816','273817','273818','273819','273820','273821','273822','273823','273843','273922','273924','273945','274273','274284','274335','274336','274379','274420','274421','274422','274503','274644','274879','274904','274926','274992','275004','275255','275256','275265','275295','275296','275426','275552','275855','275969','276083','276144','276453','276454','276557','276565','276699','277022','277190','277279','277716','277891','277894','278178','278397','278683','278778','278884','278978','278985','279191','279222','279232','279562','280472','280606','280980','281089','282154','282214','282215','282216','282217','282218','282229','282241','282242','282243','282244','282376','282877','282920','283118','283535','283640','283706','284230','284376','284612','284615','284844','284863','284921','284922','284923','284924','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285072','285330','285340','285341','285453','285460','285461','285562','285598','285606','285607','285690','285801','285863','285917','285972','286253','286376','286441','286797','286827','286828','286994','287203','287791','288115','288281','288758','288837','288838','288898','289066','289457','289460','291588','291635','291781','291785','291888','292058','292287','292437','292438','292439','292440','292441','292442','292443','292444','292445','292446','292447','292448','292449','292450','292451','292452','292453','292454','292455','292456','292458','292459','292463','292464','292465','292467','292468','292541','292628','292780','293198','293382','293383','293427','293460','293510','293522','293646','293928','294033','294217','294218','294709','294756','295296','295694','295695','295712','295741','296198','297126','297190','297363','297427','297444','297685','297804','298371','298563','299040','299053','299080','299144','299532','299900','300994','300995','302168','302250','302251','303911','303930','303931','303932') GROUP BY `manuf` ORDER BY `manuf` ASC