Устройства защиты, стр. 88

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 ('41','59','186','197','239','245','280','282','295','304','157708','202715','215232','232436','232689','242634','242825','248199','249188','249624','15','46','141226','141318','150473','156817','156818','156819','156820','156821','156822','162929','163035','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','215369','215556','215562','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','141220','141221','141222','141223','141224','141225','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150620','152543','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215433','215953','216049','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681','141378','141379','141410','141411','141537','141556','141611','141969','142000','142142','142214','142215','142707','142893','143224','143599','148847','150049','150050','150051','150052','150053','150054','150055','150056','150057','150058','150059','150060','150061','150062','150436','150642','150644','150645','150648','150650','151037','151330','151789','153426','153619','153629','154408','154731','155271','155272','155273','155274','155275','155302','155303','155657','157261','157263','157264','157266','157267','157587','157961','158269','158654','159019','159255','159772','160145','161905','161979','161980','163868','164286','164545','164546','164959','166251','166714','166993','167587','169318','169352','169827','202821','202822','211095','211096','211097','211098','211099','211100','211101','211102','211103','211104','211105','211106','211107','211108','211109','211110','211111','211112','211113','211114','211115','211116','211117','211118','211119','211120','211121','211122','211123','211124','211125','211126','211127','211128','211129','211130','211131','211132','211133','211134','211135','211136','211137','211138','211139','211140','211141','211142','211143','211144','211145','211146','211147','215288','215303','238661','238966','239217','239357','239719','239742','240353','241126','241282','241531','242433','244269','244781','245495','247119','247674','249263','249827','250233','251205','251759','253875','254769','255107','255908','256178','256179','256449','256500','256541','262946','263550','263704','264648','266219','266393','266417','267090','267836','268146','269124','269164','273456','273534','274278','274948','276416','277953','280956','281190','281690','284185','288275','288732','289221','291708','291709','291855','294611','294939','295426','295689','298165','298486','299143','300057','301002','304072','304078','141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151475','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','169179','169317','169328','169337','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289','303803','303883','303901','303902','303903','304020','304029','304099','304270','304271','304701','144286','147236','148123','148124','148126','148152','150201','150202','150203','150204','153585','158541','159079','160336','163844','164026','164551','164627','164646','164754','166243','168375','170386','202677','202718','212466','212467','212468','212469','212470','212471','212472','212473','212474','212475','212476','212477','212478','212479','212480','212481','212482','212483','212484','212485','212486','212487','212488','212489','212490','212491','212492','212493','212494','212495','212496','212497','212498','212499','212500','212501','212502','212503','212504','212505','212506','215989','239543','239707','239732','239998','240088','241429','242426','242947','244096','244197','244550','245894','246953','248714','248880','249064','249746','250832','264657','264658','264892','276113','281423','282670','292061','296271','298387','299548','300935','303844','157787','157788','157790','164253','243917','244429','288310','292860','141696','141767','141887','142877','142878','144225','146479','147048','148364','148407','149465','149466','150587','150592','151244','151618','153633','153946','153947','154775','154874','155133','155723','157428','157429','157430','157431','157434','157435','157623','157843','157968','158100','158388','158397','158399','158631','158640','158875','158876','158912','159452','159646','159853','160283','160537','160833','160858','160949','161346','161509','161601','161617','161954','162081','162144','162255','162268','162686','162866','162867','162902','162920','163039','163344','163834','163882','163955','164499','164645','164858','164899','164964','165503','165557','165648','165710','165754','166433','167036','167079','167081','167432','167551','167819','168381','170233','201265','208661','208662','208663','208664','208665','208666','208667','208668','208669','208670','208671','208672','208673','208674','208675','208676','208677','208678','208679','208680','208681','208682','208683','208684','208685','208686','208687','208688','208689','208690','208691','208692','208693','208694','208695','208696','208697','208698','208699','208700','208701','208702','208703','208704','208705','208706','208707','208708','208709','208710','208711','208712','208713','208714','208715','208716','208717','208718','208719','208720','208721','208722','208723','208724','208725','208726','208727','208728','208729','208730','208731','208732','208733','208734','208735','208736','208737','208738','208739','208740','208741','208742','208743','208744','208745','208746','208747','208748','208749','208750','208751','208752','208753','208754','208755','208756','208757','208758','208759','208760','208761','208762','208763','208764','208765','208766','208767','208768','208769','208770','208771','208772','208773','208774','208775','208776','215456','215729','215735','215855','215964','232520','238184','239127','239191','239192','239746','240526','240529','240629','240812','241076','241155','241406','241410','242324','243497','243533','244347','244760','244972','245002','245130','245167','245564','245692','245727','245757','246174','246236','246565','246717','246773','246899','247011','247161','247863','248000','248342','248695','248729','249173','249324','250195','250267','250640','250720','251341','251763','251834','252092','253630','253780','253825','254891','255224','255393','255997','256096','256099','256506','256510','256966','256972','257174','261800','261945','261947','262789','263546','264798','264853','265144','265375','265476','266116','266544','266915','266983','267214','267330','267941','268049','273964','274276','274624','275056','275093','275818','277673','277759','277800','278212','278476','278889','278927','281712','282838','283000','283214','285762','286013','286061','286065','286795','288010','291747','293224','293394','293452','294754','295163','295663','295665','295690','295692','295774','296284','297013','297457','298133','298389','299449','299559','299678','299711','300235','300552','301033','302195','141610','141956','142698','142730','144214','147214','147215','149679','149682','150325','150326','150640','151331','153653','154952','157436','160542','162227','165348','166092','166485','167412','167773','168079','168366','169178','169289','213062','213063','213064','213065','213066','213067','213068','213069','213070','213071','213072','213073','213074','213075','213076','213077','213078','213079','213080','213081','213082','213083','213084','213085','213086','213087','213088','213089','213090','213091','213092','213093','213094','213095','213096','213097','213098','213099','213100','213101','213102','213103','213104','213105','213106','213107','240592','243948','244187','244188','244229','244230','244232','244233','244234','244235','244236','244505','244565','247700','247937','249034','250079','253488','253489','253490','253491','254710','256507','256539','256705','257221','262587','262830','263104','264437','264441','264830','265119','265193','265350','265352','265386','265438','265762','266284','267215','267481','267690','268047','268048','268359','268563','268881','273398','273918','273919','274448','274720','274912','275053','275248','275500','275604','275783','277340','277345','277346','278063','278640','279367','279692','280410','280917','281255','281898','283229','284228','284736','285172','285612','286006','286826','287124','288122','291753','292362','292527','292576','292798','294665','297327','297860','298281','298369','298481','299105','299857','300276','302347','144184','149683','150327','150328','150329','150330','150331','150332','150333','150334','150335','150336','151269','161045','161046','161062','165514','168053','168054','170131','210478','213108','213109','213110','213111','213112','213113','213114','213115','213116','213117','213118','213119','213120','213121','213122','213123','213124','213125','213126','213127','213128','213129','213130','213131','213132','213133','213134','213135','213136','213137','213138','213139','213140','213141','213142','213143','213144','213145','213146','213147','213148','213149','213150','213151','213152','213153','213154','213155','213156','213157','213158','213159','213160','213161','213162','213163','213164','213165','213166','213167','213168','213169','213170','213171','213172','213173','213174','213175','213176','213177','215302','215317','219755','238380','238665','240327','242369','242457','242969','243081','243475','243476','243477','243478','243479','243480','243481','244228','244954','250912','250913','251596','253252','253253','253254','254721','266657','267522','267523','267524','267525','267526','267527','267992','273696','273916','275001','275617','275626','277069','277248','277343','277344','278759','281760','281764','284209','284356','284499','284596','285738','288261','291711','292032','292379','292753','293261','293375','293549','293550','294998','299059','302132','250680','279298','285442','300315','300337','300413','300414','303935','160767','160769','240075','245668','247544','249612','253504','274855','287128') 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 ('141220','141221','141222','141223','141224','141225','141226','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141318','141378','141379','141410','141411','141452','141504','141537','141539','141540','141556','141592','141593','141606','141607','141608','141609','141610','141611','141691','141696','141767','141819','141887','141956','141969','142000','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142142','142202','142203','142204','142205','142206','142207','142208','142214','142215','142234','142235','142523','142698','142707','142724','142730','142733','142734','142817','142875','142877','142878','142893','143224','143315','143410','143497','143599','144036','144037','144122','144183','144184','144185','144186','144187','144188','144189','144190','144191','144192','144214','144215','144225','144286','144288','144290','144296','145003','145016','146479','146950','147048','147203','147207','147210','147211','147212','147213','147214','147215','147236','147747','148123','148124','148126','148145','148152','148364','148407','148591','148847','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149465','149466','149643','149679','149682','149683','149691','149692','150049','150050','150051','150052','150053','150054','150055','150056','150057','150058','150059','150060','150061','150062','150201','150202','150203','150204','150325','150326','150327','150328','150329','150330','150331','150332','150333','150334','150335','150336','150436','150473','150534','150587','150592','150620','150640','150642','150644','150645','150648','150650','150739','150911','151029','151037','151208','151209','151244','151269','151274','151305','151306','151307','151330','151331','151361','151362','151475','151618','151789','152543','153426','153585','153619','153629','153633','153653','153773','153946','153947','154231','154408','154571','154661','154679','154730','154731','154732','154775','154791','154874','154952','155133','155271','155272','155273','155274','155275','155302','155303','155367','155657','155723','156817','156818','156819','156820','156821','156822','156959','156960','157261','157263','157264','157266','157267','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157433','157434','157435','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157583','157587','157623','157665','157708','157787','157788','157790','157843','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','157961','157968','158100','158269','158323','158339','158341','158388','158397','158399','158485','158486','158541','158631','158640','158654','158685','158757','158810','158811','158813','158875','158876','158912','159019','159079','159097','159098','159253','159255','159259','159340','159341','159369','159452','159552','159646','159772','159853','159916','160098','160132','160145','160157','160158','160283','160316','160336','160384','160537','160542','160767','160769','160813','160833','160858','160949','161045','161046','161062','161137','161182','161326','161327','161346','161423','161461','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161509','161528','161590','161601','161617','161809','161905','161933','161934','161935','161949','161954','161979','161980','162003','162029','162030','162031','162032','162080','162081','162144','162227','162255','162268','162379','162383','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','162672','162673','162686','162866','162867','162902','162920','162929','163035','163039','163344','163542','163607','163694','163695','163834','163844','163868','163882','163955','164026','164070','164155','164253','164271','164286','164499','164519','164545','164546','164551','164627','164645','164646','164754','164771','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164858','164899','164933','164959','164964','165025','165058','165094','165176','165180','165195','165331','165332','165348','165363','165379','165395','165503','165514','165557','165574','165648','165652','165657','165675','165694','165710','165731','165754','165840','165841','165853','165969','166016','166086','166092','166198','166242','166243','166251','166284','166324','166344','166422','166433','166471','166485','166611','166642','166701','166714','166735','166835','166883','166983','166993','167036','167079','167081','167118','167231','167245','167412','167432','167551','167587','167773','167790','167819','167900','168002','168031','168032','168053','168054','168079','168084','168127','168128','168152','168219','168333','168366','168375','168381','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','169178','169179','169289','169317','169318','169328','169337','169352','169754','169797','169827','170131','170233','170280','170313','170386','170428','170619','170715','170753','170780','170789','170790','170791','170792','170793','170794','170795','201265','201297','201298','201299','202572','202677','202715','202718','202785','202819','202821','202822','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','208661','208662','208663','208664','208665','208666','208667','208668','208669','208670','208671','208672','208673','208674','208675','208676','208677','208678','208679','208680','208681','208682','208683','208684','208685','208686','208687','208688','208689','208690','208691','208692','208693','208694','208695','208696','208697','208698','208699','208700','208701','208702','208703','208704','208705','208706','208707','208708','208709','208710','208711','208712','208713','208714','208715','208716','208717','208718','208719','208720','208721','208722','208723','208724','208725','208726','208727','208728','208729','208730','208731','208732','208733','208734','208735','208736','208737','208738','208739','208740','208741','208742','208743','208744','208745','208746','208747','208748','208749','208750','208751','208752','208753','208754','208755','208756','208757','208758','208759','208760','208761','208762','208763','208764','208765','208766','208767','208768','208769','208770','208771','208772','208773','208774','208775','208776','210478','210489','210490','211095','211096','211097','211098','211099','211100','211101','211102','211103','211104','211105','211106','211107','211108','211109','211110','211111','211112','211113','211114','211115','211116','211117','211118','211119','211120','211121','211122','211123','211124','211125','211126','211127','211128','211129','211130','211131','211132','211133','211134','211135','211136','211137','211138','211139','211140','211141','211142','211143','211144','211145','211146','211147','212466','212467','212468','212469','212470','212471','212472','212473','212474','212475','212476','212477','212478','212479','212480','212481','212482','212483','212484','212485','212486','212487','212488','212489','212490','212491','212492','212493','212494','212495','212496','212497','212498','212499','212500','212501','212502','212503','212504','212505','212506','213062','213063','213064','213065','213066','213067','213068','213069','213070','213071','213072','213073','213074','213075','213076','213077','213078','213079','213080','213081','213082','213083','213084','213085','213086','213087','213088','213089','213090','213091','213092','213093','213094','213095','213096','213097','213098','213099','213100','213101','213102','213103','213104','213105','213106','213107','213108','213109','213110','213111','213112','213113','213114','213115','213116','213117','213118','213119','213120','213121','213122','213123','213124','213125','213126','213127','213128','213129','213130','213131','213132','213133','213134','213135','213136','213137','213138','213139','213140','213141','213142','213143','213144','213145','213146','213147','213148','213149','213150','213151','213152','213153','213154','213155','213156','213157','213158','213159','213160','213161','213162','213163','213164','213165','213166','213167','213168','213169','213170','213171','213172','213173','213174','213175','213176','213177','215232','215288','215290','215301','215302','215303','215317','215369','215433','215456','215556','215562','215610','215729','215735','215855','215953','215964','215989','216038','216049','219755','232436','232444','232445','232520','232689','232720','238025','238042','238179','238184','238380','238661','238665','238809','238966','239110','239111','239112','239113','239114','239115','239116','239117','239127','239191','239192','239217','239310','239356','239357','239453','239543','239578','239616','239707','239713','239714','239719','239732','239742','239743','239746','239818','239835','239987','239998','239999','240009','240051','240075','240088','240114','240200','240286','240307','240327','240353','240526','240529','240586','240592','240629','240786','240787','240812','240936','240989','240990','240991','240992','241060','241076','241126','241155','241161','241282','241383','241406','241410','241429','241531','241734','241735','241787','241798','241850','241851','241864','241895','241962','241963','241964','241965','242101','242324','242334','242341','242369','242426','242433','242457','242489','242589','242603','242634','242706','242825','242904','242927','242947','242969','243081','243186','243211','243316','243436','243475','243476','243477','243478','243479','243480','243481','243497','243533','243724','243725','243744','243829','243916','243917','243948','243949','244096','244187','244188','244195','244197','244223','244224','244228','244229','244230','244232','244233','244234','244235','244236','244244','244269','244347','244429','244505','244538','244550','244554','244565','244591','244625','244718','244755','244760','244781','244798','244861','244865','244954','244972','245002','245130','245167','245495','245534','245564','245668','245692','245727','245751','245757','245811','245894','245924','246001','246002','246129','246138','246172','246174','246176','246236','246285','246309','246565','246679','246717','246719','246756','246773','246857','246899','246901','246934','246953','246962','247011','247107','247119','247161','247442','247543','247544','247674','247700','247732','247863','247930','247937','247940','248000','248081','248199','248252','248342','248421','248440','248533','248695','248714','248729','248761','248809','248880','248954','249001','249002','249003','249004','249005','249034','249064','249076','249103','249173','249188','249263','249324','249354','249392','249612','249624','249709','249746','249764','249827','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250079','250098','250195','250233','250244','250245','250246','250267','250353','250595','250640','250677','250680','250720','250832','250869','250912','250913','251175','251205','251217','251218','251219','251220','251288','251341','251463','251523','251548','251596','251677','251759','251763','251817','251834','252053','252092','253021','253022','253023','253209','253252','253253','253254','253373','253376','253417','253467','253488','253489','253490','253491','253504','253511','253627','253630','253736','253738','253762','253780','253791','253825','253846','253851','253865','253875','253902','254196','254326','254378','254379','254394','254445','254447','254710','254712','254721','254769','254771','254891','254937','255107','255161','255216','255224','255306','255393','255458','255677','255807','255838','255850','255908','255997','256096','256099','256178','256179','256219','256223','256247','256267','256272','256449','256500','256506','256507','256508','256510','256539','256541','256705','256771','256782','256783','256784','256840','256966','256972','257162','257174','257184','257221','261757','261777','261794','261800','261945','261947','262005','262007','262011','262182','262383','262576','262587','262754','262781','262789','262823','262830','262946','263061','263104','263514','263546','263550','263629','263660','263699','263704','264437','264441','264449','264648','264657','264658','264798','264830','264853','264866','264892','265051','265079','265119','265144','265152','265158','265164','265192','265193','265194','265195','265270','265336','265350','265352','265353','265356','265375','265386','265418','265421','265438','265468','265476','265536','265555','265559','265762','265870','265889','265892','265899','265915','265948','266095','266116','266138','266139','266219','266245','266274','266284','266322','266393','266417','266544','266623','266657','266684','266685','266686','266710','266755','266756','266864','266880','266915','266936','266983','267090','267103','267178','267214','267215','267251','267289','267325','267330','267481','267522','267523','267524','267525','267526','267527','267682','267690','267701','267703','267836','267941','267992','268000','268047','268048','268049','268066','268087','268146','268217','268234','268265','268291','268359','268563','268600','268769','268881','269124','269164','269402','269441','269549','269589','269597','269598','273335','273398','273456','273466','273521','273522','273534','273613','273695','273696','273724','273831','273916','273918','273919','273964','274276','274278','274298','274411','274448','274593','274624','274629','274720','274786','274790','274792','274842','274855','274891','274911','274912','274921','274948','274991','275001','275053','275056','275093','275229','275236','275248','275500','275600','275604','275617','275626','275655','275679','275783','275818','275836','276113','276130','276145','276250','276289','276295','276416','276438','276532','276578','276768','276780','276807','276941','276942','277014','277069','277174','277248','277306','277333','277340','277343','277344','277345','277346','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277673','277689','277759','277800','277830','277873','277953','278063','278105','278112','278114','278134','278135','278142','278157','278188','278212','278458','278468','278476','278477','278533','278599','278600','278601','278640','278744','278759','278871','278889','278927','279017','279061','279065','279074','279298','279299','279367','279404','279600','279692','279698','279756','279801','279825','280403','280410','280453','280538','280603','280604','280778','280780','280867','280870','280880','280917','280930','280931','280956','280987','281011','281112','281190','281255','281321','281330','281423','281494','281609','281685','281690','281712','281741','281760','281764','281859','281898','282144','282196','282356','282421','282492','282555','282670','282777','282838','282912','282921','282923','282924','283000','283058','283059','283214','283229','283330','283494','283792','284152','284153','284185','284209','284228','284284','284307','284356','284416','284499','284562','284596','284619','284736','284866','284994','285035','285058','285172','285182','285244','285302','285338','285441','285442','285514','285612','285738','285762','285766','286006','286013','286061','286065','286071','286322','286323','286795','286826','286964','287124','287128','287130','287506','287780','287969','288010','288122','288197','288198','288199','288200','288201','288212','288260','288261','288275','288310','288317','288531','288573','288611','288664','288709','288718','288719','288732','288755','288994','289221','289257','289400','289495','289496','289503','291708','291709','291711','291746','291747','291753','291832','291855','291857','291859','291860','291956','292032','292061','292225','292245','292304','292321','292322','292362','292379','292389','292527','292576','292718','292753','292779','292798','292806','292860','292873','292874','293224','293261','293375','293393','293394','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293452','293549','293550','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294227','294318','294358','294360','294502','294588','294603','294604','294611','294634','294635','294665','294754','294755','294939','294973','294998','295163','295364','295365','295366','295406','295426','295487','295645','295662','295663','295665','295689','295690','295692','295732','295774','295801','295830','296234','296271','296276','296278','296284','297012','297013','297138','297327','297429','297457','297585','297589','297849','297860','297921','297974','297975','297978','298056','298133','298165','298208','298224','298281','298287','298288','298365','298369','298387','298389','298478','298481','298486','298511','299030','299059','299105','299143','299191','299234','299376','299409','299439','299443','299449','299493','299548','299559','299655','299678','299711','299755','299756','299857','299934','299959','300022','300038','300057','300235','300259','300260','300276','300315','300337','300413','300414','300426','300434','300515','300552','300620','300631','300681','300935','301002','301033','302050','302132','302195','302204','302263','302264','302289','302347','303803','303844','303883','303901','303902','303903','303935','304020','304029') 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 ('41','59','186','197','239','245','280','282','295','304','157708','202715','215232','232436','232689','242634','242825','248199','249188','249624','15','46','141226','141318','150473','156817','156818','156819','156820','156821','156822','162929','163035','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','215369','215556','215562','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','141220','141221','141222','141223','141224','141225','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150620','152543','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215433','215953','216049','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681','141378','141379','141410','141411','141537','141556','141611','141969','142000','142142','142214','142215','142707','142893','143224','143599','148847','150049','150050','150051','150052','150053','150054','150055','150056','150057','150058','150059','150060','150061','150062','150436','150642','150644','150645','150648','150650','151037','151330','151789','153426','153619','153629','154408','154731','155271','155272','155273','155274','155275','155302','155303','155657','157261','157263','157264','157266','157267','157587','157961','158269','158654','159019','159255','159772','160145','161905','161979','161980','163868','164286','164545','164546','164959','166251','166714','166993','167587','169318','169352','169827','202821','202822','211095','211096','211097','211098','211099','211100','211101','211102','211103','211104','211105','211106','211107','211108','211109','211110','211111','211112','211113','211114','211115','211116','211117','211118','211119','211120','211121','211122','211123','211124','211125','211126','211127','211128','211129','211130','211131','211132','211133','211134','211135','211136','211137','211138','211139','211140','211141','211142','211143','211144','211145','211146','211147','215288','215303','238661','238966','239217','239357','239719','239742','240353','241126','241282','241531','242433','244269','244781','245495','247119','247674','249263','249827','250233','251205','251759','253875','254769','255107','255908','256178','256179','256449','256500','256541','262946','263550','263704','264648','266219','266393','266417','267090','267836','268146','269124','269164','273456','273534','274278','274948','276416','277953','280956','281190','281690','284185','288275','288732','289221','291708','291709','291855','294611','294939','295426','295689','298165','298486','299143','300057','301002','304072','304078','141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151475','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','169179','169317','169328','169337','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289','303803','303883','303901','303902','303903','304020','304029','304099','304270','304271','304701','144286','147236','148123','148124','148126','148152','150201','150202','150203','150204','153585','158541','159079','160336','163844','164026','164551','164627','164646','164754','166243','168375','170386','202677','202718','212466','212467','212468','212469','212470','212471','212472','212473','212474','212475','212476','212477','212478','212479','212480','212481','212482','212483','212484','212485','212486','212487','212488','212489','212490','212491','212492','212493','212494','212495','212496','212497','212498','212499','212500','212501','212502','212503','212504','212505','212506','215989','239543','239707','239732','239998','240088','241429','242426','242947','244096','244197','244550','245894','246953','248714','248880','249064','249746','250832','264657','264658','264892','276113','281423','282670','292061','296271','298387','299548','300935','303844','157787','157788','157790','164253','243917','244429','288310','292860','141696','141767','141887','142877','142878','144225','146479','147048','148364','148407','149465','149466','150587','150592','151244','151618','153633','153946','153947','154775','154874','155133','155723','157428','157429','157430','157431','157434','157435','157623','157843','157968','158100','158388','158397','158399','158631','158640','158875','158876','158912','159452','159646','159853','160283','160537','160833','160858','160949','161346','161509','161601','161617','161954','162081','162144','162255','162268','162686','162866','162867','162902','162920','163039','163344','163834','163882','163955','164499','164645','164858','164899','164964','165503','165557','165648','165710','165754','166433','167036','167079','167081','167432','167551','167819','168381','170233','201265','208661','208662','208663','208664','208665','208666','208667','208668','208669','208670','208671','208672','208673','208674','208675','208676','208677','208678','208679','208680','208681','208682','208683','208684','208685','208686','208687','208688','208689','208690','208691','208692','208693','208694','208695','208696','208697','208698','208699','208700','208701','208702','208703','208704','208705','208706','208707','208708','208709','208710','208711','208712','208713','208714','208715','208716','208717','208718','208719','208720','208721','208722','208723','208724','208725','208726','208727','208728','208729','208730','208731','208732','208733','208734','208735','208736','208737','208738','208739','208740','208741','208742','208743','208744','208745','208746','208747','208748','208749','208750','208751','208752','208753','208754','208755','208756','208757','208758','208759','208760','208761','208762','208763','208764','208765','208766','208767','208768','208769','208770','208771','208772','208773','208774','208775','208776','215456','215729','215735','215855','215964','232520','238184','239127','239191','239192','239746','240526','240529','240629','240812','241076','241155','241406','241410','242324','243497','243533','244347','244760','244972','245002','245130','245167','245564','245692','245727','245757','246174','246236','246565','246717','246773','246899','247011','247161','247863','248000','248342','248695','248729','249173','249324','250195','250267','250640','250720','251341','251763','251834','252092','253630','253780','253825','254891','255224','255393','255997','256096','256099','256506','256510','256966','256972','257174','261800','261945','261947','262789','263546','264798','264853','265144','265375','265476','266116','266544','266915','266983','267214','267330','267941','268049','273964','274276','274624','275056','275093','275818','277673','277759','277800','278212','278476','278889','278927','281712','282838','283000','283214','285762','286013','286061','286065','286795','288010','291747','293224','293394','293452','294754','295163','295663','295665','295690','295692','295774','296284','297013','297457','298133','298389','299449','299559','299678','299711','300235','300552','301033','302195','141610','141956','142698','142730','144214','147214','147215','149679','149682','150325','150326','150640','151331','153653','154952','157436','160542','162227','165348','166092','166485','167412','167773','168079','168366','169178','169289','213062','213063','213064','213065','213066','213067','213068','213069','213070','213071','213072','213073','213074','213075','213076','213077','213078','213079','213080','213081','213082','213083','213084','213085','213086','213087','213088','213089','213090','213091','213092','213093','213094','213095','213096','213097','213098','213099','213100','213101','213102','213103','213104','213105','213106','213107','240592','243948','244187','244188','244229','244230','244232','244233','244234','244235','244236','244505','244565','247700','247937','249034','250079','253488','253489','253490','253491','254710','256507','256539','256705','257221','262587','262830','263104','264437','264441','264830','265119','265193','265350','265352','265386','265438','265762','266284','267215','267481','267690','268047','268048','268359','268563','268881','273398','273918','273919','274448','274720','274912','275053','275248','275500','275604','275783','277340','277345','277346','278063','278640','279367','279692','280410','280917','281255','281898','283229','284228','284736','285172','285612','286006','286826','287124','288122','291753','292362','292527','292576','292798','294665','297327','297860','298281','298369','298481','299105','299857','300276','302347','144184','149683','150327','150328','150329','150330','150331','150332','150333','150334','150335','150336','151269','161045','161046','161062','165514','168053','168054','170131','210478','213108','213109','213110','213111','213112','213113','213114','213115','213116','213117','213118','213119','213120','213121','213122','213123','213124','213125','213126','213127','213128','213129','213130','213131','213132','213133','213134','213135','213136','213137','213138','213139','213140','213141','213142','213143','213144','213145','213146','213147','213148','213149','213150','213151','213152','213153','213154','213155','213156','213157','213158','213159','213160','213161','213162','213163','213164','213165','213166','213167','213168','213169','213170','213171','213172','213173','213174','213175','213176','213177','215302','215317','219755','238380','238665','240327','242369','242457','242969','243081','243475','243476','243477','243478','243479','243480','243481','244228','244954','250912','250913','251596','253252','253253','253254','254721','266657','267522','267523','267524','267525','267526','267527','267992','273696','273916','275001','275617','275626','277069','277248','277343','277344','278759','281760','281764','284209','284356','284499','284596','285738','288261','291711','292032','292379','292753','293261','293375','293549','293550','294998','299059','302132','250680','279298','285442','300315','300337','300413','300414','303935','160767','160769','240075','245668','247544','249612','253504','274855','287128') 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 ('141220','141221','141222','141223','141224','141225','141226','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141318','141378','141379','141410','141411','141452','141504','141537','141539','141540','141556','141592','141593','141606','141607','141608','141609','141610','141611','141691','141696','141767','141819','141887','141956','141969','142000','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142142','142202','142203','142204','142205','142206','142207','142208','142214','142215','142234','142235','142523','142698','142707','142724','142730','142733','142734','142817','142875','142877','142878','142893','143224','143315','143410','143497','143599','144036','144037','144122','144183','144184','144185','144186','144187','144188','144189','144190','144191','144192','144214','144215','144225','144286','144288','144290','144296','145003','145016','146479','146950','147048','147203','147207','147210','147211','147212','147213','147214','147215','147236','147747','148123','148124','148126','148145','148152','148364','148407','148591','148847','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149465','149466','149643','149679','149682','149683','149691','149692','150049','150050','150051','150052','150053','150054','150055','150056','150057','150058','150059','150060','150061','150062','150201','150202','150203','150204','150325','150326','150327','150328','150329','150330','150331','150332','150333','150334','150335','150336','150436','150473','150534','150587','150592','150620','150640','150642','150644','150645','150648','150650','150739','150911','151029','151037','151208','151209','151244','151269','151274','151305','151306','151307','151330','151331','151361','151362','151475','151618','151789','152543','153426','153585','153619','153629','153633','153653','153773','153946','153947','154231','154408','154571','154661','154679','154730','154731','154732','154775','154791','154874','154952','155133','155271','155272','155273','155274','155275','155302','155303','155367','155657','155723','156817','156818','156819','156820','156821','156822','156959','156960','157261','157263','157264','157266','157267','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157433','157434','157435','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157583','157587','157623','157665','157708','157787','157788','157790','157843','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','157961','157968','158100','158269','158323','158339','158341','158388','158397','158399','158485','158486','158541','158631','158640','158654','158685','158757','158810','158811','158813','158875','158876','158912','159019','159079','159097','159098','159253','159255','159259','159340','159341','159369','159452','159552','159646','159772','159853','159916','160098','160132','160145','160157','160158','160283','160316','160336','160384','160537','160542','160767','160769','160813','160833','160858','160949','161045','161046','161062','161137','161182','161326','161327','161346','161423','161461','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161509','161528','161590','161601','161617','161809','161905','161933','161934','161935','161949','161954','161979','161980','162003','162029','162030','162031','162032','162080','162081','162144','162227','162255','162268','162379','162383','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','162672','162673','162686','162866','162867','162902','162920','162929','163035','163039','163344','163542','163607','163694','163695','163834','163844','163868','163882','163955','164026','164070','164155','164253','164271','164286','164499','164519','164545','164546','164551','164627','164645','164646','164754','164771','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164858','164899','164933','164959','164964','165025','165058','165094','165176','165180','165195','165331','165332','165348','165363','165379','165395','165503','165514','165557','165574','165648','165652','165657','165675','165694','165710','165731','165754','165840','165841','165853','165969','166016','166086','166092','166198','166242','166243','166251','166284','166324','166344','166422','166433','166471','166485','166611','166642','166701','166714','166735','166835','166883','166983','166993','167036','167079','167081','167118','167231','167245','167412','167432','167551','167587','167773','167790','167819','167900','168002','168031','168032','168053','168054','168079','168084','168127','168128','168152','168219','168333','168366','168375','168381','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','169178','169179','169289','169317','169318','169328','169337','169352','169754','169797','169827','170131','170233','170280','170313','170386','170428','170619','170715','170753','170780','170789','170790','170791','170792','170793','170794','170795','201265','201297','201298','201299','202572','202677','202715','202718','202785','202819','202821','202822','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','208661','208662','208663','208664','208665','208666','208667','208668','208669','208670','208671','208672','208673','208674','208675','208676','208677','208678','208679','208680','208681','208682','208683','208684','208685','208686','208687','208688','208689','208690','208691','208692','208693','208694','208695','208696','208697','208698','208699','208700','208701','208702','208703','208704','208705','208706','208707','208708','208709','208710','208711','208712','208713','208714','208715','208716','208717','208718','208719','208720','208721','208722','208723','208724','208725','208726','208727','208728','208729','208730','208731','208732','208733','208734','208735','208736','208737','208738','208739','208740','208741','208742','208743','208744','208745','208746','208747','208748','208749','208750','208751','208752','208753','208754','208755','208756','208757','208758','208759','208760','208761','208762','208763','208764','208765','208766','208767','208768','208769','208770','208771','208772','208773','208774','208775','208776','210478','210489','210490','211095','211096','211097','211098','211099','211100','211101','211102','211103','211104','211105','211106','211107','211108','211109','211110','211111','211112','211113','211114','211115','211116','211117','211118','211119','211120','211121','211122','211123','211124','211125','211126','211127','211128','211129','211130','211131','211132','211133','211134','211135','211136','211137','211138','211139','211140','211141','211142','211143','211144','211145','211146','211147','212466','212467','212468','212469','212470','212471','212472','212473','212474','212475','212476','212477','212478','212479','212480','212481','212482','212483','212484','212485','212486','212487','212488','212489','212490','212491','212492','212493','212494','212495','212496','212497','212498','212499','212500','212501','212502','212503','212504','212505','212506','213062','213063','213064','213065','213066','213067','213068','213069','213070','213071','213072','213073','213074','213075','213076','213077','213078','213079','213080','213081','213082','213083','213084','213085','213086','213087','213088','213089','213090','213091','213092','213093','213094','213095','213096','213097','213098','213099','213100','213101','213102','213103','213104','213105','213106','213107','213108','213109','213110','213111','213112','213113','213114','213115','213116','213117','213118','213119','213120','213121','213122','213123','213124','213125','213126','213127','213128','213129','213130','213131','213132','213133','213134','213135','213136','213137','213138','213139','213140','213141','213142','213143','213144','213145','213146','213147','213148','213149','213150','213151','213152','213153','213154','213155','213156','213157','213158','213159','213160','213161','213162','213163','213164','213165','213166','213167','213168','213169','213170','213171','213172','213173','213174','213175','213176','213177','215232','215288','215290','215301','215302','215303','215317','215369','215433','215456','215556','215562','215610','215729','215735','215855','215953','215964','215989','216038','216049','219755','232436','232444','232445','232520','232689','232720','238025','238042','238179','238184','238380','238661','238665','238809','238966','239110','239111','239112','239113','239114','239115','239116','239117','239127','239191','239192','239217','239310','239356','239357','239453','239543','239578','239616','239707','239713','239714','239719','239732','239742','239743','239746','239818','239835','239987','239998','239999','240009','240051','240075','240088','240114','240200','240286','240307','240327','240353','240526','240529','240586','240592','240629','240786','240787','240812','240936','240989','240990','240991','240992','241060','241076','241126','241155','241161','241282','241383','241406','241410','241429','241531','241734','241735','241787','241798','241850','241851','241864','241895','241962','241963','241964','241965','242101','242324','242334','242341','242369','242426','242433','242457','242489','242589','242603','242634','242706','242825','242904','242927','242947','242969','243081','243186','243211','243316','243436','243475','243476','243477','243478','243479','243480','243481','243497','243533','243724','243725','243744','243829','243916','243917','243948','243949','244096','244187','244188','244195','244197','244223','244224','244228','244229','244230','244232','244233','244234','244235','244236','244244','244269','244347','244429','244505','244538','244550','244554','244565','244591','244625','244718','244755','244760','244781','244798','244861','244865','244954','244972','245002','245130','245167','245495','245534','245564','245668','245692','245727','245751','245757','245811','245894','245924','246001','246002','246129','246138','246172','246174','246176','246236','246285','246309','246565','246679','246717','246719','246756','246773','246857','246899','246901','246934','246953','246962','247011','247107','247119','247161','247442','247543','247544','247674','247700','247732','247863','247930','247937','247940','248000','248081','248199','248252','248342','248421','248440','248533','248695','248714','248729','248761','248809','248880','248954','249001','249002','249003','249004','249005','249034','249064','249076','249103','249173','249188','249263','249324','249354','249392','249612','249624','249709','249746','249764','249827','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250079','250098','250195','250233','250244','250245','250246','250267','250353','250595','250640','250677','250680','250720','250832','250869','250912','250913','251175','251205','251217','251218','251219','251220','251288','251341','251463','251523','251548','251596','251677','251759','251763','251817','251834','252053','252092','253021','253022','253023','253209','253252','253253','253254','253373','253376','253417','253467','253488','253489','253490','253491','253504','253511','253627','253630','253736','253738','253762','253780','253791','253825','253846','253851','253865','253875','253902','254196','254326','254378','254379','254394','254445','254447','254710','254712','254721','254769','254771','254891','254937','255107','255161','255216','255224','255306','255393','255458','255677','255807','255838','255850','255908','255997','256096','256099','256178','256179','256219','256223','256247','256267','256272','256449','256500','256506','256507','256508','256510','256539','256541','256705','256771','256782','256783','256784','256840','256966','256972','257162','257174','257184','257221','261757','261777','261794','261800','261945','261947','262005','262007','262011','262182','262383','262576','262587','262754','262781','262789','262823','262830','262946','263061','263104','263514','263546','263550','263629','263660','263699','263704','264437','264441','264449','264648','264657','264658','264798','264830','264853','264866','264892','265051','265079','265119','265144','265152','265158','265164','265192','265193','265194','265195','265270','265336','265350','265352','265353','265356','265375','265386','265418','265421','265438','265468','265476','265536','265555','265559','265762','265870','265889','265892','265899','265915','265948','266095','266116','266138','266139','266219','266245','266274','266284','266322','266393','266417','266544','266623','266657','266684','266685','266686','266710','266755','266756','266864','266880','266915','266936','266983','267090','267103','267178','267214','267215','267251','267289','267325','267330','267481','267522','267523','267524','267525','267526','267527','267682','267690','267701','267703','267836','267941','267992','268000','268047','268048','268049','268066','268087','268146','268217','268234','268265','268291','268359','268563','268600','268769','268881','269124','269164','269402','269441','269549','269589','269597','269598','273335','273398','273456','273466','273521','273522','273534','273613','273695','273696','273724','273831','273916','273918','273919','273964','274276','274278','274298','274411','274448','274593','274624','274629','274720','274786','274790','274792','274842','274855','274891','274911','274912','274921','274948','274991','275001','275053','275056','275093','275229','275236','275248','275500','275600','275604','275617','275626','275655','275679','275783','275818','275836','276113','276130','276145','276250','276289','276295','276416','276438','276532','276578','276768','276780','276807','276941','276942','277014','277069','277174','277248','277306','277333','277340','277343','277344','277345','277346','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277673','277689','277759','277800','277830','277873','277953','278063','278105','278112','278114','278134','278135','278142','278157','278188','278212','278458','278468','278476','278477','278533','278599','278600','278601','278640','278744','278759','278871','278889','278927','279017','279061','279065','279074','279298','279299','279367','279404','279600','279692','279698','279756','279801','279825','280403','280410','280453','280538','280603','280604','280778','280780','280867','280870','280880','280917','280930','280931','280956','280987','281011','281112','281190','281255','281321','281330','281423','281494','281609','281685','281690','281712','281741','281760','281764','281859','281898','282144','282196','282356','282421','282492','282555','282670','282777','282838','282912','282921','282923','282924','283000','283058','283059','283214','283229','283330','283494','283792','284152','284153','284185','284209','284228','284284','284307','284356','284416','284499','284562','284596','284619','284736','284866','284994','285035','285058','285172','285182','285244','285302','285338','285441','285442','285514','285612','285738','285762','285766','286006','286013','286061','286065','286071','286322','286323','286795','286826','286964','287124','287128','287130','287506','287780','287969','288010','288122','288197','288198','288199','288200','288201','288212','288260','288261','288275','288310','288317','288531','288573','288611','288664','288709','288718','288719','288732','288755','288994','289221','289257','289400','289495','289496','289503','291708','291709','291711','291746','291747','291753','291832','291855','291857','291859','291860','291956','292032','292061','292225','292245','292304','292321','292322','292362','292379','292389','292527','292576','292718','292753','292779','292798','292806','292860','292873','292874','293224','293261','293375','293393','293394','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293452','293549','293550','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294227','294318','294358','294360','294502','294588','294603','294604','294611','294634','294635','294665','294754','294755','294939','294973','294998','295163','295364','295365','295366','295406','295426','295487','295645','295662','295663','295665','295689','295690','295692','295732','295774','295801','295830','296234','296271','296276','296278','296284','297012','297013','297138','297327','297429','297457','297585','297589','297849','297860','297921','297974','297975','297978','298056','298133','298165','298208','298224','298281','298287','298288','298365','298369','298387','298389','298478','298481','298486','298511','299030','299059','299105','299143','299191','299234','299376','299409','299439','299443','299449','299493','299548','299559','299655','299678','299711','299755','299756','299857','299934','299959','300022','300038','300057','300235','300259','300260','300276','300315','300337','300413','300414','300426','300434','300515','300552','300620','300631','300681','300935','301002','301033','302050','302132','302195','302204','302263','302264','302289','302347','303803','303844','303883','303901','303902','303903','303935','304020','304029') GROUP BY `manuf` ORDER BY `manuf` ASC