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

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','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','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','153404','162204','163502','163503','163504','163505','163506','163507','163509','163510','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','250248','159580','161488','161489','161490','161491','161492','161493','161494','161495','163455','163456','163457','165534','165535','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','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','210511','213999','214000','214001','214002','214003','214004','214005','214016','214017','214018','214019','214020','214021','214022','214025','214067','214068','214069','214070','214071','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','161496','163861','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','154946','157558','163397','163398','163399','165641','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','162485','163511','241278','249891','249892','294668','161719','161720','161721','161722','165289','165383','165384','243187','243410','246096','247012','247824','247825','247826','247827','248882','250343','250458','250510','265042','273317','273318','286136','288756','289203','158410','161487','163454','165356','165674','165678','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','153216','153217','153218','159399','161110','161486','161518','161519','166395','166396','166397','214482','214539','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','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','214564','214565','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','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','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','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 ('150401','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','210511','213999','214000','214001','214002','214003','214004','214005','214016','214017','214018','214019','214020','214021','214022','214025','214067','214068','214069','214070','214071','214482','214539','214564','214565','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','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','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','153404','162204','163502','163503','163504','163505','163506','163507','163509','163510','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','250248','159580','161488','161489','161490','161491','161492','161493','161494','161495','163455','163456','163457','165534','165535','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','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','210511','213999','214000','214001','214002','214003','214004','214005','214016','214017','214018','214019','214020','214021','214022','214025','214067','214068','214069','214070','214071','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','161496','163861','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','154946','157558','163397','163398','163399','165641','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','162485','163511','241278','249891','249892','294668','161719','161720','161721','161722','165289','165383','165384','243187','243410','246096','247012','247824','247825','247826','247827','248882','250343','250458','250510','265042','273317','273318','286136','288756','289203','158410','161487','163454','165356','165674','165678','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','153216','153217','153218','159399','161110','161486','161518','161519','166395','166396','166397','214482','214539','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','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','214564','214565','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','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','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','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 ('150401','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','210511','213999','214000','214001','214002','214003','214004','214005','214016','214017','214018','214019','214020','214021','214022','214025','214067','214068','214069','214070','214071','214482','214539','214564','214565','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