Пайка и монтаж, стр. 2

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 ('32','35','50','72','79','93','101','159','172','178','179','180','183','189','267','143603','151482','155732','157950','158571','161379','162053','163677','163678','164889','166341','166345','166346','166347','166348','166349','166350','166351','166352','166353','166354','166355','166356','166357','166358','166359','166360','166361','166362','166363','166364','166365','166366','166367','166368','166369','166370','166371','166372','166373','166374','166375','166376','166377','166378','166379','166380','166381','166382','166383','166384','166385','166386','166387','166388','166389','166390','166391','166392','166791','170410','201171','210512','210513','214390','214391','214392','214393','214394','214395','214396','214397','214398','214399','214400','214401','232523','239569','239710','240512','243987','244089','244098','244258','244260','246571','246572','246573','246574','246575','246576','246577','246578','246579','246580','246581','247828','247830','247832','247833','247835','247843','247846','247847','248757','249179','249180','250064','250593','250594','251179','251650','251670','255666','255714','255715','256442','256443','264478','273649','160901','251746','273555','280598','284251','284259','285656','289337','292534','150366','150367','150368','150369','150370','150371','150372','150373','150374','150375','150376','150377','150378','150379','150380','150381','150382','150383','151640','153404','162204','163502','163503','163504','163505','163506','163507','163509','163510','170739','170740','170748','201166','213492','213493','213494','213495','213496','213498','213499','213500','213501','213502','213503','213504','213505','213506','213507','213508','213509','213510','213511','213512','213513','213514','213515','213516','213517','213518','213519','213520','213521','213522','213523','213524','213525','213526','213527','213528','213529','213530','213531','213532','213533','213534','213535','213536','213537','213538','213539','213540','213541','213542','213543','213544','213545','213546','213547','213548','213549','213550','213551','215547','244256','246345','253309','253310','253311','253312','253313','253314','253315','253316','253317','253318','263755','263756','266469','269606','273369','273854','275992','276054','279334','285254','295332','297508','299494','299662','300670','302309','304191','304614','213564','213565','213566','213567','213568','213569','213570','213571','213572','213573','213574','213575','213576','213577','213578','213579','213580','213581','213582','213583','213584','213585','213586','213587','213588','213589','213590','213591','213592','213593','213594','213595','213596','213597','213598','213599','213600','213601','213602','213603','213604','213605','213606','213607','213608','213609','213610','213611','250248','143168','143169','143225','143302','143310','143487','144209','147227','150384','150386','150387','150388','150389','150390','150391','150392','150393','150394','150395','150396','150397','150398','150399','150400','151954','159580','161488','161489','161490','161491','161492','161493','161494','161495','163455','163456','163457','165534','165535','169878','169879','169888','169894','169895','169912','170057','170058','170065','170171','170172','170201','170202','170324','170489','170490','170491','170492','170493','170494','170742','170743','170744','201168','201170','201172','201304','202801','202802','210510','213612','213613','213614','213615','213616','213617','213618','213619','213620','213621','213622','213623','213624','213625','213626','213627','213628','213629','213630','213631','213632','213633','213634','213635','213636','213637','213638','213639','213640','213641','213642','213643','213644','213645','213646','213647','213648','213649','213650','213651','213652','213653','213654','213655','213656','213657','213658','213659','213660','213661','213662','213663','213664','213665','213666','213667','213668','213669','213670','213671','213672','213673','213674','213675','213676','213677','213678','213679','213680','213681','213682','213683','213684','213685','213686','213687','213688','213689','213690','213691','213692','213693','213694','213695','213696','213697','213698','213699','213700','213701','213702','213703','213704','213705','213706','213707','213708','213709','213710','213711','213712','213713','213714','213715','213716','213717','213718','213719','213720','213721','213722','213723','213724','213725','213726','213727','213728','213729','213730','213731','213732','213733','213734','213735','213736','213737','213738','213739','213740','213741','213742','213743','213744','213745','213746','213747','213748','213749','213750','213751','213752','213753','213754','213755','215984','239568','239708','239709','244257','244261','247834','247844','247845','247848','247987','248623','248624','248625','248626','248629','248630','248631','248632','248633','248634','248635','248636','248908','249545','249766','250215','251261','251346','255551','255552','255553','263577','263639','264939','265230','265231','265232','265260','268418','268659','274151','275608','275633','275948','276347','276419','278496','283097','285241','285327','296241','298240','298314','298315','299720','302362','304235','304615','142971','143678','143703','144211','148057','149706','150069','150070','150071','150072','150073','150074','150401','153083','153084','158966','158967','159038','159455','159544','160836','160837','161302','163161','163225','163226','163319','163453','164022','164256','164503','164693','164872','165288','165290','165291','165292','165542','165640','165875','165963','165964','166338','166342','166411','166756','166757','166758','166759','166780','166803','166804','166805','166806','166807','166808','166809','166810','166811','166812','166813','166814','166815','166816','166817','166818','167028','167180','167239','167381','167493','167494','167495','167496','168000','168001','169937','169946','170059','170060','170063','170064','170279','170479','170481','170482','170483','170484','170508','170747','170750','170752','201236','201301','201305','201306','201320','202687','202698','202700','202727','202803','202817','210509','210511','211302','211303','211304','211305','211306','211307','211308','211309','211310','211311','211312','211313','211314','211315','211316','211317','211318','211319','211320','211321','211322','211323','211324','211325','211326','211327','211328','211329','211330','211331','211332','211333','211334','211335','211336','211337','211338','211339','211340','211341','211342','211343','211344','211345','211346','211347','211348','211349','211350','211351','211352','211353','211354','211355','211356','211357','211358','211359','211360','211361','211362','211363','211364','211365','211366','211367','211368','211369','211370','211371','211372','211373','211374','211375','211376','211377','211378','211379','211380','211381','211382','211383','211384','211385','211386','211387','211388','211389','211390','211391','211392','211393','211394','211395','211396','211397','211398','211399','211400','211401','211402','211403','211404','211405','211406','211407','211408','211409','211410','211411','211412','211413','211414','211415','211416','211417','211418','211419','211420','211421','211422','211423','211424','211425','211426','211427','211428','211429','211430','211431','211432','211433','211434','211435','211436','211437','211438','211439','211440','211441','211442','211443','211444','211445','211446','211447','211448','211449','211450','211451','211452','211453','211454','211455','211456','211457','211458','211459','211460','211461','211462','211463','211464','211465','213838','213839','213840','213841','213842','213843','213844','213845','213846','213847','213848','213849','213850','213851','213852','213853','213854','213855','213856','213857','213858','213859','213860','213861','213862','213863','213864','213865','213866','213867','213868','213869','213870','213871','213872','213873','213874','213875','213876','213877','213878','213879','213880','213881','213882','213883','213884','213885','213886','213887','213888','213889','213890','213891','213892','213893','213894','213895','213896','213897','213898','213899','213900','213901','213902','213903','213904','213905','213906','213907','213908','213909','213910','213911','213912','213913','213914','213915','213916','213917','213918','213919','213920','213921','213922','213923','213924','213925','213926','213927','213928','213929','213930','213931','213932','213933','213934','213935','213936','213937','213938','213939','213940','213941','213942','213943','213944','213945','213946','213947','213948','213949','213950','213951','213952','213953','213954','213955','213956','213957','213958','213959','213960','213961','213962','213963','213964','213965','213966','213967','213968','213969','213970','213971','213972','213973','213974','213975','213976','213977','213978','213979','213980','213981','213982','213983','213984','213985','213986','213987','213999','214000','214001','214002','214003','214004','214005','214006','214007','214008','214009','214010','214011','214012','214013','214014','214015','214016','214017','214018','214019','214020','214021','214022','214025','214029','214030','214031','214032','214033','214034','214035','214036','214037','214038','214039','214040','214041','214042','214043','214044','214045','214046','214047','214048','214049','214050','214051','214052','214053','214054','214055','214056','214057','214058','214059','214060','214061','214062','214063','214064','214065','214066','214067','214068','214069','214070','214071','215248','215431','215500','215622','215776','215798','215897','232398','232407','232408','232429','232430','232431','232432','232435','239697','240044','240119','240271','240272','240273','240274','240337','240582','241551','241685','241883','241903','243032','243148','243176','243319','243411','243870','244255','244669','244765','244766','244768','245456','245589','246010','246011','246032','246033','246057','246060','246506','246507','246508','246509','246510','246511','246512','246513','246514','246515','246516','246517','247208','247277','247286','247287','247299','247300','247335','247829','248109','248124','248125','248520','249063','249174','249175','249176','249351','249406','249591','249622','249745','249884','250027','250028','250029','250030','250031','250032','250033','250034','250035','250036','250037','250038','250054','250067','250068','250069','250102','250349','250535','250536','250537','250538','250564','250565','250566','250567','250568','250569','250570','250571','250572','250573','250960','251284','251337','251524','251525','251526','251527','251528','251529','251530','251531','251532','251533','251534','251535','251536','251537','251538','251609','251661','253120','253207','253283','254648','255516','255530','256024','256071','256074','256204','256358','256359','256597','256950','257231','261971','261972','262363','262364','262365','262411','262436','262927','263659','264442','265047','265066','265067','265130','265131','265132','265133','265302','265325','265616','265617','265618','265697','265957','265962','265967','266514','267604','267777','267779','267780','267879','268064','268113','268114','268128','269115','269161','269404','269405','269424','269425','273443','273898','273914','274026','274036','274371','274831','274998','275122','275123','275124','275131','275488','276284','276680','276695','276775','277483','278087','278261','278262','278263','278264','278296','278297','278298','278299','278300','278301','278514','278515','278516','278557','278751','278817','278818','279192','279306','279407','280333','280466','281795','281796','281797','281798','281866','282034','282104','282156','282157','282279','282280','282294','282315','282316','282318','282319','282320','282321','282489','282890','283342','283495','285157','285163','285636','285730','285769','286356','286384','286607','288131','288601','288995','289086','291690','291705','291769','291871','292306','292408','292409','292579','292688','292695','292712','293602','294066','295283','295341','296239','297023','297272','297292','297714','298176','298250','298587','299258','299382','299695','299908','300033','300070','300273','300508','300509','300510','300511','300655','300676','300699','300711','301795','301834','302227','303828','303972','304616','304617','304618','304619','304620','304621','304622','304623','304624','304625','304626','304627','304628','304629','304630','304631','143303','143304','143484','143485','150402','150403','161496','163861','170488','214072','214073','214074','214075','214076','214077','214078','214079','214080','214081','239663','239664','241975','243225','244643','245525','248059','248622','249477','249493','251170','254625','261798','263576','264842','264843','264979','265295','267595','268104','275642','284337','284546','287200','294683','144212','148161','150085','150086','154946','157558','163397','163398','163399','165641','169820','170200','170745','211542','211543','211544','211545','214082','214083','214084','214085','214086','214087','214088','214089','214090','214091','214092','214093','214094','214095','214096','214097','214098','214099','214100','214101','214102','214103','214104','214105','214106','214107','214108','214109','214110','214111','214112','214113','214114','214115','214116','214117','214118','214119','214120','214121','214122','214123','214124','214125','214126','214127','214128','214129','214130','214131','214132','239847','244158','244947','247043','248627','248628','248992','249262','249882','249883','249938','249946','254984','256256','256322','256748','256772','256773','256774','256775','256776','263575','265504','267778','269446','273862','274142','277515','283038','284673','286830','288998','288999','289000','295620','295853','295855','295856','295857','295858','295859','295860','295861','301893','143309','147385','150404','162485','163511','169882','169883','170056','170061','170062','170173','170174','170175','170196','170197','170741','170751','201169','214133','214134','214135','214136','214137','214138','214139','214140','214141','214142','214143','214144','214145','214146','214147','214148','214149','214150','214151','214152','214153','214154','214155','214156','214157','214158','214159','214160','214161','214162','214163','214164','214165','214166','214167','214168','214169','214170','214171','214172','214173','214174','214175','214176','214177','214178','214179','214180','214181','214182','214183','214184','214185','214186','214187','214188','214189','214190','214191','214192','214193','214194','214195','214196','214197','214198','214199','241278','249891','249892','294668','161719','161720','161721','161722','165289','165383','165384','214200','214201','214202','214203','214204','214205','214206','214207','214208','214209','214210','214211','214212','214213','214214','214215','214216','214217','214218','214219','214220','214221','214222','214223','214224','214225','214226','214227','214228','214229','214230','214231','214232','214233','214234','214235','214236','214237','214238','214239','214240','214241','214242','214243','214244','214245','214246','214247','214248','214249','214250','214251','214252','214253','214254','214255','214256','214257','214258','214259','214260','214261','214262','214263','214264','214265','214266','214267','214268','214269','214270','214271','214272','214273','214274','214275','214276','214277','214278','214279','214280','214281','214282','214283','214284','214285','214286','214287','214288','214303','214304','214305','214306','214307','214308','214309','214310','214311','214312','214313','214314','214315','214316','214317','214318','214319','214320','214321','214322','214323','214325','214326','214327','214328','214329','214330','214331','214332','214333','214334','214335','214336','214337','214338','214339','214340','214341','214342','214343','214344','214345','214346','214347','214348','214349','214350','214351','214352','214353','214354','214355','214356','214357','214358','214359','214360','214361','214362','214363','214364','214365','214366','214367','214368','214369','214370','214371','214372','214373','214374','214375','214376','214377','214378','214379','214380','214381','214382','214383','214384','214385','214386','214387','214388','214389','243187','243410','246096','247012','247824','247825','247826','247827','248882','250343','250458','250510','265042','273317','273318','286136','288756','289203','304632','304633','304634','304635','304636','304637','304638','304639','304640','304641','304642','304643','304644','304645','304646','143480','143670','150405','150406','150407','150408','150409','158410','161487','163454','165356','165674','165678','170183','170239','170486','170487','214402','214403','214404','214405','214406','214407','214408','214409','214410','214411','214412','214413','214414','214415','214416','214417','214418','214419','214420','214421','214422','214423','214424','214425','214426','239662','243844','249586','251423','251477','254302','255349','256120','256792','264633','265532','268512','268804','268805','268808','269109','276024','278406','280999','281000','281127','281780','282758','283184','283185','283186','284253','284254','284256','284257','284258','287108','295588','295851','295852','298260','300208','147068','150181','150182','150183','150184','150410','150411','150412','150413','150414','150415','150416','150417','150418','153216','153217','153218','159399','161110','161486','161518','161519','166395','166396','166397','170782','170783','170784','212039','212040','212041','212042','212043','212044','212045','212046','212047','212048','212049','212050','212051','212052','212053','212054','212055','212056','212057','212058','212059','212060','212061','212062','212063','212064','212065','212066','212067','212068','212069','212070','212071','212072','212073','212074','212075','212076','212077','212078','212079','212080','212081','212082','212083','212084','212085','212086','212087','214427','214428','214429','214430','214431','214432','214433','214434','214435','214436','214437','214438','214439','214440','214441','214442','214443','214444','214445','214446','214447','214448','214449','214450','214451','214452','214453','214454','214455','214456','214457','214458','214459','214460','214461','214462','214463','214464','214465','214466','214467','214468','214469','214470','214471','214472','214473','214474','214475','214476','214477','214478','214479','214480','214481','214482','214483','214484','214485','214486','214487','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534','214535','214536','214537','214538','214539','214540','214541','232475','232501','240055','240149','240587','240782','240783','240784','241277','242090','242319','242459','242464','242465','242466','242467','242645','242700','242738','242739','242740','242741','242742','242743','242744','242745','242826','242827','242828','242837','243080','243221','243315','243324','245084','245990','247810','249509','249510','249511','250351','250851','250852','251000','251001','251097','251122','251123','251124','251253','251702','251822','251823','251855','251856','251978','254779','255519','261933','262622','262660','263569','264673','264674','264677','266789','268108','268121','268419','268420','268435','268436','268437','268438','268439','268440','268441','268442','268443','268444','268445','268727','268841','273559','275403','275733','276056','277944','277945','278115','278374','278376','278400','278604','279137','279169','279201','279275','279558','279566','279572','279573','279574','279575','279678','280596','280597','280897','280898','280899','281625','282531','283233','283513','283514','283515','283561','284463','284464','284536','284633','284634','284740','284741','285306','285587','286145','286146','286282','286363','286368','286992','287003','287044','288362','288466','288892','288996','288997','289386','289387','289411','289423','291587','291696','292069','292267','292391','292392','292393','292394','292538','292764','292765','293385','293454','294150','294151','294352','294920','297094','297133','297222','297741','297742','297743','297744','297745','297746','297747','297781','297782','297827','297828','297830','297832','297938','297939','297940','298013','298328','299194','299474','299531','299560','299873','299874','299875','300003','300051','302232','164439','245169','246678','247506','247909','248310','253338','255494','256600','262559','262560','264967','264968','264969','264970','268109','268110','269190','269406','269545','276793','277203','278118','278745','278746','286847','286848','288033','288966','289418','289493','294025','294692','299062','300558','301827','303973','142911','143242','143305','143308','150188','150707','151270','151271','151272','153952','154157','154525','157411','157412','157413','157414','157415','157416','157417','157418','157419','157420','157421','157422','158066','158151','158152','158265','158482','158483','158484','158503','158504','158505','158506','158507','158761','158812','158987','159067','159068','159069','159081','159119','159178','159179','159180','159181','159182','159183','159317','159361','159400','159517','159627','159628','159786','159787','159899','159900','160023','160024','160025','160026','160027','160028','160029','160030','160031','160032','160033','160146','160147','160185','160186','160543','160795','160796','160970','160971','160972','160973','160991','161074','161152','161153','161168','161169','161170','161171','161198','161221','161269','161301','161374','161375','161376','161377','161480','161482','161526','161689','161690','161730','161731','161732','161733','161734','161735','161736','161740','161752','161796','161799','161930','161938','161982','161998','162042','162043','162044','162045','162046','162047','162054','162055','162056','162057','162058','162059','162060','162138','162169','162170','162241','162296','162334','162393','162394','162395','162445','162446','162450','162504','162505','162506','162507','162508','162509','162535','162536','162537','162538','162554','162616','162618','162627','162628','162629','162630','162631','162632','162648','162649','162652','162716','162774','163343','163664','163665','163666','163667','163772','163821','163862','163888','163976','164082','164083','164092','164137','164138','164139','164184','164292','164318','164410','164516','164517','164518','164547','164573','165137','165138','165139','165145','165160','165366','165367','165545','165566','165683','165718','165719','165720','165721','165722','165730','165780','165781','165804','165834','165835','165850','166043','166044','166059','166060','166070','166124','166125','166132','166162','166423','166448','166494','166619','166620','166655','166676','166959','167139','167215','167281','167282','167472','167473','167492','167644','167646','167647','167696','167697','167698','167765','167766','168056','169863','169864','170133','170161','170162','170163','170166','170167','170168','170169','170176','170188','170189','170191','170192','170198','170275','170495','170496','170497','170498','170499','170501','170560','201164','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222','212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','214542','214543','214544','214545','214546','214547','214548','214549','214550','214551','214552','214553','214554','214555','214556','214557','214558','214559','214560','214561','214562','214563','214564','214565','214573','214574','214575','214576','214577','214579','214583','214587','214588','214589','214590','214591','214592','214593','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640','214642','214643','214644','214645','214646','214647','214648','214649','214650','214651','214652','214653','214654','214655','214656','214657','214658','214659','214660','214661','214662','214663','214664','214665','214666','214667','214668','214669','214670','214671','214672','214673','214674','214675','214676','214677','214678','214679','214680','214681','214682','214683','214684','214685','214686','214687','214688','214689','214690','214691','214692','214693','214694','214695','214696','214697','214698','214699','214700','214701','214702','214703','214704','214705','214706','214707','214708','214709','214710','214711','214712','214713','214714','214715','214716','214717','214718','214719','214720','214721','214722','214723','214724','214725','214726','214727','214728','214729','214730','214731','214732','214733','214734','214735','214736','214737','214738','214739','214740','214741','214742','214743','214744','214745','214746','214747','214748','214749','214750','214751','215634','215635','215636','215664','215665','215666','215667','215668','215669','215670','215671','215672','215673','215674','215675','215676','215677','215678','215679','215680','215681','215682','215807','215808','215809','215810','215811','215812','215813','215814','215815','215816','215817','215818','215819','215820','216056','216057','216058','216059','232787','232788','232798','232799','232800','238037','238038','238039','238040','238073','238074','238075','238076','238094','238095','238096','238222','238223','238224','238225','238226','238227','238228','238458','238480','238482','238483','238485','238486','238487','238488','238489','238490','238728','239040','239042','239180','239181','239218','239219','239304','239305','239306','239318','239469','239470','239471','239472','239473','239474','239475','239476','239628','239629','239630','239631','239632','239826','239894','239895','239918','239919','239920','239939','239940','239941','239942','239943','239944','239945','240150','240151','240185','240186','240187','240350','240488','240583','240599','240600','240601','240602','240603','240604','240605','240606','240607','240608','240670','240673','240674','240675','240676','240677','240678','240679','240680','240681','240682','240683','240684','240718','240719','240720','240721','240738','240739','240740','240743','240788','240789','240790','240791','240792','240793','240794','240795','240796','240797','240798','240799','240800','241080','241123','241124','241456','241457','241458','241459','241460','241518','241519','241598','241611','241612','241811','241812','241813','241920','241921','241922','241928','241929','241930','241931','242006','242007','242016','242021','242026','242067','242201','242202','242203','242204','242271','242272','242273','242274','242275','242276','242277','242292','242512','242517','242686','242687','242688','242689','242763','242764','242765','242766','242782','242783','242932','242959','242960','242968','242989','242990','243239','243240','243241','243259','243260','243261','243262','243263','243264','243540','243541','243542','243543','243544','243545','243546','243700','243701','243702','243703','243940','243941','243942','243943','244002','244003','244082','244136','244163','244203','244204','244205','244237','244238','244239','244338','244372','244373','244531','244532','244533','244534','244570','244652','244653','244654','244727','244728','244733','244825','244826','244943','244944','244945','244946','244949','245011','245047','245048','245049','245173','245212','245270','245287','245288','245289','245290','245291','245554','245555','245556','245557','245562','245575','245596','245716','245886','246084','246085','246086','246087','246088','246089','246090','246091','246092','246093','246191','246283','246284','246388','246389','246444','246557','246558','246559','246560','246561','246562','246733','246734','246920','247037','247084','247267','247296','247371','247372','247373','247819','248066','248067','248083','248084','248094','248095','248096','248097','248098','248099','248100','248101','248408','248643','248644','248645','248839','248858','248962','249203','249281','249282','249384','249495','249496','249497','249571','249572','249598','249647','249681','249708','249737','249738','249772','249773','249829','249830','249831','249866','249911','249912','250109','250145','250146','250285','250325','250449','250474','250475','250476','250477','250478','250479','250513','250514','250515','250516','250517','250518','250520','250608','250609','250675','250728','250757','250758','250759','250818','250931','250932','251034','251066','251146','251158','251159','251206','251234','251281','251347','251348','251481','251482','251483','251484','251485','251486','251766','252023','252071','252072','252074','252118','253612','253614','253615','253616','254321','254328','254419','254420','254564','254744','254745','254746','254747','254908','254909','254910','254911','254912','254913','254914','254915','255020','255129','255130','255132','255133','255135','255136','255137','255182','255210','255286','255382','255521','255575','255590','255632','255656','256199','256758','256762','256763','256764','256765','256766','256796','256879','256880','256881','256882','256883','256884','256885','256886','256887','256888','256889','256890','256891','256892','256893','256894','256895','256896','256897','256898','256899','256900','256901','257120','257121','257122','257123','257124','257125','257126','257127','257128','257179','261797','262264','262265','262266','262267','262268','262270','262272','262367','262368','262601','262771','262782','262784','262800','262801','262802','262803','262804','262805','262806','262816','262817','262818','262819','262820','262821','262975','262976','262977','263046','263047','263048','264522','264523','264524','264525','264526','264527','264610','264611','264612','264613','264614','264615','264616','264618','264619','264652','264701','264702','264703','264933','264984','265126','265312','265313','265320','265383','265527','265528','265529','265530','265531','265865','265918','265968','265969','265981','266107','266179','266687','266688','266696','266850','266942','267012','267013','267149','267150','267151','267152','267153','267451','267509','267510','267511','267512','267889','268072','268075','268157','268184','268185','268186','268187','268188','268189','268190','268191','268481','268482','268633','268634','268635','268636','268637','269159','269342','269614','269615','269616','269617','269618','269619','269620','269621','269622','273532','273569','273570','273571','273572','273668','273669','274013','274304','274675','274736','274737','274738','274739','274740','274741','274878','275341','275342','275343','275344','275345','275346','275347','275348','275349','275350','275354','275366','275367','275643','275644','275645','275646','275647','275648','275649','275650','275651','275652','275653','275672','275673','276667','277177','277285','277644','277656','277790','278344','278345','278366','278692','278847','278852','279164','279454','279513','279711','279712','279782','281233','281434','282325','282326','282832','283302','283303','283610','284517','284518','285954','286352','286372','286402','286817','286872','288157','288158','288159','288286','288626','288627','291637','291638','291639','291640','291787','291854','292858','293515','293931','293932','294910','294911','294912','295329','295578','295789','295790','297368','297624','297625','297626','297627','297682','297858','298321','298543','298544','299164','299479','299834','300185','300219','300220','300279','300280','300281','300283','300284','300285','300286','300287','300288','300292','300293','300294','300295','300296','300327','300329','300330','300331','300332','300435','300937','301931','301988','302186','303864','303865','304114','304147','304155','304156','304157','304158','304159','304647','304648','304649','304650','304651','304652','304653','304654','304655','304656','304657','304658','304659','304660','304661','304662','150189','150190','150191','158501','159258','160684','161820','161948','162396','162952','162953','162954','162955','162956','162957','162958','162959','162960','162961','162962','162963','162964','163400','163401','164823','164976','166091','166595','167509','170746','212236','212237','212238','212239','212240','214752','214753','214754','214755','214756','214757','214758','214759','214760','214761','214762','214763','214764','214765','214766','214767','214768','214769','214770','214771','214772','214773','214774','214775','214776','214777','214778','214779','214780','214781','214782','214783','214784','214785','214786','214787','214788','214789','214790','214791','214792','214793','214794','214795','214796','214797','214798','214799','214800','214801','214802','214803','214804','214805','214806','214807','214808','214809','214810','214811','214812','214813','214814','214815','214816','214817','214818','214819','214820','214821','214822','214823','214824','214825','214826','214827','214828','214829','214830','214831','214832','214833','214834','214835','214836','214837','214838','214839','214840','214841','214842','214843','214844','214845','214846','214847','214848','214849','214850','214851','214852','214853','214854','214855','214856','214857','214858','214859','214860','214861','214862','214863','214864','214865','214866','214867','214868','214869','214870','214871','214872','214873','214874','214875','214876','214877','214878','214879','214880','214881','214882','214883','214884','214885','214886','214887','214888','214889','214890','214891','214892','214893','214894','214895','214896','214897','214898','214899','214900','214901','214902','214903','214904','214905','214906','214907','214908','214909','214910','214911','214912','214913','214914','214915','214916','214917','214918','214919','214920','214921','214922','214923','214924','214925','214926','214927','214928','214929','214930','214931','214932','214933','214934','214935','214936','214937','214938','214939','214940','214941','214942','214943','214944','214945','214946','214947','214948','214949','214950','214951','214952','214953','214954','214955','214956','214957','214958','214959','214960','214961','214962','214963','214964','214965','214966','214967','239250','239946','240026','241012','242014','242836','243554','244169','245072','245851','246156','246240','246241','246242','247686','247836','247837','247838','247839','247840','247841','247842','248522','248523','249765','249855','250216','250591','250592','251336','252170','255012','256108','256206','256794','263638','263656','264433','265007','265075','265163','265463','265464','265577','265578','265579','265694','266439','266735','266954','266997','267231','267232','267233','267534','267535','267717','267755','267930','268168','268328','268421','268422','268423','268424','268425','268426','268427','268428','268429','268430','268431','268432','268433','268434','268897','273331','273599','273726','273980','274033','274450','274601','275632','277208','278083','278373','278911','278913','278914','278915','278916','278917','278918','278919','278920','278921','278922','278923','278924','278925','278986','279203','279485','279486','279487','279488','279489','280303','280305','281164','282248','282249','282272','283492','283672','284285','285000','285006','285017','285020','285784','285820','285821','286424','287159','287160','288291','288489','288540','288541','289008','289298','289393','289394','291828','292226','292232','292752','293419','293420','294168','294547','294621','294622','295300','295780','295872','296249','297104','297224','297249','297319','297479','297480','297481','297482','297483','297484','297485','297486','297487','297488','297489','297490','297491','297492','297493','297494','297495','297496','297497','297498','297499','297500','297501','297502','297503','297504','297505','297506','297507','297778','297958','298126','298127','298128','299630','300048','300206','300207','300609','301928','302055','302105','302162','302169','302170','303884','150420','214972','214973','214974','214975','214976','214977','214978','214979','214980','214981','214982','214983','214984','214985','214986','214987','214988','214989','214990','214991','214992','214993','214994','214995','214996','214997','214998','214999','215000','215001','215002','215003','215004','215005','215006','215007','215008','215009','215010','215011','215012','215013','215014','215015','215016','215017','215018','215019','249121','249122','253660','264838','279011','281662','284252','284541','284593','284595','295317','300234','264436','264509','264510','264557','264558','264809','264855','266007','267970','268408','269535','269613','273332','273409','273410','273442','274602','274653','275039','275191','278113','278181','278556','281480','284255','284720','285002','285057','285194','285657','287199','287986','288962','289009','291685','292036','294169','294630','294802','295342','297198','299079','299683','300199','302187','269407','274157','275964','277826','278119','278816','280322','281717','282869','284250','286849','293506','298437','298474','302167') 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 ('142911','142971','143168','143169','143225','143242','143302','143303','143304','143305','143308','143309','143310','143480','143484','143485','143487','143603','143670','143678','143703','144209','144211','144212','147068','147227','147385','148057','148161','149706','150069','150070','150071','150072','150073','150074','150085','150086','150181','150182','150183','150184','150188','150189','150190','150191','150366','150367','150368','150369','150370','150371','150372','150373','150374','150375','150376','150377','150378','150379','150380','150381','150382','150383','150384','150386','150387','150388','150389','150390','150391','150392','150393','150394','150395','150396','150397','150398','150399','150400','150401','150402','150403','150404','150405','150406','150407','150408','150409','150410','150411','150412','150413','150414','150415','150416','150417','150418','150420','150707','151270','151271','151272','151482','151640','151954','153083','153084','153216','153217','153218','153404','153952','154157','154525','154946','155732','157411','157412','157413','157414','157415','157416','157417','157418','157419','157420','157421','157422','157558','157950','158066','158151','158152','158265','158410','158482','158483','158484','158501','158503','158504','158505','158506','158507','158571','158761','158812','158966','158967','158987','159038','159067','159068','159069','159081','159119','159178','159179','159180','159181','159182','159183','159258','159317','159361','159399','159400','159455','159517','159544','159580','159627','159628','159786','159787','159899','159900','160023','160024','160025','160026','160027','160028','160029','160030','160031','160032','160033','160146','160147','160185','160186','160543','160684','160795','160796','160836','160837','160901','160970','160971','160972','160973','160991','161074','161110','161152','161153','161168','161169','161170','161171','161198','161221','161269','161301','161302','161374','161375','161376','161377','161379','161480','161482','161486','161487','161488','161489','161490','161491','161492','161493','161494','161495','161496','161518','161519','161526','161689','161690','161719','161720','161721','161722','161730','161731','161732','161733','161734','161735','161736','161740','161752','161796','161799','161820','161930','161938','161948','161982','161998','162042','162043','162044','162045','162046','162047','162053','162054','162055','162056','162057','162058','162059','162060','162138','162169','162170','162204','162241','162296','162334','162393','162394','162395','162396','162445','162446','162450','162485','162504','162505','162506','162507','162508','162509','162535','162536','162537','162538','162554','162616','162618','162627','162628','162629','162630','162631','162632','162648','162649','162652','162716','162774','162952','162953','162954','162955','162956','162957','162958','162959','162960','162961','162962','162963','162964','163161','163225','163226','163319','163343','163397','163398','163399','163400','163401','163453','163454','163455','163456','163457','163502','163503','163504','163505','163506','163507','163509','163510','163511','163664','163665','163666','163667','163677','163678','163772','163821','163861','163862','163888','163976','164022','164082','164083','164092','164137','164138','164139','164184','164256','164292','164318','164410','164439','164503','164516','164517','164518','164547','164573','164693','164823','164872','164889','164976','165137','165138','165139','165145','165160','165288','165289','165290','165291','165292','165356','165366','165367','165383','165384','165534','165535','165542','165545','165566','165640','165641','165674','165678','165683','165718','165719','165720','165721','165722','165730','165780','165781','165804','165834','165835','165850','165875','165963','165964','166043','166044','166059','166060','166070','166091','166124','166125','166132','166162','166338','166341','166342','166345','166346','166347','166348','166349','166350','166351','166352','166353','166354','166355','166356','166357','166358','166359','166360','166361','166362','166363','166364','166365','166366','166367','166368','166369','166370','166371','166372','166373','166374','166375','166376','166377','166378','166379','166380','166381','166382','166383','166384','166385','166386','166387','166388','166389','166390','166391','166392','166395','166396','166397','166411','166423','166448','166494','166595','166619','166620','166655','166676','166756','166757','166758','166759','166780','166791','166803','166804','166805','166806','166807','166808','166809','166810','166811','166812','166813','166814','166815','166816','166817','166818','166959','167028','167139','167180','167215','167239','167281','167282','167381','167472','167473','167492','167493','167494','167495','167496','167509','167644','167646','167647','167696','167697','167698','167765','167766','168000','168001','168056','169820','169863','169864','169878','169879','169882','169883','169888','169894','169895','169912','169937','169946','170056','170057','170058','170059','170060','170061','170062','170063','170064','170065','170133','170161','170162','170163','170166','170167','170168','170169','170171','170172','170173','170174','170175','170176','170183','170188','170189','170191','170192','170196','170197','170198','170200','170201','170202','170239','170275','170279','170324','170410','170479','170481','170482','170483','170484','170486','170487','170488','170489','170490','170491','170492','170493','170494','170495','170496','170497','170498','170499','170501','170508','170560','170739','170740','170741','170742','170743','170744','170745','170746','170747','170748','170750','170751','170752','170782','170783','170784','201164','201166','201168','201169','201170','201171','201172','201236','201301','201304','201305','201306','201320','202687','202698','202700','202727','202801','202802','202803','202817','210509','210510','210511','210512','210513','211302','211303','211304','211305','211306','211307','211308','211309','211310','211311','211312','211313','211314','211315','211316','211317','211318','211319','211320','211321','211322','211323','211324','211325','211326','211327','211328','211329','211330','211331','211332','211333','211334','211335','211336','211337','211338','211339','211340','211341','211342','211343','211344','211345','211346','211347','211348','211349','211350','211351','211352','211353','211354','211355','211356','211357','211358','211359','211360','211361','211362','211363','211364','211365','211366','211367','211368','211369','211370','211371','211372','211373','211374','211375','211376','211377','211378','211379','211380','211381','211382','211383','211384','211385','211386','211387','211388','211389','211390','211391','211392','211393','211394','211395','211396','211397','211398','211399','211400','211401','211402','211403','211404','211405','211406','211407','211408','211409','211410','211411','211412','211413','211414','211415','211416','211417','211418','211419','211420','211421','211422','211423','211424','211425','211426','211427','211428','211429','211430','211431','211432','211433','211434','211435','211436','211437','211438','211439','211440','211441','211442','211443','211444','211445','211446','211447','211448','211449','211450','211451','211452','211453','211454','211455','211456','211457','211458','211459','211460','211461','211462','211463','211464','211465','211542','211543','211544','211545','212039','212040','212041','212042','212043','212044','212045','212046','212047','212048','212049','212050','212051','212052','212053','212054','212055','212056','212057','212058','212059','212060','212061','212062','212063','212064','212065','212066','212067','212068','212069','212070','212071','212072','212073','212074','212075','212076','212077','212078','212079','212080','212081','212082','212083','212084','212085','212086','212087','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222','212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','212236','212237','212238','212239','212240','213492','213493','213494','213495','213496','213498','213499','213500','213501','213502','213503','213504','213505','213506','213507','213508','213509','213510','213511','213512','213513','213514','213515','213516','213517','213518','213519','213520','213521','213522','213523','213524','213525','213526','213527','213528','213529','213530','213531','213532','213533','213534','213535','213536','213537','213538','213539','213540','213541','213542','213543','213544','213545','213546','213547','213548','213549','213550','213551','213564','213565','213566','213567','213568','213569','213570','213571','213572','213573','213574','213575','213576','213577','213578','213579','213580','213581','213582','213583','213584','213585','213586','213587','213588','213589','213590','213591','213592','213593','213594','213595','213596','213597','213598','213599','213600','213601','213602','213603','213604','213605','213606','213607','213608','213609','213610','213611','213612','213613','213614','213615','213616','213617','213618','213619','213620','213621','213622','213623','213624','213625','213626','213627','213628','213629','213630','213631','213632','213633','213634','213635','213636','213637','213638','213639','213640','213641','213642','213643','213644','213645','213646','213647','213648','213649','213650','213651','213652','213653','213654','213655','213656','213657','213658','213659','213660','213661','213662','213663','213664','213665','213666','213667','213668','213669','213670','213671','213672','213673','213674','213675','213676','213677','213678','213679','213680','213681','213682','213683','213684','213685','213686','213687','213688','213689','213690','213691','213692','213693','213694','213695','213696','213697','213698','213699','213700','213701','213702','213703','213704','213705','213706','213707','213708','213709','213710','213711','213712','213713','213714','213715','213716','213717','213718','213719','213720','213721','213722','213723','213724','213725','213726','213727','213728','213729','213730','213731','213732','213733','213734','213735','213736','213737','213738','213739','213740','213741','213742','213743','213744','213745','213746','213747','213748','213749','213750','213751','213752','213753','213754','213755','213838','213839','213840','213841','213842','213843','213844','213845','213846','213847','213848','213849','213850','213851','213852','213853','213854','213855','213856','213857','213858','213859','213860','213861','213862','213863','213864','213865','213866','213867','213868','213869','213870','213871','213872','213873','213874','213875','213876','213877','213878','213879','213880','213881','213882','213883','213884','213885','213886','213887','213888','213889','213890','213891','213892','213893','213894','213895','213896','213897','213898','213899','213900','213901','213902','213903','213904','213905','213906','213907','213908','213909','213910','213911','213912','213913','213914','213915','213916','213917','213918','213919','213920','213921','213922','213923','213924','213925','213926','213927','213928','213929','213930','213931','213932','213933','213934','213935','213936','213937','213938','213939','213940','213941','213942','213943','213944','213945','213946','213947','213948','213949','213950','213951','213952','213953','213954','213955','213956','213957','213958','213959','213960','213961','213962','213963','213964','213965','213966','213967','213968','213969','213970','213971','213972','213973','213974','213975','213976','213977','213978','213979','213980','213981','213982','213983','213984','213985','213986','213987','213999','214000','214001','214002','214003','214004','214005','214006','214007','214008','214009','214010','214011','214012','214013','214014','214015','214016','214017','214018','214019','214020','214021','214022','214025','214029','214030','214031','214032','214033','214034','214035','214036','214037','214038','214039','214040','214041','214042','214043','214044','214045','214046','214047','214048','214049','214050','214051','214052','214053','214054','214055','214056','214057','214058','214059','214060','214061','214062','214063','214064','214065','214066','214067','214068','214069','214070','214071','214072','214073','214074','214075','214076','214077','214078','214079','214080','214081','214082','214083','214084','214085','214086','214087','214088','214089','214090','214091','214092','214093','214094','214095','214096','214097','214098','214099','214100','214101','214102','214103','214104','214105','214106','214107','214108','214109','214110','214111','214112','214113','214114','214115','214116','214117','214118','214119','214120','214121','214122','214123','214124','214125','214126','214127','214128','214129','214130','214131','214132','214133','214134','214135','214136','214137','214138','214139','214140','214141','214142','214143','214144','214145','214146','214147','214148','214149','214150','214151','214152','214153','214154','214155','214156','214157','214158','214159','214160','214161','214162','214163','214164','214165','214166','214167','214168','214169','214170','214171','214172','214173','214174','214175','214176','214177','214178','214179','214180','214181','214182','214183','214184','214185','214186','214187','214188','214189','214190','214191','214192','214193','214194','214195','214196','214197','214198','214199','214200','214201','214202','214203','214204','214205','214206','214207','214208','214209','214210','214211','214212','214213','214214','214215','214216','214217','214218','214219','214220','214221','214222','214223','214224','214225','214226','214227','214228','214229','214230','214231','214232','214233','214234','214235','214236','214237','214238','214239','214240','214241','214242','214243','214244','214245','214246','214247','214248','214249','214250','214251','214252','214253','214254','214255','214256','214257','214258','214259','214260','214261','214262','214263','214264','214265','214266','214267','214268','214269','214270','214271','214272','214273','214274','214275','214276','214277','214278','214279','214280','214281','214282','214283','214284','214285','214286','214287','214288','214303','214304','214305','214306','214307','214308','214309','214310','214311','214312','214313','214314','214315','214316','214317','214318','214319','214320','214321','214322','214323','214325','214326','214327','214328','214329','214330','214331','214332','214333','214334','214335','214336','214337','214338','214339','214340','214341','214342','214343','214344','214345','214346','214347','214348','214349','214350','214351','214352','214353','214354','214355','214356','214357','214358','214359','214360','214361','214362','214363','214364','214365','214366','214367','214368','214369','214370','214371','214372','214373','214374','214375','214376','214377','214378','214379','214380','214381','214382','214383','214384','214385','214386','214387','214388','214389','214390','214391','214392','214393','214394','214395','214396','214397','214398','214399','214400','214401','214402','214403','214404','214405','214406','214407','214408','214409','214410','214411','214412','214413','214414','214415','214416','214417','214418','214419','214420','214421','214422','214423','214424','214425','214426','214427','214428','214429','214430','214431','214432','214433','214434','214435','214436','214437','214438','214439','214440','214441','214442','214443','214444','214445','214446','214447','214448','214449','214450','214451','214452','214453','214454','214455','214456','214457','214458','214459','214460','214461','214462','214463','214464','214465','214466','214467','214468','214469','214470','214471','214472','214473','214474','214475','214476','214477','214478','214479','214480','214481','214482','214483','214484','214485','214486','214487','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534','214535','214536','214537','214538','214539','214540','214541','214542','214543','214544','214545','214546','214547','214548','214549','214550','214551','214552','214553','214554','214555','214556','214557','214558','214559','214560','214561','214562','214563','214564','214565','214573','214574','214575','214576','214577','214579','214583','214587','214588','214589','214590','214591','214592','214593','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640','214642','214643','214644','214645','214646','214647','214648','214649','214650','214651','214652','214653','214654','214655','214656','214657','214658','214659','214660','214661','214662','214663','214664','214665','214666','214667','214668','214669','214670','214671','214672','214673','214674','214675','214676','214677','214678','214679','214680','214681','214682','214683','214684','214685','214686','214687','214688','214689','214690','214691','214692','214693','214694','214695','214696','214697','214698','214699','214700','214701','214702','214703','214704','214705','214706','214707','214708','214709','214710','214711','214712','214713','214714','214715','214716','214717','214718','214719','214720','214721','214722','214723','214724','214725','214726','214727','214728','214729','214730','214731','214732','214733','214734','214735','214736','214737','214738','214739','214740','214741','214742','214743','214744','214745','214746','214747','214748','214749','214750','214751','214752','214753','214754','214755','214756','214757','214758','214759','214760','214761','214762','214763','214764','214765','214766','214767','214768','214769','214770','214771','214772','214773','214774','214775','214776','214777','214778','214779','214780','214781','214782','214783','214784','214785','214786','214787','214788','214789','214790','214791','214792','214793','214794','214795','214796','214797','214798','214799','214800','214801','214802','214803','214804','214805','214806','214807','214808','214809','214810','214811','214812','214813','214814','214815','214816','214817','214818','214819','214820','214821','214822','214823','214824','214825','214826','214827','214828','214829','214830','214831','214832','214833','214834','214835','214836','214837','214838','214839','214840','214841','214842','214843','214844','214845','214846','214847','214848','214849','214850','214851','214852','214853','214854','214855','214856','214857','214858','214859','214860','214861','214862','214863','214864','214865','214866','214867','214868','214869','214870','214871','214872','214873','214874','214875','214876','214877','214878','214879','214880','214881','214882','214883','214884','214885','214886','214887','214888','214889','214890','214891','214892','214893','214894','214895','214896','214897','214898','214899','214900','214901','214902','214903','214904','214905','214906','214907','214908','214909','214910','214911','214912','214913','214914','214915','214916','214917','214918','214919','214920','214921','214922','214923','214924','214925','214926','214927','214928','214929','214930','214931','214932','214933','214934','214935','214936','214937','214938','214939','214940','214941','214942','214943','214944','214945','214946','214947','214948','214949','214950','214951','214952','214953','214954','214955','214956','214957','214958','214959','214960','214961','214962','214963','214964','214965','214966','214967','214972','214973','214974','214975','214976','214977','214978','214979','214980','214981','214982','214983','214984','214985','214986','214987','214988','214989','214990','214991','214992','214993','214994','214995','214996','214997','214998','214999','215000','215001','215002','215003','215004','215005','215006','215007','215008','215009','215010','215011','215012','215013','215014','215015','215016','215017','215018','215019','215248','215431','215500','215547','215622','215634','215635','215636','215664','215665','215666','215667','215668','215669','215670','215671','215672','215673','215674','215675','215676','215677','215678','215679','215680','215681','215682','215776','215798','215807','215808','215809','215810','215811','215812','215813','215814','215815','215816','215817','215818','215819','215820','215897','215984','216056','216057','216058','216059','232398','232407','232408','232429','232430','232431','232432','232435','232475','232501','232523','232787','232788','232798','232799','232800','238037','238038','238039','238040','238073','238074','238075','238076','238094','238095','238096','238222','238223','238224','238225','238226','238227','238228','238458','238480','238482','238483','238485','238486','238487','238488','238489','238490','238728','239040','239042','239180','239181','239218','239219','239250','239304','239305','239306','239318','239469','239470','239471','239472','239473','239474','239475','239476','239568','239569','239628','239629','239630','239631','239632','239662','239663','239664','239697','239708','239709','239710','239826','239847','239894','239895','239918','239919','239920','239939','239940','239941','239942','239943','239944','239945','239946','240026','240044','240055','240119','240149','240150','240151','240185','240186','240187','240271','240272','240273','240274','240337','240350','240488','240512','240582','240583','240587','240599','240600','240601','240602','240603','240604','240605','240606','240607','240608','240670','240673','240674','240675','240676','240677','240678','240679','240680','240681','240682','240683','240684','240718','240719','240720','240721','240738','240739','240740','240743','240782','240783','240784','240788','240789','240790','240791','240792','240793','240794','240795','240796','240797','240798','240799','240800','241012','241080','241123','241124','241277','241278','241456','241457','241458','241459','241460','241518','241519','241551','241598','241611','241612','241685','241811','241812','241813','241883','241903','241920','241921','241922','241928','241929','241930','241931','241975','242006','242007','242014','242016','242021','242026','242067','242090','242201','242202','242203','242204','242271','242272','242273','242274','242275','242276','242277','242292','242319','242459','242464','242465','242466','242467','242512','242517','242645','242686','242687','242688','242689','242700','242738','242739','242740','242741','242742','242743','242744','242745','242763','242764','242765','242766','242782','242783','242826','242827','242828','242836','242837','242932','242959','242960','242968','242989','242990','243032','243080','243148','243176','243187','243221','243225','243239','243240','243241','243259','243260','243261','243262','243263','243264','243315','243319','243324','243410','243411','243540','243541','243542','243543','243544','243545','243546','243554','243700','243701','243702','243703','243844','243870','243940','243941','243942','243943','243987','244002','244003','244082','244089','244098','244136','244158','244163','244169','244203','244204','244205','244237','244238','244239','244255','244256','244257','244258','244260','244261','244338','244372','244373','244531','244532','244533','244534','244570','244643','244652','244653','244654','244669','244727','244728','244733','244765','244766','244768','244825','244826','244943','244944','244945','244946','244947','244949','245011','245047','245048','245049','245072','245084','245169','245173','245212','245270','245287','245288','245289','245290','245291','245456','245525','245554','245555','245556','245557','245562','245575','245589','245596','245716','245851','245886','245990','246010','246011','246032','246033','246057','246060','246084','246085','246086','246087','246088','246089','246090','246091','246092','246093','246096','246156','246191','246240','246241','246242','246283','246284','246345','246388','246389','246444','246506','246507','246508','246509','246510','246511','246512','246513','246514','246515','246516','246517','246557','246558','246559','246560','246561','246562','246571','246572','246573','246574','246575','246576','246577','246578','246579','246580','246581','246678','246733','246734','246920','247012','247037','247043','247084','247208','247267','247277','247286','247287','247296','247299','247300','247335','247371','247372','247373','247506','247686','247810','247819','247824','247825','247826','247827','247828','247829','247830','247832','247833','247834','247835','247836','247837','247838','247839','247840','247841','247842','247843','247844','247845','247846','247847','247848','247909','247987','248059','248066','248067','248083','248084','248094','248095','248096','248097','248098','248099','248100','248101','248109','248124','248125','248310','248408','248520','248522','248523','248622','248623','248624','248625','248626','248627','248628','248629','248630','248631','248632','248633','248634','248635','248636','248643','248644','248645','248757','248839','248858','248882','248908','248962','248992','249063','249121','249122','249174','249175','249176','249179','249180','249203','249262','249281','249282','249351','249384','249406','249477','249493','249495','249496','249497','249509','249510','249511','249545','249571','249572','249586','249591','249598','249622','249647','249681','249708','249737','249738','249745','249765','249766','249772','249773','249829','249830','249831','249855','249866','249882','249883','249884','249891','249892','249911','249912','249938','249946','250027','250028','250029','250030','250031','250032','250033','250034','250035','250036','250037','250038','250054','250064','250067','250068','250069','250102','250109','250145','250146','250215','250216','250248','250285','250325','250343','250349','250351','250449','250458','250474','250475','250476','250477','250478','250479','250510','250513','250514','250515','250516','250517','250518','250520','250535','250536','250537','250538','250564','250565','250566','250567','250568','250569','250570','250571','250572','250573','250591','250592','250593','250594','250608','250609','250675','250728','250757','250758','250759','250818','250851','250852','250931','250932','250960','251000','251001','251034','251066','251097','251122','251123','251124','251146','251158','251159','251170','251179','251206','251234','251253','251261','251281','251284','251336','251337','251346','251347','251348','251423','251477','251481','251482','251483','251484','251485','251486','251524','251525','251526','251527','251528','251529','251530','251531','251532','251533','251534','251535','251536','251537','251538','251609','251650','251661','251670','251702','251746','251766','251822','251823','251855','251856','251978','252023','252071','252072','252074','252118','252170','253120','253207','253283','253309','253310','253311','253312','253313','253314','253315','253316','253317','253318','253338','253612','253614','253615','253616','253660','254302','254321','254328','254419','254420','254564','254625','254648','254744','254745','254746','254747','254779','254908','254909','254910','254911','254912','254913','254914','254915','254984','255012','255020','255129','255130','255132','255133','255135','255136','255137','255182','255210','255286','255349','255382','255494','255516','255519','255521','255530','255551','255552','255553','255575','255590','255632','255656','255666','255714','255715','256024','256071','256074','256108','256120','256199','256204','256206','256256','256322','256358','256359','256442','256443','256597','256600','256748','256758','256762','256763','256764','256765','256766','256772','256773','256774','256775','256776','256792','256794','256796','256879','256880','256881','256882','256883','256884','256885','256886','256887','256888','256889','256890','256891','256892','256893','256894','256895','256896','256897','256898','256899','256900','256901','256950','257120','257121','257122','257123','257124','257125','257126','257127','257128','257179','257231','261797','261798','261933','261971','261972','262264','262265','262266','262267','262268','262270','262272','262363','262364','262365','262367','262368','262411','262436','262559','262560','262601','262622','262660','262771','262782','262784','262800','262801','262802','262803','262804','262805','262806','262816','262817','262818','262819','262820','262821','262927','262975','262976','262977','263046','263047','263048','263569','263575','263576','263577','263638','263639','263656','263659','263755','263756','264433','264436','264442','264509','264510','264522','264523','264524','264525','264526','264527','264557','264558','264610','264611','264612','264613','264614','264615','264616','264618','264619','264633','264652','264673','264674','264677','264701','264702','264703','264809','264838','264842','264843','264855','264933','264939','264967','264968','264969','264970','264979','264984','265007','265042','265047','265066','265067','265075','265126','265130','265131','265132','265133','265163','265230','265231','265232','265260','265295','265302','265312','265313','265320','265325','265383','265463','265464','265504','265527','265528','265529','265530','265531','265532','265577','265578','265579','265616','265617','265618','265694','265697','265865','265918','265957','265962','265967','265968','265969','265981','266007','266107','266179','266439','266469','266514','266687','266688','266696','266735','266789','266850','266942','266954','266997','267012','267013','267149','267150','267151','267152','267153','267231','267232','267233','267451','267509','267510','267511','267512','267534','267535','267595','267604','267717','267755','267777','267778','267779','267780','267879','267889','267930','267970','268064','268072','268075','268104','268108','268109','268110','268113','268114','268121','268128','268157','268168','268184','268185','268186','268187','268188','268189','268190','268191','268328','268408','268418','268419','268420','268421','268422','268423','268424','268425','268426','268427','268428','268429','268430','268431','268432','268433','268434','268435','268436','268437','268438','268439','268440','268441','268442','268443','268444','268445','268481','268482','268512','268633','268634','268635','268636','268637','268659','268727','268804','268805','268808','268841','268897','269109','269115','269159','269161','269190','269342','269404','269405','269406','269407','269424','269425','269446','269535','269545','269606','269613','269614','269615','269616','269617','269618','269619','269620','269621','269622','273317','273318','273331','273332','273369','273409','273410','273442','273443','273532','273555','273559','273569','273570','273571','273572','273599','273668','273669','273726','273854','273862','273898','273914','273980','274013','274026','274033','274036','274142','274151','274157','274304','274371','274450','274601','274602','274653','274675','274736','274737','274738','274739','274740','274741','274831','274878','274998','275039','275122','275123','275124','275131','275191','275341','275342','275343','275344','275345','275346','275347','275348','275349','275350','275354','275366','275367','275403','275488','275608','275632','275633','275642','275643','275644','275645','275646','275647','275648','275649','275650','275651','275652','275653','275672','275673','275733','275948','275964','275992','276024','276054','276056','276284','276347','276419','276667','276680','276695','276775','276793','277177','277203','277208','277285','277483','277515','277644','277656','277790','277826','277944','277945','278083','278087','278113','278115','278118','278119','278181','278261','278262','278263','278264','278296','278297','278298','278299','278300','278301','278344','278345','278366','278373','278374','278376','278400','278406','278496','278514','278515','278516','278556','278557','278604','278692','278745','278746','278751','278816','278817','278818','278847','278852','278911','278913','278914','278915','278916','278917','278918','278919','278920','278921','278922','278923','278924','278925','278986','279011','279137','279164','279169','279192','279201','279203','279275','279306','279334','279407','279454','279485','279486','279487','279488','279489','279513','279558','279566','279572','279573','279574','279575','279678','279711','279712','279782','280303','280305','280322','280333','280466','280596','280597','280598','280897','280898','280899','280999','281000','281127','281164','281233','281434','281480','281625','281662','281717','281780','281795','281796','281797','281798','281866','282034','282104','282156','282157','282248','282249','282272','282279','282280','282294','282315','282316','282318','282319','282320','282321','282325','282326','282489','282531','282758','282832','282869','282890','283038','283097','283184','283185','283186','283233','283302','283303','283342','283492','283495','283513','283514','283515','283561','283610','283672','284250','284251','284252','284253','284254','284255','284256','284257','284258','284259','284285','284337','284463','284464','284517','284518','284536','284541','284546','284593','284595','284633','284634','284673','284720','284740','284741','285000','285002','285006','285017','285020','285057','285157','285163','285194','285241','285254','285306','285327','285587','285636','285656','285657','285730','285769','285784','285820','285821','285954','286136','286145','286146','286282','286352','286356','286363','286368','286372','286384','286402','286424','286607','286817','286830','286847','286848','286849','286872','286992','287003','287044','287108','287159','287160','287199','287200','287986','288033','288131','288157','288158','288159','288286','288291','288362','288466','288489','288540','288541','288601','288626','288627','288756','288892','288962','288966','288995','288996','288997','288998','288999','289000','289008','289009','289086','289203','289298','289337','289386','289387','289393','289394','289411','289418','289423','289493','291587','291637','291638','291639','291640','291685','291690','291696','291705','291769','291787','291828','291854','291871','292036','292069','292226','292232','292267','292306','292391','292392','292393','292394','292408','292409','292534','292538','292579','292688','292695','292712','292752','292764','292765','292858','293385','293419','293420','293454','293506','293515','293602','293931','293932','294025','294066','294150','294151','294168','294169','294352','294547','294621','294622','294630','294668','294683','294692','294802','294910','294911','294912','294920','295283','295300','295317','295329','295332','295341','295342','295578','295588','295620','295780','295789','295790','295851','295852','295853','295855','295856','295857','295858','295859','295860','295861','295872','296239','296241','296249','297023','297094','297104','297133','297198','297222','297224','297249','297272','297292','297319','297368','297479','297480','297481','297482','297483','297484','297485','297486','297487','297488','297489','297490','297491','297492','297493','297494','297495','297496','297497','297498','297499','297500','297501','297502','297503','297504','297505','297506','297507','297508','297624','297625','297626','297627','297682','297714','297741','297742','297743','297744','297745','297746','297747','297778','297781','297782','297827','297828','297830','297832','297858','297938','297939','297940','297958','298013','298126','298127','298128','298176','298240','298250','298260','298314','298315','298321','298328','298437','298474','298543','298544','298587','299062','299079','299164','299194','299258','299382','299474','299479','299494','299531','299560','299630','299662','299683','299695','299720','299834','299873','299874','299875','299908','300003','300033','300048','300051','300070','300185','300199','300206','300207','300208','300219','300220','300234','300273','300279','300280','300281','300283','300284','300285','300286','300287','300288','300292','300293','300294','300295','300296','300327','300329','300330','300331','300332','300435','300508','300509','300510','300511','300558','300609','300655','300670','300676','300699','300711','300937','301795','301827','301834','301893','301928','301931','301988','302055','302105','302162','302167','302169','302170','302186','302187','302227','302232','302309','302362','303828','303864','303865','303884','303972','303973') 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 ('32','35','50','72','79','93','101','159','172','178','179','180','183','189','267','143603','151482','155732','157950','158571','161379','162053','163677','163678','164889','166341','166345','166346','166347','166348','166349','166350','166351','166352','166353','166354','166355','166356','166357','166358','166359','166360','166361','166362','166363','166364','166365','166366','166367','166368','166369','166370','166371','166372','166373','166374','166375','166376','166377','166378','166379','166380','166381','166382','166383','166384','166385','166386','166387','166388','166389','166390','166391','166392','166791','170410','201171','210512','210513','214390','214391','214392','214393','214394','214395','214396','214397','214398','214399','214400','214401','232523','239569','239710','240512','243987','244089','244098','244258','244260','246571','246572','246573','246574','246575','246576','246577','246578','246579','246580','246581','247828','247830','247832','247833','247835','247843','247846','247847','248757','249179','249180','250064','250593','250594','251179','251650','251670','255666','255714','255715','256442','256443','264478','273649','160901','251746','273555','280598','284251','284259','285656','289337','292534','150366','150367','150368','150369','150370','150371','150372','150373','150374','150375','150376','150377','150378','150379','150380','150381','150382','150383','151640','153404','162204','163502','163503','163504','163505','163506','163507','163509','163510','170739','170740','170748','201166','213492','213493','213494','213495','213496','213498','213499','213500','213501','213502','213503','213504','213505','213506','213507','213508','213509','213510','213511','213512','213513','213514','213515','213516','213517','213518','213519','213520','213521','213522','213523','213524','213525','213526','213527','213528','213529','213530','213531','213532','213533','213534','213535','213536','213537','213538','213539','213540','213541','213542','213543','213544','213545','213546','213547','213548','213549','213550','213551','215547','244256','246345','253309','253310','253311','253312','253313','253314','253315','253316','253317','253318','263755','263756','266469','269606','273369','273854','275992','276054','279334','285254','295332','297508','299494','299662','300670','302309','304191','304614','213564','213565','213566','213567','213568','213569','213570','213571','213572','213573','213574','213575','213576','213577','213578','213579','213580','213581','213582','213583','213584','213585','213586','213587','213588','213589','213590','213591','213592','213593','213594','213595','213596','213597','213598','213599','213600','213601','213602','213603','213604','213605','213606','213607','213608','213609','213610','213611','250248','143168','143169','143225','143302','143310','143487','144209','147227','150384','150386','150387','150388','150389','150390','150391','150392','150393','150394','150395','150396','150397','150398','150399','150400','151954','159580','161488','161489','161490','161491','161492','161493','161494','161495','163455','163456','163457','165534','165535','169878','169879','169888','169894','169895','169912','170057','170058','170065','170171','170172','170201','170202','170324','170489','170490','170491','170492','170493','170494','170742','170743','170744','201168','201170','201172','201304','202801','202802','210510','213612','213613','213614','213615','213616','213617','213618','213619','213620','213621','213622','213623','213624','213625','213626','213627','213628','213629','213630','213631','213632','213633','213634','213635','213636','213637','213638','213639','213640','213641','213642','213643','213644','213645','213646','213647','213648','213649','213650','213651','213652','213653','213654','213655','213656','213657','213658','213659','213660','213661','213662','213663','213664','213665','213666','213667','213668','213669','213670','213671','213672','213673','213674','213675','213676','213677','213678','213679','213680','213681','213682','213683','213684','213685','213686','213687','213688','213689','213690','213691','213692','213693','213694','213695','213696','213697','213698','213699','213700','213701','213702','213703','213704','213705','213706','213707','213708','213709','213710','213711','213712','213713','213714','213715','213716','213717','213718','213719','213720','213721','213722','213723','213724','213725','213726','213727','213728','213729','213730','213731','213732','213733','213734','213735','213736','213737','213738','213739','213740','213741','213742','213743','213744','213745','213746','213747','213748','213749','213750','213751','213752','213753','213754','213755','215984','239568','239708','239709','244257','244261','247834','247844','247845','247848','247987','248623','248624','248625','248626','248629','248630','248631','248632','248633','248634','248635','248636','248908','249545','249766','250215','251261','251346','255551','255552','255553','263577','263639','264939','265230','265231','265232','265260','268418','268659','274151','275608','275633','275948','276347','276419','278496','283097','285241','285327','296241','298240','298314','298315','299720','302362','304235','304615','142971','143678','143703','144211','148057','149706','150069','150070','150071','150072','150073','150074','150401','153083','153084','158966','158967','159038','159455','159544','160836','160837','161302','163161','163225','163226','163319','163453','164022','164256','164503','164693','164872','165288','165290','165291','165292','165542','165640','165875','165963','165964','166338','166342','166411','166756','166757','166758','166759','166780','166803','166804','166805','166806','166807','166808','166809','166810','166811','166812','166813','166814','166815','166816','166817','166818','167028','167180','167239','167381','167493','167494','167495','167496','168000','168001','169937','169946','170059','170060','170063','170064','170279','170479','170481','170482','170483','170484','170508','170747','170750','170752','201236','201301','201305','201306','201320','202687','202698','202700','202727','202803','202817','210509','210511','211302','211303','211304','211305','211306','211307','211308','211309','211310','211311','211312','211313','211314','211315','211316','211317','211318','211319','211320','211321','211322','211323','211324','211325','211326','211327','211328','211329','211330','211331','211332','211333','211334','211335','211336','211337','211338','211339','211340','211341','211342','211343','211344','211345','211346','211347','211348','211349','211350','211351','211352','211353','211354','211355','211356','211357','211358','211359','211360','211361','211362','211363','211364','211365','211366','211367','211368','211369','211370','211371','211372','211373','211374','211375','211376','211377','211378','211379','211380','211381','211382','211383','211384','211385','211386','211387','211388','211389','211390','211391','211392','211393','211394','211395','211396','211397','211398','211399','211400','211401','211402','211403','211404','211405','211406','211407','211408','211409','211410','211411','211412','211413','211414','211415','211416','211417','211418','211419','211420','211421','211422','211423','211424','211425','211426','211427','211428','211429','211430','211431','211432','211433','211434','211435','211436','211437','211438','211439','211440','211441','211442','211443','211444','211445','211446','211447','211448','211449','211450','211451','211452','211453','211454','211455','211456','211457','211458','211459','211460','211461','211462','211463','211464','211465','213838','213839','213840','213841','213842','213843','213844','213845','213846','213847','213848','213849','213850','213851','213852','213853','213854','213855','213856','213857','213858','213859','213860','213861','213862','213863','213864','213865','213866','213867','213868','213869','213870','213871','213872','213873','213874','213875','213876','213877','213878','213879','213880','213881','213882','213883','213884','213885','213886','213887','213888','213889','213890','213891','213892','213893','213894','213895','213896','213897','213898','213899','213900','213901','213902','213903','213904','213905','213906','213907','213908','213909','213910','213911','213912','213913','213914','213915','213916','213917','213918','213919','213920','213921','213922','213923','213924','213925','213926','213927','213928','213929','213930','213931','213932','213933','213934','213935','213936','213937','213938','213939','213940','213941','213942','213943','213944','213945','213946','213947','213948','213949','213950','213951','213952','213953','213954','213955','213956','213957','213958','213959','213960','213961','213962','213963','213964','213965','213966','213967','213968','213969','213970','213971','213972','213973','213974','213975','213976','213977','213978','213979','213980','213981','213982','213983','213984','213985','213986','213987','213999','214000','214001','214002','214003','214004','214005','214006','214007','214008','214009','214010','214011','214012','214013','214014','214015','214016','214017','214018','214019','214020','214021','214022','214025','214029','214030','214031','214032','214033','214034','214035','214036','214037','214038','214039','214040','214041','214042','214043','214044','214045','214046','214047','214048','214049','214050','214051','214052','214053','214054','214055','214056','214057','214058','214059','214060','214061','214062','214063','214064','214065','214066','214067','214068','214069','214070','214071','215248','215431','215500','215622','215776','215798','215897','232398','232407','232408','232429','232430','232431','232432','232435','239697','240044','240119','240271','240272','240273','240274','240337','240582','241551','241685','241883','241903','243032','243148','243176','243319','243411','243870','244255','244669','244765','244766','244768','245456','245589','246010','246011','246032','246033','246057','246060','246506','246507','246508','246509','246510','246511','246512','246513','246514','246515','246516','246517','247208','247277','247286','247287','247299','247300','247335','247829','248109','248124','248125','248520','249063','249174','249175','249176','249351','249406','249591','249622','249745','249884','250027','250028','250029','250030','250031','250032','250033','250034','250035','250036','250037','250038','250054','250067','250068','250069','250102','250349','250535','250536','250537','250538','250564','250565','250566','250567','250568','250569','250570','250571','250572','250573','250960','251284','251337','251524','251525','251526','251527','251528','251529','251530','251531','251532','251533','251534','251535','251536','251537','251538','251609','251661','253120','253207','253283','254648','255516','255530','256024','256071','256074','256204','256358','256359','256597','256950','257231','261971','261972','262363','262364','262365','262411','262436','262927','263659','264442','265047','265066','265067','265130','265131','265132','265133','265302','265325','265616','265617','265618','265697','265957','265962','265967','266514','267604','267777','267779','267780','267879','268064','268113','268114','268128','269115','269161','269404','269405','269424','269425','273443','273898','273914','274026','274036','274371','274831','274998','275122','275123','275124','275131','275488','276284','276680','276695','276775','277483','278087','278261','278262','278263','278264','278296','278297','278298','278299','278300','278301','278514','278515','278516','278557','278751','278817','278818','279192','279306','279407','280333','280466','281795','281796','281797','281798','281866','282034','282104','282156','282157','282279','282280','282294','282315','282316','282318','282319','282320','282321','282489','282890','283342','283495','285157','285163','285636','285730','285769','286356','286384','286607','288131','288601','288995','289086','291690','291705','291769','291871','292306','292408','292409','292579','292688','292695','292712','293602','294066','295283','295341','296239','297023','297272','297292','297714','298176','298250','298587','299258','299382','299695','299908','300033','300070','300273','300508','300509','300510','300511','300655','300676','300699','300711','301795','301834','302227','303828','303972','304616','304617','304618','304619','304620','304621','304622','304623','304624','304625','304626','304627','304628','304629','304630','304631','143303','143304','143484','143485','150402','150403','161496','163861','170488','214072','214073','214074','214075','214076','214077','214078','214079','214080','214081','239663','239664','241975','243225','244643','245525','248059','248622','249477','249493','251170','254625','261798','263576','264842','264843','264979','265295','267595','268104','275642','284337','284546','287200','294683','144212','148161','150085','150086','154946','157558','163397','163398','163399','165641','169820','170200','170745','211542','211543','211544','211545','214082','214083','214084','214085','214086','214087','214088','214089','214090','214091','214092','214093','214094','214095','214096','214097','214098','214099','214100','214101','214102','214103','214104','214105','214106','214107','214108','214109','214110','214111','214112','214113','214114','214115','214116','214117','214118','214119','214120','214121','214122','214123','214124','214125','214126','214127','214128','214129','214130','214131','214132','239847','244158','244947','247043','248627','248628','248992','249262','249882','249883','249938','249946','254984','256256','256322','256748','256772','256773','256774','256775','256776','263575','265504','267778','269446','273862','274142','277515','283038','284673','286830','288998','288999','289000','295620','295853','295855','295856','295857','295858','295859','295860','295861','301893','143309','147385','150404','162485','163511','169882','169883','170056','170061','170062','170173','170174','170175','170196','170197','170741','170751','201169','214133','214134','214135','214136','214137','214138','214139','214140','214141','214142','214143','214144','214145','214146','214147','214148','214149','214150','214151','214152','214153','214154','214155','214156','214157','214158','214159','214160','214161','214162','214163','214164','214165','214166','214167','214168','214169','214170','214171','214172','214173','214174','214175','214176','214177','214178','214179','214180','214181','214182','214183','214184','214185','214186','214187','214188','214189','214190','214191','214192','214193','214194','214195','214196','214197','214198','214199','241278','249891','249892','294668','161719','161720','161721','161722','165289','165383','165384','214200','214201','214202','214203','214204','214205','214206','214207','214208','214209','214210','214211','214212','214213','214214','214215','214216','214217','214218','214219','214220','214221','214222','214223','214224','214225','214226','214227','214228','214229','214230','214231','214232','214233','214234','214235','214236','214237','214238','214239','214240','214241','214242','214243','214244','214245','214246','214247','214248','214249','214250','214251','214252','214253','214254','214255','214256','214257','214258','214259','214260','214261','214262','214263','214264','214265','214266','214267','214268','214269','214270','214271','214272','214273','214274','214275','214276','214277','214278','214279','214280','214281','214282','214283','214284','214285','214286','214287','214288','214303','214304','214305','214306','214307','214308','214309','214310','214311','214312','214313','214314','214315','214316','214317','214318','214319','214320','214321','214322','214323','214325','214326','214327','214328','214329','214330','214331','214332','214333','214334','214335','214336','214337','214338','214339','214340','214341','214342','214343','214344','214345','214346','214347','214348','214349','214350','214351','214352','214353','214354','214355','214356','214357','214358','214359','214360','214361','214362','214363','214364','214365','214366','214367','214368','214369','214370','214371','214372','214373','214374','214375','214376','214377','214378','214379','214380','214381','214382','214383','214384','214385','214386','214387','214388','214389','243187','243410','246096','247012','247824','247825','247826','247827','248882','250343','250458','250510','265042','273317','273318','286136','288756','289203','304632','304633','304634','304635','304636','304637','304638','304639','304640','304641','304642','304643','304644','304645','304646','143480','143670','150405','150406','150407','150408','150409','158410','161487','163454','165356','165674','165678','170183','170239','170486','170487','214402','214403','214404','214405','214406','214407','214408','214409','214410','214411','214412','214413','214414','214415','214416','214417','214418','214419','214420','214421','214422','214423','214424','214425','214426','239662','243844','249586','251423','251477','254302','255349','256120','256792','264633','265532','268512','268804','268805','268808','269109','276024','278406','280999','281000','281127','281780','282758','283184','283185','283186','284253','284254','284256','284257','284258','287108','295588','295851','295852','298260','300208','147068','150181','150182','150183','150184','150410','150411','150412','150413','150414','150415','150416','150417','150418','153216','153217','153218','159399','161110','161486','161518','161519','166395','166396','166397','170782','170783','170784','212039','212040','212041','212042','212043','212044','212045','212046','212047','212048','212049','212050','212051','212052','212053','212054','212055','212056','212057','212058','212059','212060','212061','212062','212063','212064','212065','212066','212067','212068','212069','212070','212071','212072','212073','212074','212075','212076','212077','212078','212079','212080','212081','212082','212083','212084','212085','212086','212087','214427','214428','214429','214430','214431','214432','214433','214434','214435','214436','214437','214438','214439','214440','214441','214442','214443','214444','214445','214446','214447','214448','214449','214450','214451','214452','214453','214454','214455','214456','214457','214458','214459','214460','214461','214462','214463','214464','214465','214466','214467','214468','214469','214470','214471','214472','214473','214474','214475','214476','214477','214478','214479','214480','214481','214482','214483','214484','214485','214486','214487','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534','214535','214536','214537','214538','214539','214540','214541','232475','232501','240055','240149','240587','240782','240783','240784','241277','242090','242319','242459','242464','242465','242466','242467','242645','242700','242738','242739','242740','242741','242742','242743','242744','242745','242826','242827','242828','242837','243080','243221','243315','243324','245084','245990','247810','249509','249510','249511','250351','250851','250852','251000','251001','251097','251122','251123','251124','251253','251702','251822','251823','251855','251856','251978','254779','255519','261933','262622','262660','263569','264673','264674','264677','266789','268108','268121','268419','268420','268435','268436','268437','268438','268439','268440','268441','268442','268443','268444','268445','268727','268841','273559','275403','275733','276056','277944','277945','278115','278374','278376','278400','278604','279137','279169','279201','279275','279558','279566','279572','279573','279574','279575','279678','280596','280597','280897','280898','280899','281625','282531','283233','283513','283514','283515','283561','284463','284464','284536','284633','284634','284740','284741','285306','285587','286145','286146','286282','286363','286368','286992','287003','287044','288362','288466','288892','288996','288997','289386','289387','289411','289423','291587','291696','292069','292267','292391','292392','292393','292394','292538','292764','292765','293385','293454','294150','294151','294352','294920','297094','297133','297222','297741','297742','297743','297744','297745','297746','297747','297781','297782','297827','297828','297830','297832','297938','297939','297940','298013','298328','299194','299474','299531','299560','299873','299874','299875','300003','300051','302232','164439','245169','246678','247506','247909','248310','253338','255494','256600','262559','262560','264967','264968','264969','264970','268109','268110','269190','269406','269545','276793','277203','278118','278745','278746','286847','286848','288033','288966','289418','289493','294025','294692','299062','300558','301827','303973','142911','143242','143305','143308','150188','150707','151270','151271','151272','153952','154157','154525','157411','157412','157413','157414','157415','157416','157417','157418','157419','157420','157421','157422','158066','158151','158152','158265','158482','158483','158484','158503','158504','158505','158506','158507','158761','158812','158987','159067','159068','159069','159081','159119','159178','159179','159180','159181','159182','159183','159317','159361','159400','159517','159627','159628','159786','159787','159899','159900','160023','160024','160025','160026','160027','160028','160029','160030','160031','160032','160033','160146','160147','160185','160186','160543','160795','160796','160970','160971','160972','160973','160991','161074','161152','161153','161168','161169','161170','161171','161198','161221','161269','161301','161374','161375','161376','161377','161480','161482','161526','161689','161690','161730','161731','161732','161733','161734','161735','161736','161740','161752','161796','161799','161930','161938','161982','161998','162042','162043','162044','162045','162046','162047','162054','162055','162056','162057','162058','162059','162060','162138','162169','162170','162241','162296','162334','162393','162394','162395','162445','162446','162450','162504','162505','162506','162507','162508','162509','162535','162536','162537','162538','162554','162616','162618','162627','162628','162629','162630','162631','162632','162648','162649','162652','162716','162774','163343','163664','163665','163666','163667','163772','163821','163862','163888','163976','164082','164083','164092','164137','164138','164139','164184','164292','164318','164410','164516','164517','164518','164547','164573','165137','165138','165139','165145','165160','165366','165367','165545','165566','165683','165718','165719','165720','165721','165722','165730','165780','165781','165804','165834','165835','165850','166043','166044','166059','166060','166070','166124','166125','166132','166162','166423','166448','166494','166619','166620','166655','166676','166959','167139','167215','167281','167282','167472','167473','167492','167644','167646','167647','167696','167697','167698','167765','167766','168056','169863','169864','170133','170161','170162','170163','170166','170167','170168','170169','170176','170188','170189','170191','170192','170198','170275','170495','170496','170497','170498','170499','170501','170560','201164','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222','212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','214542','214543','214544','214545','214546','214547','214548','214549','214550','214551','214552','214553','214554','214555','214556','214557','214558','214559','214560','214561','214562','214563','214564','214565','214573','214574','214575','214576','214577','214579','214583','214587','214588','214589','214590','214591','214592','214593','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640','214642','214643','214644','214645','214646','214647','214648','214649','214650','214651','214652','214653','214654','214655','214656','214657','214658','214659','214660','214661','214662','214663','214664','214665','214666','214667','214668','214669','214670','214671','214672','214673','214674','214675','214676','214677','214678','214679','214680','214681','214682','214683','214684','214685','214686','214687','214688','214689','214690','214691','214692','214693','214694','214695','214696','214697','214698','214699','214700','214701','214702','214703','214704','214705','214706','214707','214708','214709','214710','214711','214712','214713','214714','214715','214716','214717','214718','214719','214720','214721','214722','214723','214724','214725','214726','214727','214728','214729','214730','214731','214732','214733','214734','214735','214736','214737','214738','214739','214740','214741','214742','214743','214744','214745','214746','214747','214748','214749','214750','214751','215634','215635','215636','215664','215665','215666','215667','215668','215669','215670','215671','215672','215673','215674','215675','215676','215677','215678','215679','215680','215681','215682','215807','215808','215809','215810','215811','215812','215813','215814','215815','215816','215817','215818','215819','215820','216056','216057','216058','216059','232787','232788','232798','232799','232800','238037','238038','238039','238040','238073','238074','238075','238076','238094','238095','238096','238222','238223','238224','238225','238226','238227','238228','238458','238480','238482','238483','238485','238486','238487','238488','238489','238490','238728','239040','239042','239180','239181','239218','239219','239304','239305','239306','239318','239469','239470','239471','239472','239473','239474','239475','239476','239628','239629','239630','239631','239632','239826','239894','239895','239918','239919','239920','239939','239940','239941','239942','239943','239944','239945','240150','240151','240185','240186','240187','240350','240488','240583','240599','240600','240601','240602','240603','240604','240605','240606','240607','240608','240670','240673','240674','240675','240676','240677','240678','240679','240680','240681','240682','240683','240684','240718','240719','240720','240721','240738','240739','240740','240743','240788','240789','240790','240791','240792','240793','240794','240795','240796','240797','240798','240799','240800','241080','241123','241124','241456','241457','241458','241459','241460','241518','241519','241598','241611','241612','241811','241812','241813','241920','241921','241922','241928','241929','241930','241931','242006','242007','242016','242021','242026','242067','242201','242202','242203','242204','242271','242272','242273','242274','242275','242276','242277','242292','242512','242517','242686','242687','242688','242689','242763','242764','242765','242766','242782','242783','242932','242959','242960','242968','242989','242990','243239','243240','243241','243259','243260','243261','243262','243263','243264','243540','243541','243542','243543','243544','243545','243546','243700','243701','243702','243703','243940','243941','243942','243943','244002','244003','244082','244136','244163','244203','244204','244205','244237','244238','244239','244338','244372','244373','244531','244532','244533','244534','244570','244652','244653','244654','244727','244728','244733','244825','244826','244943','244944','244945','244946','244949','245011','245047','245048','245049','245173','245212','245270','245287','245288','245289','245290','245291','245554','245555','245556','245557','245562','245575','245596','245716','245886','246084','246085','246086','246087','246088','246089','246090','246091','246092','246093','246191','246283','246284','246388','246389','246444','246557','246558','246559','246560','246561','246562','246733','246734','246920','247037','247084','247267','247296','247371','247372','247373','247819','248066','248067','248083','248084','248094','248095','248096','248097','248098','248099','248100','248101','248408','248643','248644','248645','248839','248858','248962','249203','249281','249282','249384','249495','249496','249497','249571','249572','249598','249647','249681','249708','249737','249738','249772','249773','249829','249830','249831','249866','249911','249912','250109','250145','250146','250285','250325','250449','250474','250475','250476','250477','250478','250479','250513','250514','250515','250516','250517','250518','250520','250608','250609','250675','250728','250757','250758','250759','250818','250931','250932','251034','251066','251146','251158','251159','251206','251234','251281','251347','251348','251481','251482','251483','251484','251485','251486','251766','252023','252071','252072','252074','252118','253612','253614','253615','253616','254321','254328','254419','254420','254564','254744','254745','254746','254747','254908','254909','254910','254911','254912','254913','254914','254915','255020','255129','255130','255132','255133','255135','255136','255137','255182','255210','255286','255382','255521','255575','255590','255632','255656','256199','256758','256762','256763','256764','256765','256766','256796','256879','256880','256881','256882','256883','256884','256885','256886','256887','256888','256889','256890','256891','256892','256893','256894','256895','256896','256897','256898','256899','256900','256901','257120','257121','257122','257123','257124','257125','257126','257127','257128','257179','261797','262264','262265','262266','262267','262268','262270','262272','262367','262368','262601','262771','262782','262784','262800','262801','262802','262803','262804','262805','262806','262816','262817','262818','262819','262820','262821','262975','262976','262977','263046','263047','263048','264522','264523','264524','264525','264526','264527','264610','264611','264612','264613','264614','264615','264616','264618','264619','264652','264701','264702','264703','264933','264984','265126','265312','265313','265320','265383','265527','265528','265529','265530','265531','265865','265918','265968','265969','265981','266107','266179','266687','266688','266696','266850','266942','267012','267013','267149','267150','267151','267152','267153','267451','267509','267510','267511','267512','267889','268072','268075','268157','268184','268185','268186','268187','268188','268189','268190','268191','268481','268482','268633','268634','268635','268636','268637','269159','269342','269614','269615','269616','269617','269618','269619','269620','269621','269622','273532','273569','273570','273571','273572','273668','273669','274013','274304','274675','274736','274737','274738','274739','274740','274741','274878','275341','275342','275343','275344','275345','275346','275347','275348','275349','275350','275354','275366','275367','275643','275644','275645','275646','275647','275648','275649','275650','275651','275652','275653','275672','275673','276667','277177','277285','277644','277656','277790','278344','278345','278366','278692','278847','278852','279164','279454','279513','279711','279712','279782','281233','281434','282325','282326','282832','283302','283303','283610','284517','284518','285954','286352','286372','286402','286817','286872','288157','288158','288159','288286','288626','288627','291637','291638','291639','291640','291787','291854','292858','293515','293931','293932','294910','294911','294912','295329','295578','295789','295790','297368','297624','297625','297626','297627','297682','297858','298321','298543','298544','299164','299479','299834','300185','300219','300220','300279','300280','300281','300283','300284','300285','300286','300287','300288','300292','300293','300294','300295','300296','300327','300329','300330','300331','300332','300435','300937','301931','301988','302186','303864','303865','304114','304147','304155','304156','304157','304158','304159','304647','304648','304649','304650','304651','304652','304653','304654','304655','304656','304657','304658','304659','304660','304661','304662','150189','150190','150191','158501','159258','160684','161820','161948','162396','162952','162953','162954','162955','162956','162957','162958','162959','162960','162961','162962','162963','162964','163400','163401','164823','164976','166091','166595','167509','170746','212236','212237','212238','212239','212240','214752','214753','214754','214755','214756','214757','214758','214759','214760','214761','214762','214763','214764','214765','214766','214767','214768','214769','214770','214771','214772','214773','214774','214775','214776','214777','214778','214779','214780','214781','214782','214783','214784','214785','214786','214787','214788','214789','214790','214791','214792','214793','214794','214795','214796','214797','214798','214799','214800','214801','214802','214803','214804','214805','214806','214807','214808','214809','214810','214811','214812','214813','214814','214815','214816','214817','214818','214819','214820','214821','214822','214823','214824','214825','214826','214827','214828','214829','214830','214831','214832','214833','214834','214835','214836','214837','214838','214839','214840','214841','214842','214843','214844','214845','214846','214847','214848','214849','214850','214851','214852','214853','214854','214855','214856','214857','214858','214859','214860','214861','214862','214863','214864','214865','214866','214867','214868','214869','214870','214871','214872','214873','214874','214875','214876','214877','214878','214879','214880','214881','214882','214883','214884','214885','214886','214887','214888','214889','214890','214891','214892','214893','214894','214895','214896','214897','214898','214899','214900','214901','214902','214903','214904','214905','214906','214907','214908','214909','214910','214911','214912','214913','214914','214915','214916','214917','214918','214919','214920','214921','214922','214923','214924','214925','214926','214927','214928','214929','214930','214931','214932','214933','214934','214935','214936','214937','214938','214939','214940','214941','214942','214943','214944','214945','214946','214947','214948','214949','214950','214951','214952','214953','214954','214955','214956','214957','214958','214959','214960','214961','214962','214963','214964','214965','214966','214967','239250','239946','240026','241012','242014','242836','243554','244169','245072','245851','246156','246240','246241','246242','247686','247836','247837','247838','247839','247840','247841','247842','248522','248523','249765','249855','250216','250591','250592','251336','252170','255012','256108','256206','256794','263638','263656','264433','265007','265075','265163','265463','265464','265577','265578','265579','265694','266439','266735','266954','266997','267231','267232','267233','267534','267535','267717','267755','267930','268168','268328','268421','268422','268423','268424','268425','268426','268427','268428','268429','268430','268431','268432','268433','268434','268897','273331','273599','273726','273980','274033','274450','274601','275632','277208','278083','278373','278911','278913','278914','278915','278916','278917','278918','278919','278920','278921','278922','278923','278924','278925','278986','279203','279485','279486','279487','279488','279489','280303','280305','281164','282248','282249','282272','283492','283672','284285','285000','285006','285017','285020','285784','285820','285821','286424','287159','287160','288291','288489','288540','288541','289008','289298','289393','289394','291828','292226','292232','292752','293419','293420','294168','294547','294621','294622','295300','295780','295872','296249','297104','297224','297249','297319','297479','297480','297481','297482','297483','297484','297485','297486','297487','297488','297489','297490','297491','297492','297493','297494','297495','297496','297497','297498','297499','297500','297501','297502','297503','297504','297505','297506','297507','297778','297958','298126','298127','298128','299630','300048','300206','300207','300609','301928','302055','302105','302162','302169','302170','303884','150420','214972','214973','214974','214975','214976','214977','214978','214979','214980','214981','214982','214983','214984','214985','214986','214987','214988','214989','214990','214991','214992','214993','214994','214995','214996','214997','214998','214999','215000','215001','215002','215003','215004','215005','215006','215007','215008','215009','215010','215011','215012','215013','215014','215015','215016','215017','215018','215019','249121','249122','253660','264838','279011','281662','284252','284541','284593','284595','295317','300234','264436','264509','264510','264557','264558','264809','264855','266007','267970','268408','269535','269613','273332','273409','273410','273442','274602','274653','275039','275191','278113','278181','278556','281480','284255','284720','285002','285057','285194','285657','287199','287986','288962','289009','291685','292036','294169','294630','294802','295342','297198','299079','299683','300199','302187','269407','274157','275964','277826','278119','278816','280322','281717','282869','284250','286849','293506','298437','298474','302167') 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 ('142911','142971','143168','143169','143225','143242','143302','143303','143304','143305','143308','143309','143310','143480','143484','143485','143487','143603','143670','143678','143703','144209','144211','144212','147068','147227','147385','148057','148161','149706','150069','150070','150071','150072','150073','150074','150085','150086','150181','150182','150183','150184','150188','150189','150190','150191','150366','150367','150368','150369','150370','150371','150372','150373','150374','150375','150376','150377','150378','150379','150380','150381','150382','150383','150384','150386','150387','150388','150389','150390','150391','150392','150393','150394','150395','150396','150397','150398','150399','150400','150401','150402','150403','150404','150405','150406','150407','150408','150409','150410','150411','150412','150413','150414','150415','150416','150417','150418','150420','150707','151270','151271','151272','151482','151640','151954','153083','153084','153216','153217','153218','153404','153952','154157','154525','154946','155732','157411','157412','157413','157414','157415','157416','157417','157418','157419','157420','157421','157422','157558','157950','158066','158151','158152','158265','158410','158482','158483','158484','158501','158503','158504','158505','158506','158507','158571','158761','158812','158966','158967','158987','159038','159067','159068','159069','159081','159119','159178','159179','159180','159181','159182','159183','159258','159317','159361','159399','159400','159455','159517','159544','159580','159627','159628','159786','159787','159899','159900','160023','160024','160025','160026','160027','160028','160029','160030','160031','160032','160033','160146','160147','160185','160186','160543','160684','160795','160796','160836','160837','160901','160970','160971','160972','160973','160991','161074','161110','161152','161153','161168','161169','161170','161171','161198','161221','161269','161301','161302','161374','161375','161376','161377','161379','161480','161482','161486','161487','161488','161489','161490','161491','161492','161493','161494','161495','161496','161518','161519','161526','161689','161690','161719','161720','161721','161722','161730','161731','161732','161733','161734','161735','161736','161740','161752','161796','161799','161820','161930','161938','161948','161982','161998','162042','162043','162044','162045','162046','162047','162053','162054','162055','162056','162057','162058','162059','162060','162138','162169','162170','162204','162241','162296','162334','162393','162394','162395','162396','162445','162446','162450','162485','162504','162505','162506','162507','162508','162509','162535','162536','162537','162538','162554','162616','162618','162627','162628','162629','162630','162631','162632','162648','162649','162652','162716','162774','162952','162953','162954','162955','162956','162957','162958','162959','162960','162961','162962','162963','162964','163161','163225','163226','163319','163343','163397','163398','163399','163400','163401','163453','163454','163455','163456','163457','163502','163503','163504','163505','163506','163507','163509','163510','163511','163664','163665','163666','163667','163677','163678','163772','163821','163861','163862','163888','163976','164022','164082','164083','164092','164137','164138','164139','164184','164256','164292','164318','164410','164439','164503','164516','164517','164518','164547','164573','164693','164823','164872','164889','164976','165137','165138','165139','165145','165160','165288','165289','165290','165291','165292','165356','165366','165367','165383','165384','165534','165535','165542','165545','165566','165640','165641','165674','165678','165683','165718','165719','165720','165721','165722','165730','165780','165781','165804','165834','165835','165850','165875','165963','165964','166043','166044','166059','166060','166070','166091','166124','166125','166132','166162','166338','166341','166342','166345','166346','166347','166348','166349','166350','166351','166352','166353','166354','166355','166356','166357','166358','166359','166360','166361','166362','166363','166364','166365','166366','166367','166368','166369','166370','166371','166372','166373','166374','166375','166376','166377','166378','166379','166380','166381','166382','166383','166384','166385','166386','166387','166388','166389','166390','166391','166392','166395','166396','166397','166411','166423','166448','166494','166595','166619','166620','166655','166676','166756','166757','166758','166759','166780','166791','166803','166804','166805','166806','166807','166808','166809','166810','166811','166812','166813','166814','166815','166816','166817','166818','166959','167028','167139','167180','167215','167239','167281','167282','167381','167472','167473','167492','167493','167494','167495','167496','167509','167644','167646','167647','167696','167697','167698','167765','167766','168000','168001','168056','169820','169863','169864','169878','169879','169882','169883','169888','169894','169895','169912','169937','169946','170056','170057','170058','170059','170060','170061','170062','170063','170064','170065','170133','170161','170162','170163','170166','170167','170168','170169','170171','170172','170173','170174','170175','170176','170183','170188','170189','170191','170192','170196','170197','170198','170200','170201','170202','170239','170275','170279','170324','170410','170479','170481','170482','170483','170484','170486','170487','170488','170489','170490','170491','170492','170493','170494','170495','170496','170497','170498','170499','170501','170508','170560','170739','170740','170741','170742','170743','170744','170745','170746','170747','170748','170750','170751','170752','170782','170783','170784','201164','201166','201168','201169','201170','201171','201172','201236','201301','201304','201305','201306','201320','202687','202698','202700','202727','202801','202802','202803','202817','210509','210510','210511','210512','210513','211302','211303','211304','211305','211306','211307','211308','211309','211310','211311','211312','211313','211314','211315','211316','211317','211318','211319','211320','211321','211322','211323','211324','211325','211326','211327','211328','211329','211330','211331','211332','211333','211334','211335','211336','211337','211338','211339','211340','211341','211342','211343','211344','211345','211346','211347','211348','211349','211350','211351','211352','211353','211354','211355','211356','211357','211358','211359','211360','211361','211362','211363','211364','211365','211366','211367','211368','211369','211370','211371','211372','211373','211374','211375','211376','211377','211378','211379','211380','211381','211382','211383','211384','211385','211386','211387','211388','211389','211390','211391','211392','211393','211394','211395','211396','211397','211398','211399','211400','211401','211402','211403','211404','211405','211406','211407','211408','211409','211410','211411','211412','211413','211414','211415','211416','211417','211418','211419','211420','211421','211422','211423','211424','211425','211426','211427','211428','211429','211430','211431','211432','211433','211434','211435','211436','211437','211438','211439','211440','211441','211442','211443','211444','211445','211446','211447','211448','211449','211450','211451','211452','211453','211454','211455','211456','211457','211458','211459','211460','211461','211462','211463','211464','211465','211542','211543','211544','211545','212039','212040','212041','212042','212043','212044','212045','212046','212047','212048','212049','212050','212051','212052','212053','212054','212055','212056','212057','212058','212059','212060','212061','212062','212063','212064','212065','212066','212067','212068','212069','212070','212071','212072','212073','212074','212075','212076','212077','212078','212079','212080','212081','212082','212083','212084','212085','212086','212087','212213','212214','212215','212216','212217','212218','212219','212220','212221','212222','212223','212224','212225','212226','212227','212228','212229','212230','212231','212232','212233','212234','212235','212236','212237','212238','212239','212240','213492','213493','213494','213495','213496','213498','213499','213500','213501','213502','213503','213504','213505','213506','213507','213508','213509','213510','213511','213512','213513','213514','213515','213516','213517','213518','213519','213520','213521','213522','213523','213524','213525','213526','213527','213528','213529','213530','213531','213532','213533','213534','213535','213536','213537','213538','213539','213540','213541','213542','213543','213544','213545','213546','213547','213548','213549','213550','213551','213564','213565','213566','213567','213568','213569','213570','213571','213572','213573','213574','213575','213576','213577','213578','213579','213580','213581','213582','213583','213584','213585','213586','213587','213588','213589','213590','213591','213592','213593','213594','213595','213596','213597','213598','213599','213600','213601','213602','213603','213604','213605','213606','213607','213608','213609','213610','213611','213612','213613','213614','213615','213616','213617','213618','213619','213620','213621','213622','213623','213624','213625','213626','213627','213628','213629','213630','213631','213632','213633','213634','213635','213636','213637','213638','213639','213640','213641','213642','213643','213644','213645','213646','213647','213648','213649','213650','213651','213652','213653','213654','213655','213656','213657','213658','213659','213660','213661','213662','213663','213664','213665','213666','213667','213668','213669','213670','213671','213672','213673','213674','213675','213676','213677','213678','213679','213680','213681','213682','213683','213684','213685','213686','213687','213688','213689','213690','213691','213692','213693','213694','213695','213696','213697','213698','213699','213700','213701','213702','213703','213704','213705','213706','213707','213708','213709','213710','213711','213712','213713','213714','213715','213716','213717','213718','213719','213720','213721','213722','213723','213724','213725','213726','213727','213728','213729','213730','213731','213732','213733','213734','213735','213736','213737','213738','213739','213740','213741','213742','213743','213744','213745','213746','213747','213748','213749','213750','213751','213752','213753','213754','213755','213838','213839','213840','213841','213842','213843','213844','213845','213846','213847','213848','213849','213850','213851','213852','213853','213854','213855','213856','213857','213858','213859','213860','213861','213862','213863','213864','213865','213866','213867','213868','213869','213870','213871','213872','213873','213874','213875','213876','213877','213878','213879','213880','213881','213882','213883','213884','213885','213886','213887','213888','213889','213890','213891','213892','213893','213894','213895','213896','213897','213898','213899','213900','213901','213902','213903','213904','213905','213906','213907','213908','213909','213910','213911','213912','213913','213914','213915','213916','213917','213918','213919','213920','213921','213922','213923','213924','213925','213926','213927','213928','213929','213930','213931','213932','213933','213934','213935','213936','213937','213938','213939','213940','213941','213942','213943','213944','213945','213946','213947','213948','213949','213950','213951','213952','213953','213954','213955','213956','213957','213958','213959','213960','213961','213962','213963','213964','213965','213966','213967','213968','213969','213970','213971','213972','213973','213974','213975','213976','213977','213978','213979','213980','213981','213982','213983','213984','213985','213986','213987','213999','214000','214001','214002','214003','214004','214005','214006','214007','214008','214009','214010','214011','214012','214013','214014','214015','214016','214017','214018','214019','214020','214021','214022','214025','214029','214030','214031','214032','214033','214034','214035','214036','214037','214038','214039','214040','214041','214042','214043','214044','214045','214046','214047','214048','214049','214050','214051','214052','214053','214054','214055','214056','214057','214058','214059','214060','214061','214062','214063','214064','214065','214066','214067','214068','214069','214070','214071','214072','214073','214074','214075','214076','214077','214078','214079','214080','214081','214082','214083','214084','214085','214086','214087','214088','214089','214090','214091','214092','214093','214094','214095','214096','214097','214098','214099','214100','214101','214102','214103','214104','214105','214106','214107','214108','214109','214110','214111','214112','214113','214114','214115','214116','214117','214118','214119','214120','214121','214122','214123','214124','214125','214126','214127','214128','214129','214130','214131','214132','214133','214134','214135','214136','214137','214138','214139','214140','214141','214142','214143','214144','214145','214146','214147','214148','214149','214150','214151','214152','214153','214154','214155','214156','214157','214158','214159','214160','214161','214162','214163','214164','214165','214166','214167','214168','214169','214170','214171','214172','214173','214174','214175','214176','214177','214178','214179','214180','214181','214182','214183','214184','214185','214186','214187','214188','214189','214190','214191','214192','214193','214194','214195','214196','214197','214198','214199','214200','214201','214202','214203','214204','214205','214206','214207','214208','214209','214210','214211','214212','214213','214214','214215','214216','214217','214218','214219','214220','214221','214222','214223','214224','214225','214226','214227','214228','214229','214230','214231','214232','214233','214234','214235','214236','214237','214238','214239','214240','214241','214242','214243','214244','214245','214246','214247','214248','214249','214250','214251','214252','214253','214254','214255','214256','214257','214258','214259','214260','214261','214262','214263','214264','214265','214266','214267','214268','214269','214270','214271','214272','214273','214274','214275','214276','214277','214278','214279','214280','214281','214282','214283','214284','214285','214286','214287','214288','214303','214304','214305','214306','214307','214308','214309','214310','214311','214312','214313','214314','214315','214316','214317','214318','214319','214320','214321','214322','214323','214325','214326','214327','214328','214329','214330','214331','214332','214333','214334','214335','214336','214337','214338','214339','214340','214341','214342','214343','214344','214345','214346','214347','214348','214349','214350','214351','214352','214353','214354','214355','214356','214357','214358','214359','214360','214361','214362','214363','214364','214365','214366','214367','214368','214369','214370','214371','214372','214373','214374','214375','214376','214377','214378','214379','214380','214381','214382','214383','214384','214385','214386','214387','214388','214389','214390','214391','214392','214393','214394','214395','214396','214397','214398','214399','214400','214401','214402','214403','214404','214405','214406','214407','214408','214409','214410','214411','214412','214413','214414','214415','214416','214417','214418','214419','214420','214421','214422','214423','214424','214425','214426','214427','214428','214429','214430','214431','214432','214433','214434','214435','214436','214437','214438','214439','214440','214441','214442','214443','214444','214445','214446','214447','214448','214449','214450','214451','214452','214453','214454','214455','214456','214457','214458','214459','214460','214461','214462','214463','214464','214465','214466','214467','214468','214469','214470','214471','214472','214473','214474','214475','214476','214477','214478','214479','214480','214481','214482','214483','214484','214485','214486','214487','214488','214489','214490','214491','214492','214493','214494','214495','214496','214497','214498','214499','214500','214501','214502','214503','214504','214505','214506','214507','214508','214509','214510','214511','214512','214513','214514','214515','214516','214517','214518','214519','214520','214521','214522','214523','214524','214525','214526','214527','214528','214529','214530','214531','214532','214533','214534','214535','214536','214537','214538','214539','214540','214541','214542','214543','214544','214545','214546','214547','214548','214549','214550','214551','214552','214553','214554','214555','214556','214557','214558','214559','214560','214561','214562','214563','214564','214565','214573','214574','214575','214576','214577','214579','214583','214587','214588','214589','214590','214591','214592','214593','214594','214595','214596','214597','214598','214599','214600','214601','214602','214603','214604','214605','214606','214607','214608','214609','214610','214611','214612','214613','214614','214615','214616','214617','214618','214619','214620','214621','214622','214623','214624','214625','214626','214627','214628','214629','214630','214631','214632','214633','214634','214635','214636','214637','214638','214639','214640','214642','214643','214644','214645','214646','214647','214648','214649','214650','214651','214652','214653','214654','214655','214656','214657','214658','214659','214660','214661','214662','214663','214664','214665','214666','214667','214668','214669','214670','214671','214672','214673','214674','214675','214676','214677','214678','214679','214680','214681','214682','214683','214684','214685','214686','214687','214688','214689','214690','214691','214692','214693','214694','214695','214696','214697','214698','214699','214700','214701','214702','214703','214704','214705','214706','214707','214708','214709','214710','214711','214712','214713','214714','214715','214716','214717','214718','214719','214720','214721','214722','214723','214724','214725','214726','214727','214728','214729','214730','214731','214732','214733','214734','214735','214736','214737','214738','214739','214740','214741','214742','214743','214744','214745','214746','214747','214748','214749','214750','214751','214752','214753','214754','214755','214756','214757','214758','214759','214760','214761','214762','214763','214764','214765','214766','214767','214768','214769','214770','214771','214772','214773','214774','214775','214776','214777','214778','214779','214780','214781','214782','214783','214784','214785','214786','214787','214788','214789','214790','214791','214792','214793','214794','214795','214796','214797','214798','214799','214800','214801','214802','214803','214804','214805','214806','214807','214808','214809','214810','214811','214812','214813','214814','214815','214816','214817','214818','214819','214820','214821','214822','214823','214824','214825','214826','214827','214828','214829','214830','214831','214832','214833','214834','214835','214836','214837','214838','214839','214840','214841','214842','214843','214844','214845','214846','214847','214848','214849','214850','214851','214852','214853','214854','214855','214856','214857','214858','214859','214860','214861','214862','214863','214864','214865','214866','214867','214868','214869','214870','214871','214872','214873','214874','214875','214876','214877','214878','214879','214880','214881','214882','214883','214884','214885','214886','214887','214888','214889','214890','214891','214892','214893','214894','214895','214896','214897','214898','214899','214900','214901','214902','214903','214904','214905','214906','214907','214908','214909','214910','214911','214912','214913','214914','214915','214916','214917','214918','214919','214920','214921','214922','214923','214924','214925','214926','214927','214928','214929','214930','214931','214932','214933','214934','214935','214936','214937','214938','214939','214940','214941','214942','214943','214944','214945','214946','214947','214948','214949','214950','214951','214952','214953','214954','214955','214956','214957','214958','214959','214960','214961','214962','214963','214964','214965','214966','214967','214972','214973','214974','214975','214976','214977','214978','214979','214980','214981','214982','214983','214984','214985','214986','214987','214988','214989','214990','214991','214992','214993','214994','214995','214996','214997','214998','214999','215000','215001','215002','215003','215004','215005','215006','215007','215008','215009','215010','215011','215012','215013','215014','215015','215016','215017','215018','215019','215248','215431','215500','215547','215622','215634','215635','215636','215664','215665','215666','215667','215668','215669','215670','215671','215672','215673','215674','215675','215676','215677','215678','215679','215680','215681','215682','215776','215798','215807','215808','215809','215810','215811','215812','215813','215814','215815','215816','215817','215818','215819','215820','215897','215984','216056','216057','216058','216059','232398','232407','232408','232429','232430','232431','232432','232435','232475','232501','232523','232787','232788','232798','232799','232800','238037','238038','238039','238040','238073','238074','238075','238076','238094','238095','238096','238222','238223','238224','238225','238226','238227','238228','238458','238480','238482','238483','238485','238486','238487','238488','238489','238490','238728','239040','239042','239180','239181','239218','239219','239250','239304','239305','239306','239318','239469','239470','239471','239472','239473','239474','239475','239476','239568','239569','239628','239629','239630','239631','239632','239662','239663','239664','239697','239708','239709','239710','239826','239847','239894','239895','239918','239919','239920','239939','239940','239941','239942','239943','239944','239945','239946','240026','240044','240055','240119','240149','240150','240151','240185','240186','240187','240271','240272','240273','240274','240337','240350','240488','240512','240582','240583','240587','240599','240600','240601','240602','240603','240604','240605','240606','240607','240608','240670','240673','240674','240675','240676','240677','240678','240679','240680','240681','240682','240683','240684','240718','240719','240720','240721','240738','240739','240740','240743','240782','240783','240784','240788','240789','240790','240791','240792','240793','240794','240795','240796','240797','240798','240799','240800','241012','241080','241123','241124','241277','241278','241456','241457','241458','241459','241460','241518','241519','241551','241598','241611','241612','241685','241811','241812','241813','241883','241903','241920','241921','241922','241928','241929','241930','241931','241975','242006','242007','242014','242016','242021','242026','242067','242090','242201','242202','242203','242204','242271','242272','242273','242274','242275','242276','242277','242292','242319','242459','242464','242465','242466','242467','242512','242517','242645','242686','242687','242688','242689','242700','242738','242739','242740','242741','242742','242743','242744','242745','242763','242764','242765','242766','242782','242783','242826','242827','242828','242836','242837','242932','242959','242960','242968','242989','242990','243032','243080','243148','243176','243187','243221','243225','243239','243240','243241','243259','243260','243261','243262','243263','243264','243315','243319','243324','243410','243411','243540','243541','243542','243543','243544','243545','243546','243554','243700','243701','243702','243703','243844','243870','243940','243941','243942','243943','243987','244002','244003','244082','244089','244098','244136','244158','244163','244169','244203','244204','244205','244237','244238','244239','244255','244256','244257','244258','244260','244261','244338','244372','244373','244531','244532','244533','244534','244570','244643','244652','244653','244654','244669','244727','244728','244733','244765','244766','244768','244825','244826','244943','244944','244945','244946','244947','244949','245011','245047','245048','245049','245072','245084','245169','245173','245212','245270','245287','245288','245289','245290','245291','245456','245525','245554','245555','245556','245557','245562','245575','245589','245596','245716','245851','245886','245990','246010','246011','246032','246033','246057','246060','246084','246085','246086','246087','246088','246089','246090','246091','246092','246093','246096','246156','246191','246240','246241','246242','246283','246284','246345','246388','246389','246444','246506','246507','246508','246509','246510','246511','246512','246513','246514','246515','246516','246517','246557','246558','246559','246560','246561','246562','246571','246572','246573','246574','246575','246576','246577','246578','246579','246580','246581','246678','246733','246734','246920','247012','247037','247043','247084','247208','247267','247277','247286','247287','247296','247299','247300','247335','247371','247372','247373','247506','247686','247810','247819','247824','247825','247826','247827','247828','247829','247830','247832','247833','247834','247835','247836','247837','247838','247839','247840','247841','247842','247843','247844','247845','247846','247847','247848','247909','247987','248059','248066','248067','248083','248084','248094','248095','248096','248097','248098','248099','248100','248101','248109','248124','248125','248310','248408','248520','248522','248523','248622','248623','248624','248625','248626','248627','248628','248629','248630','248631','248632','248633','248634','248635','248636','248643','248644','248645','248757','248839','248858','248882','248908','248962','248992','249063','249121','249122','249174','249175','249176','249179','249180','249203','249262','249281','249282','249351','249384','249406','249477','249493','249495','249496','249497','249509','249510','249511','249545','249571','249572','249586','249591','249598','249622','249647','249681','249708','249737','249738','249745','249765','249766','249772','249773','249829','249830','249831','249855','249866','249882','249883','249884','249891','249892','249911','249912','249938','249946','250027','250028','250029','250030','250031','250032','250033','250034','250035','250036','250037','250038','250054','250064','250067','250068','250069','250102','250109','250145','250146','250215','250216','250248','250285','250325','250343','250349','250351','250449','250458','250474','250475','250476','250477','250478','250479','250510','250513','250514','250515','250516','250517','250518','250520','250535','250536','250537','250538','250564','250565','250566','250567','250568','250569','250570','250571','250572','250573','250591','250592','250593','250594','250608','250609','250675','250728','250757','250758','250759','250818','250851','250852','250931','250932','250960','251000','251001','251034','251066','251097','251122','251123','251124','251146','251158','251159','251170','251179','251206','251234','251253','251261','251281','251284','251336','251337','251346','251347','251348','251423','251477','251481','251482','251483','251484','251485','251486','251524','251525','251526','251527','251528','251529','251530','251531','251532','251533','251534','251535','251536','251537','251538','251609','251650','251661','251670','251702','251746','251766','251822','251823','251855','251856','251978','252023','252071','252072','252074','252118','252170','253120','253207','253283','253309','253310','253311','253312','253313','253314','253315','253316','253317','253318','253338','253612','253614','253615','253616','253660','254302','254321','254328','254419','254420','254564','254625','254648','254744','254745','254746','254747','254779','254908','254909','254910','254911','254912','254913','254914','254915','254984','255012','255020','255129','255130','255132','255133','255135','255136','255137','255182','255210','255286','255349','255382','255494','255516','255519','255521','255530','255551','255552','255553','255575','255590','255632','255656','255666','255714','255715','256024','256071','256074','256108','256120','256199','256204','256206','256256','256322','256358','256359','256442','256443','256597','256600','256748','256758','256762','256763','256764','256765','256766','256772','256773','256774','256775','256776','256792','256794','256796','256879','256880','256881','256882','256883','256884','256885','256886','256887','256888','256889','256890','256891','256892','256893','256894','256895','256896','256897','256898','256899','256900','256901','256950','257120','257121','257122','257123','257124','257125','257126','257127','257128','257179','257231','261797','261798','261933','261971','261972','262264','262265','262266','262267','262268','262270','262272','262363','262364','262365','262367','262368','262411','262436','262559','262560','262601','262622','262660','262771','262782','262784','262800','262801','262802','262803','262804','262805','262806','262816','262817','262818','262819','262820','262821','262927','262975','262976','262977','263046','263047','263048','263569','263575','263576','263577','263638','263639','263656','263659','263755','263756','264433','264436','264442','264509','264510','264522','264523','264524','264525','264526','264527','264557','264558','264610','264611','264612','264613','264614','264615','264616','264618','264619','264633','264652','264673','264674','264677','264701','264702','264703','264809','264838','264842','264843','264855','264933','264939','264967','264968','264969','264970','264979','264984','265007','265042','265047','265066','265067','265075','265126','265130','265131','265132','265133','265163','265230','265231','265232','265260','265295','265302','265312','265313','265320','265325','265383','265463','265464','265504','265527','265528','265529','265530','265531','265532','265577','265578','265579','265616','265617','265618','265694','265697','265865','265918','265957','265962','265967','265968','265969','265981','266007','266107','266179','266439','266469','266514','266687','266688','266696','266735','266789','266850','266942','266954','266997','267012','267013','267149','267150','267151','267152','267153','267231','267232','267233','267451','267509','267510','267511','267512','267534','267535','267595','267604','267717','267755','267777','267778','267779','267780','267879','267889','267930','267970','268064','268072','268075','268104','268108','268109','268110','268113','268114','268121','268128','268157','268168','268184','268185','268186','268187','268188','268189','268190','268191','268328','268408','268418','268419','268420','268421','268422','268423','268424','268425','268426','268427','268428','268429','268430','268431','268432','268433','268434','268435','268436','268437','268438','268439','268440','268441','268442','268443','268444','268445','268481','268482','268512','268633','268634','268635','268636','268637','268659','268727','268804','268805','268808','268841','268897','269109','269115','269159','269161','269190','269342','269404','269405','269406','269407','269424','269425','269446','269535','269545','269606','269613','269614','269615','269616','269617','269618','269619','269620','269621','269622','273317','273318','273331','273332','273369','273409','273410','273442','273443','273532','273555','273559','273569','273570','273571','273572','273599','273668','273669','273726','273854','273862','273898','273914','273980','274013','274026','274033','274036','274142','274151','274157','274304','274371','274450','274601','274602','274653','274675','274736','274737','274738','274739','274740','274741','274831','274878','274998','275039','275122','275123','275124','275131','275191','275341','275342','275343','275344','275345','275346','275347','275348','275349','275350','275354','275366','275367','275403','275488','275608','275632','275633','275642','275643','275644','275645','275646','275647','275648','275649','275650','275651','275652','275653','275672','275673','275733','275948','275964','275992','276024','276054','276056','276284','276347','276419','276667','276680','276695','276775','276793','277177','277203','277208','277285','277483','277515','277644','277656','277790','277826','277944','277945','278083','278087','278113','278115','278118','278119','278181','278261','278262','278263','278264','278296','278297','278298','278299','278300','278301','278344','278345','278366','278373','278374','278376','278400','278406','278496','278514','278515','278516','278556','278557','278604','278692','278745','278746','278751','278816','278817','278818','278847','278852','278911','278913','278914','278915','278916','278917','278918','278919','278920','278921','278922','278923','278924','278925','278986','279011','279137','279164','279169','279192','279201','279203','279275','279306','279334','279407','279454','279485','279486','279487','279488','279489','279513','279558','279566','279572','279573','279574','279575','279678','279711','279712','279782','280303','280305','280322','280333','280466','280596','280597','280598','280897','280898','280899','280999','281000','281127','281164','281233','281434','281480','281625','281662','281717','281780','281795','281796','281797','281798','281866','282034','282104','282156','282157','282248','282249','282272','282279','282280','282294','282315','282316','282318','282319','282320','282321','282325','282326','282489','282531','282758','282832','282869','282890','283038','283097','283184','283185','283186','283233','283302','283303','283342','283492','283495','283513','283514','283515','283561','283610','283672','284250','284251','284252','284253','284254','284255','284256','284257','284258','284259','284285','284337','284463','284464','284517','284518','284536','284541','284546','284593','284595','284633','284634','284673','284720','284740','284741','285000','285002','285006','285017','285020','285057','285157','285163','285194','285241','285254','285306','285327','285587','285636','285656','285657','285730','285769','285784','285820','285821','285954','286136','286145','286146','286282','286352','286356','286363','286368','286372','286384','286402','286424','286607','286817','286830','286847','286848','286849','286872','286992','287003','287044','287108','287159','287160','287199','287200','287986','288033','288131','288157','288158','288159','288286','288291','288362','288466','288489','288540','288541','288601','288626','288627','288756','288892','288962','288966','288995','288996','288997','288998','288999','289000','289008','289009','289086','289203','289298','289337','289386','289387','289393','289394','289411','289418','289423','289493','291587','291637','291638','291639','291640','291685','291690','291696','291705','291769','291787','291828','291854','291871','292036','292069','292226','292232','292267','292306','292391','292392','292393','292394','292408','292409','292534','292538','292579','292688','292695','292712','292752','292764','292765','292858','293385','293419','293420','293454','293506','293515','293602','293931','293932','294025','294066','294150','294151','294168','294169','294352','294547','294621','294622','294630','294668','294683','294692','294802','294910','294911','294912','294920','295283','295300','295317','295329','295332','295341','295342','295578','295588','295620','295780','295789','295790','295851','295852','295853','295855','295856','295857','295858','295859','295860','295861','295872','296239','296241','296249','297023','297094','297104','297133','297198','297222','297224','297249','297272','297292','297319','297368','297479','297480','297481','297482','297483','297484','297485','297486','297487','297488','297489','297490','297491','297492','297493','297494','297495','297496','297497','297498','297499','297500','297501','297502','297503','297504','297505','297506','297507','297508','297624','297625','297626','297627','297682','297714','297741','297742','297743','297744','297745','297746','297747','297778','297781','297782','297827','297828','297830','297832','297858','297938','297939','297940','297958','298013','298126','298127','298128','298176','298240','298250','298260','298314','298315','298321','298328','298437','298474','298543','298544','298587','299062','299079','299164','299194','299258','299382','299474','299479','299494','299531','299560','299630','299662','299683','299695','299720','299834','299873','299874','299875','299908','300003','300033','300048','300051','300070','300185','300199','300206','300207','300208','300219','300220','300234','300273','300279','300280','300281','300283','300284','300285','300286','300287','300288','300292','300293','300294','300295','300296','300327','300329','300330','300331','300332','300435','300508','300509','300510','300511','300558','300609','300655','300670','300676','300699','300711','300937','301795','301827','301834','301893','301928','301931','301988','302055','302105','302162','302167','302169','302170','302186','302187','302227','302232','302309','302362','303828','303864','303865','303884','303972','303973') GROUP BY `manuf` ORDER BY `manuf` ASC