Светотехника, стр. 86

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 ('20','152','153','154','156','246','247','249','289','157945','170767','170768','216105','216106','240205','242447','242448','242570','242574','245743','246409','246818','249245','249922','250345','251038','251273','251316','253707','262407','293896','293898','293900','293901','293902','293903','293905','210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136','167706','250862','251241','251242','251243','252192','252193','264730','265234','265836','273399','274922','274944','278164','278623','286824','286825','294041','294454','294455','294456','294457','294458','294459','294460','298477','143580','153881','158877','159339','211877','211878','211879','211880','211881','211882','211883','211884','211885','211886','211887','211888','211889','211890','211891','211892','211893','211894','211895','211896','211897','211898','211899','211900','211901','211902','211903','211904','211905','211906','211907','211908','211909','211910','211911','211912','211913','211914','211915','211916','211917','211918','211919','215287','240532','268147','268148','268658','281031','292016','294338','142755','147708','157636','158293','160373','160374','160746','160922','167995','170393','170394','202577','209215','211920','211921','211922','211923','211924','211925','211926','211927','211928','211929','211930','211931','211932','211933','211934','211935','211936','211937','211938','211939','211940','211941','211942','211943','211944','211945','211946','211947','211948','211949','211950','211951','211952','211953','211954','211955','211956','211957','211958','238644','238646','240085','240276','243895','244189','244190','244191','244424','244425','244426','244427','244428','250165','265186','265691','266081','266144','266556','268149','268150','269125','269126','269127','269128','269129','269130','269131','269132','269133','269134','269135','269136','269137','269138','269139','269140','269141','269142','269143','269144','275127','277376','278715','282089','285819','292348','293469','297324','297934','141707','142033','142046','142047','142048','142049','142857','143536','148669','150462','151238','151426','153060','153882','153883','153884','154424','155287','155452','155823','155824','158700','159242','159644','160592','161751','161753','161754','161755','163016','163801','164103','164642','168124','169315','208173','215627','215628','215629','215631','215632','215633','215754','215755','215756','215757','215758','215777','238059','238142','238143','238144','238185','238502','239251','239252','240116','240139','240140','240450','241027','242104','242105','242175','242282','242498','243079','244640','244655','244656','245472','249026','249027','249198','249199','249200','249201','249202','249218','250656','251649','255782','256918','266080','266411','269397','269625','278123','278124','284551','284552','284553','284554','285201','285202','285203','285204','302','150281','150665','151293','151294','151735','158232','159011','159890','165965','166144','211011','212850','212851','212852','212853','212854','212855','212856','212857','212858','212859','212860','212861','212862','212863','212864','212865','212866','212867','212868','212869','212870','212871','212872','212873','212874','212875','212876','212877','212878','212879','212880','212881','212882','212883','212884','212885','212886','212887','212888','212889','212890','212891','212892','212893','212894','212895','212896','212897','212898','212899','212900','212901','212902','212903','212904','212905','212906','212907','212908','212909','212910','215714','215715','215716','215717','215718','215719','238878','240101','240102','240134','240191','240192','240919','240920','240921','241023','245997','245998','246482','247204','249300','250046','250736','251601','251906','256021','256942','256943','262403','265749','278008','279333','280349','283334','283335','286879','288337','289415','291863','295277','299377','141674','141869','142155','142986','149907','150915','157253','157254','157255','157256','157257','160020','165237','165250','169106','169320','215638','238739','241451','267250','288538','167424','244925','244929','244930','244931','244932','244933','245996','246077','246723','248047','276252','279660','279661','283504','286024','288213','300275','301800','73','148','191','193','248','250','251','254','255','256','257','259','261','298','305','313','322','141850','141852','141854','146564','157022','158070','158608','161750','169137','169254','169345','169349','215586','215594','216076','240330','240620','240621','267824','280927','164475','166532','168315','247576','250051','261717','261718','267692','274085','279465','281699','148016','148018','148019','157807','202660','238271','238272','239460','239461','239462','239463','239464','239465','242283','242437','242438','242439','242440','245305','266979','267327','267328','286427','141454','141455','142169','142170','142748','142832','142833','142834','142835','142859','143720','144127','144128','144129','144130','144132','144133','144134','144135','144136','144138','144139','144140','144141','144142','144143','144144','144145','144231','144232','144241','144242','144243','144245','144251','144955','148171','150712','151012','151092','151254','151255','151821','151822','151823','151824','152546','153750','153811','153938','154161','154328','154929','154981','155000','156996','156997','156998','156999','157000','157001','157002','157003','157004','157005','157006','157007','158090','158581','158789','160114','162156','164371','169298','169324','169770','169771','170460','170587','170703','170704','170705','170706','170707','170708','170709','170710','170771','170772','212290','212291','212292','212293','212294','212295','212296','212297','212298','212299','212300','212301','212302','212303','212304','212305','212306','212307','212308','212309','212310','212311','212312','212313','212314','212315','212316','212317','212318','212319','212320','212321','212322','212323','212324','212325','212326','212327','212328','212329','212330','212331','212332','212333','212334','212335','212336','212337','212338','212339','212340','212341','212342','212343','212344','212345','212346','212347','212348','212349','212350','212351','212352','212353','212354','212355','212356','212357','212358','212359','212360','212361','212362','212363','212364','212365','212366','212367','212368','212369','212370','212371','212372','212373','212374','212375','212376','212377','212378','212379','212380','212381','212382','212383','212384','212385','212386','212387','212388','212389','212390','212391','212392','212393','212394','212395','212396','212397','212398','212399','212400','212401','212402','212403','212404','212405','212406','212407','212408','212409','212410','212411','212412','212413','212414','212415','215238','215656','215748','215971','215972','215973','215974','215975','215976','232677','232791','238020','238509','238519','238648','238766','238767','238768','240086','240227','240228','241316','241317','241588','241873','243731','245842','250883','254466','254467','254468','254469','269026','294813','143014','143206','143207','143208','143209','143213','143215','143218','151089','153895','153896','154910','157658','158427','158428','158429','158430','158431','158432','158433','158434','158435','158436','158437','158472','158475','158487','158488','158489','159065','159391','159472','160128','160129','160130','160131','160508','160610','160611','160612','160613','160672','160673','160674','160791','161078','161174','161175','161176','161177','161178','161179','161609','162561','163534','163577','164476','164477','164676','164677','165293','165295','165296','166407','166783','167490','168020','168021','168022','168023','168024','170102','170104','170105','170106','170107','170108','170109','170110','170111','170112','201283','215526','232753','238154','238203','238275','238316','238477','238601','238602','238821','238948','239184','239491','239523','239644','239859','240275','240284','240315','240316','240317','240318','240611','240612','240973','240974','240975','240976','241026','241028','241029','241577','241773','241824','241825','242208','242460','242485','242626','242627','242648','242649','242863','242864','242865','242866','243037','243399','245164','245166','245271','245272','245501','247225','247226','250143','255402','255431','255524','255525','261720','262405','263615','267637','276068','281432','282944','283135','283796','284502','284646','284647','284648','284938','284939','284940','284942','284944','284945','300516','300518','159777','241677','141341','141464','141465','141515','141584','141585','141586','141587','141704','141898','141899','141900','141901','141902','141903','141904','141905','141906','141984','142143','142144','142691','142697','142754','142766','142811','142860','142908','142909','142910','143042','143044','143048','143411','143416','143782','143783','144221','144246','144247','144248','144249','144250','144940','144957','144958','144960','144962','144963','144964','145178','145179','145180','145268','145270','146524','146529','146533','146538','146540','146563','146728','147216','148405','148741','149619','150617','150702','150820','150822','150838','150839','150840','150913','150914','150917','150918','151009','151010','151252','151408','151578','151869','151978','151989','153381','153382','153452','153539','153816','153939','153940','154146','154568','154725','154752','154753','154754','154755','154756','154757','154758','154908','154999','155116','155291','155292','155293','155294','155301','155304','155305','155343','155488','155489','155558','155632','155633','155665','157023','157024','157025','157026','157027','157028','157029','157030','157031','157032','157033','157034','157035','157036','157037','157038','157039','157040','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157053','157054','157055','157056','157057','157058','157059','157060','157061','157062','157063','157064','157065','157066','157067','157068','157069','157070','157071','157072','157073','157074','157075','157076','157077','157078','157079','157080','157081','157082','157083','157084','157085','157086','157087','157088','157089','157090','157091','157092','157093','157094','157095','157096','157097','157098','157099','157100','157101','157102','157103','157104','157105','157106','157107','157108','157109','157110','157111','157112','157113','157114','157115','157571','157572','157742','157743','157744','157745','157769','157770','157771','157772','157773','157774','157775','157776','158006','158008','158071','158086','158087','158088','158169','158208','158666','158667','158668','158701','158717','158719','158720','158788','158878','158879','158886','158949','159066','159246','159338','159477','159512','159513','159514','159545','159886','159949','159950','159951','159952','160247','160248','160249','160265','160346','160415','161122','161184','161778','161779','161780','161781','162996','162997','169095','169138','169171','169176','169210','169270','169271','169295','169296','169331','169332','169336','169772','169977','169982','169983','169984','169985','170153','170296','170645','185926','185927','185928','201255','202570','208777','208778','208779','208780','208781','208782','208783','208784','208785','208786','208787','208788','208789','208790','208791','208792','208793','208794','208795','208796','208797','208798','208799','208800','208801','208802','208803','208804','208805','208806','208807','208808','208809','208810','208811','208812','208813','208814','208815','208816','208817','208818','208819','208820','208821','208822','208823','208824','208825','208826','208827','208828','208829','208830','208831','208832','208833','208834','208835','208836','208837','208838','208839','208840','208841','208842','208843','208844','208845','208846','208847','208848','208849','208850','208851','208852','208853','208854','208855','208856','208857','208858','208859','208860','208861','208862','208863','208864','208865','208866','208867','208868','208869','208870','208871','208872','208873','208874','208875','208876','208877','208878','208879','208880','208881','208882','208883','208884','208885','208886','208887','208888','208889','208890','208891','208892','208893','208894','208895','208896','208897','215239','215371','215372','215373','215408','215417','215557','215830','215831','215885','238026','238027','238266','238633','238671','238681','238770','238771','238772','238773','238774','238775','238776','238777','238778','238779','238780','238781','238782','238783','238981','239223','239224','240916','241118','241981','241982','242383','242384','242867','277939','279757','299663','141426','141427','141428','141429','141430','141431','141432','141433','141434','141435','141436','141437','141438','141439','141440','141602','141728','142044','142157','142171','142195','142196','142197','142220','142998','142999','143000','143001','143002','143003','143004','143005','143006','143007','143008','143009','143010','143011','143012','143013','143016','143017','143018','143019','143020','143021','143022','143023','143024','143025','143026','143027','143028','143029','143030','143031','143032','143033','143034','143035','143036','143037','143038','143039','143040','143041','143093','143094','143100','143102','143103','143104','143105','143106','143107','143108','143109','143110','143111','143112','143113','143114','143115','143116','143117','143118','143119','143120','143121','143122','143123','143165','144146','144147','144167','144168','144169','144170','144233','144234','144235','144236','144237','144238','144239','144240','144244','144253','144254','144255','144256','144956','146497','146532','146590','146861','146862','146863','146864','146865','146866','146867','147002','147014','147015','148173','148174','148175','148176','148177','148178','148179','148180','148181','148182','148183','148184','148185','148186','148372','148373','149471','150693','150694','150695','150696','153650','154738','154816','154998','155040','155041','155042','155043','155130','155131','155132','157116','157117','157118','157119','157120','157163','157764','157907','157947','157948','157949','158289','158317','158318','158324','158325','158326','158329','158330','158331','158332','158333','158490','159278','159283','159284','159285','159286','159287','159288','159289','159290','159291','159292','159293','159294','159295','159778','159902','159903','159904','159905','160101','160102','160104','160113','160293','161576','161577','161578','161579','161580','161581','161582','161583','161584','161585','161586','161587','162265','163205','163206','163207','163208','163833','164352','165431','165432','165433','165434','165435','165436','165437','165622','166085','167141','167240','167342','167343','168169','169122','169123','169124','169125','169126','169127','169128','169129','169130','169131','169132','169133','169175','169177','169305','169325','169341','169343','169344','169779','169975','169976','170016','170017','170018','170053','170086','170711','170769','170773','201135','201136','201258','202729','206108','207570','208898','208899','208900','208901','208902','208903','208904','208905','208906','208907','208908','208909','208910','208911','208912','208913','208914','208915','208916','208917','208918','208919','208920','208921','208922','208923','208924','208925','208926','208927','208928','208929','208930','208931','208932','208933','208934','208935','208936','208937','208938','208939','208940','208941','208942','208943','208944','208945','208946','208947','208948','208949','208950','208951','208952','208953','208954','208955','208956','208957','208958','208959','208960','208961','208962','208963','208964','208965','208966','208967','208968','208969','208970','208971','208972','208973','208974','208975','208976','208977','208978','208979','208980','208981','208982','208983','208984','208985','208986','208987','208988','208989','208990','208991','208992','208993','208994','208995','208996','208997','208998','208999','209000','209001','209002','209003','209004','209005','209006','209007','209008','209009','209010','209011','209012','209013','209014','209015','209016','209017','209018','209019','209020','209021','209022','209023','209024','209025','209026','209027','209028','209029','209030','209031','209032','209033','209034','209035','209036','209037','209038','209039','209040','209041','209042','209043','209044','209045','209046','209047','209048','209049','209050','209051','209052','209053','209054','209055','209056','209057','209058','209059','209060','209061','209062','209063','209064','209065','209066','209067','209068','209069','209070','209071','209072','209073','209074','209075','209076','209077','209078','209079','209080','209081','209082','209083','209084','209085','209086','209087','209088','209089','209090','209091','209092','209093','209094','209095','209096','209097','209098','209099','209100','209101','209102','209103','209104','215781','216041','216042','219728','238321','238387','238440','238441','238514','238515','238516','238517','238518','238523','238578','238616','238617','238631','238632','238634','238635','238680','238784','238785','238786','238787','238788','238789','238790','238791','238792','238793','238794','238795','238796','238797','238798','238799','238800','238801','238835','238896','238897','238898','238899','238900','238901','238902','238903','238904','238905','238906','238907','238908','238909','238910','238911','238912','238913','238914','238915','238916','238917','238918','238919','238920','238921','238922','238923','238924','238925','238926','238977','239044','239045','239046','239047','239048','239049','239050','239051','239052','239053','239054','239055','239056','239057','239058','239059','239060','239061','239062','239063','239064','239065','239066','239067','239068','239069','239070','239071','239072','239073','239074','239075','239076','239077','239079','239080','239081','239082','239083','239084','239086','239087','239088','239089','239090','239091','239092','239093','239094','239095','239214','239232','239323','239327','239329','239516','239636','239689','239691','239692','239876','239916','239917','240135','240179','240336','240432','240495','240755','241018','241019','241475','241599','241624','241626','241891','241917','242154','242207','242210','242597','242791','242792','242909','243398','243741','243828','244379','244620','244621','244622','244858','245083','245161','245162','245163','245277','245304','245500','247329','247330','247477','247729','248092','248419','248837','249029','249205','250002','250052','250329','250742','250743','253492','254473','254474','254475','255948','256800','262406','263718','264770','264911','265388','265389','265739','266246','266247','266695','267491','267543','267544','267545','267546','267547','267549','267550','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563','267564','268007','269368','273468','273511','274282','274821','274822','275599','276096','276403','276601','277244','277245','277246','277247','278184','278764','278765','281694','285048','285696','286285','288448','288449','298417','298418','298419','298420','298421','298422','298423','298424','298425','298426','298427','298428','298429','298430','298431','298432','298433','141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142198','142199','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143086','143087','143088','143089','143090','143091','143092','143570','144164','145119','145120','145121','145122','145123','145124','145125','145126','145127','145128','145129','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146513','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148742','148990','150422','150423','150424','150593','151099','151100','151101','151102','151103','151104','151105','151106','151110','151632','151873','151874','152508','153548','154505','154506','154507','154508','154509','154644','157121','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157133','157134','157135','157136','157137','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158664','158674','158715','158988','158989','159161','159162','159358','159359','159360','159398','159581','159585','159633','159634','159635','159636','159867','160094','160133','160261','160262','160263','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161021','161022','161023','161024','161025','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162186','162187','162188','162189','162277','162281','162461','162634','162733','162744','162855','162887','162892','162951','163200','163201','163202','163203','163204','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169346','169733','201239','201240','202857','202858','202859','215203','215469','215470','215471','215472','215473','215474','215475','215476','215759','216086','219751','232623','238139','238186','238412','238581','238582','238927','238928','238929','238930','238931','238932','239870','239966','240073','240141','240224','241008','242056','242075','242076','242077','242078','242079','242080','242081','242082','242083','242084','242085','242086','242087','242088','242089','242157','242223','242224','242225','242226','242227','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245074','245582','246276','246277','246278','246741','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118','141453','141605','141705','141822','141823','141824','141825','142200','143045','143046','143068','143070','143071','143072','143203','143204','146489','146490','146492','146572','146573','146574','146584','147078','148414','148572','148573','148574','148575','148576','148577','148578','150674','151473','151474','153547','153775','153920','154239','154278','154560','154569','155022','155085','155649','156832','157167','157168','157169','157170','157171','157172','157173','157174','157175','157176','157177','157178','157971','157972','158084','158085','158091','158305','158334','158335','158669','158671','158672','158880','158881','158882','158883','158884','158885','159249','159458','159487','159502','159515','159801','159953','159954','159955','159956','159957','159958','160250','160251','160343','160397','160416','160417','160418','160419','160677','161185','161186','161782','161783','162139','162817','162818','162998','162999','163000','163001','164213','165361','169188','169189','169208','169209','169321','169347','169780','170008','170100','170317','170318','170399','170400','170401','185925','202784','211012','215277','215427','215538','215891','232411','232474','232584','232585','232639','238080','238081','238082','238083','238467','238669','238802','238879','238880','239129','239130','239163','239195','239227','239228','239300','239328','239496','239711','240083','240222','240229','240885','241015','241335','241336','241342','241510','241511','241837','241838','242010','242385','242462','242861','242946','243142','243283','243558','243687','243707','243902','245101','245279','246171','246378','246379','247154','247212','247250','249330','249431','249463','249464','249465','249466','249467','249907','250016','250017','250018','250019','250884','250885','251628','251629','253579','253580','253581','253582','253583','266079','301924','149475','158855','160637','160671','167847','167848','209105','209106','209107','209108','209109','209110','209111','209112','209113','209114','209115','209116','209117','209118','209119','209120','209121','209122','209123','209124','209125','209126','209127','209128','209129','209130','209131','209132','209133','209134','209135','209136','209137','209138','209139','209140','209141','209142','209143','209144','209145','209146','209147','209148','209149','209150','209151','209152','209153','209154','209155','209156','209157','209158','209159','209160','209161','209162','209163','209164','209165','209166','209167','209168','209169','209170','209171','209172','209173','209174','209175','209176','209177','209178','209179','209180','209181','209182','209183','209184','209185','209186','209187','209188','209189','209190','209191','209192','209193','209194','209195','209196','209197','209198','209199','209200','209201','209202','209203','209204','209205','209206','209207','209208','209209','209210','209211','209212','209213','209214','240481','240482','240515','240735','27','143095','143096','143097','143098','143099','148139','154737','155074','155075','155101','155102','155103','157179','157180','157181','157182','157183','157184','157185','157186','157187','157188','157189','157190','157191','157192','157193','157579','159971','159972','161784','161785','161786','163730','163731','163732','163733','163854','163870','163871','163872','163873','163874','163875','164323','164324','164325','164326','164327','164328','164329','164330','164331','164332','164333','164334','164335','164336','164337','164338','164339','164340','165049','165050','165051','165052','165215','165216','165217','165219','165220','165221','165222','165223','165224','165225','165226','167031','167032','168308','238521','238522','238524','238525','238526','238536','238537','238803','244698','247374','248335','252068','253336','262409','262575','264693','265750','293430','148150','148151','155015','155016','155017','156833','156834','156835','156836','156837','156838','156839','156840','156841','156842','156843','156844','156845','156846','157232','157233','157234','157235','157573','157574','157575','157576','157577','157578','157757','157842','159172','159173','159174','159175','238979','149479','149480','149481','149482','153427','158058','158059','158060','158061','158062','166082','166083','166084','209216','209217','209218','209219','209220','209221','209222','209223','209224','209225','209226','209227','209228','209229','209230','209231','209232','209233','209234','209235','209236','209237','209238','209239','209240','209241','209242','209243','209244','209245','209246','209247','209248','209249','209250','209251','209252','209253','209254','209255','209256','209257','209258','209259','209260','209261','209262','209263','209264','209265','209266','209267','209268','209269','209270','209271','209272','209273','209274','209275','209276','209277','209278','209279','209280','209281','209282','209283','209284','209285','209286','209287','209288','209289','209290','209291','209292','209293','209294','209295','209296','209297','209298','209299','209300','209301','209302','209303','209304','209305','209306','209307','209308','209309','209310','209311','209312','209313','209314','209315','209316','209317','209318','209319','209320','209321','209322','209323','209324','209325','209326','209327','209328','209329','209330','209331','209332','209333','209334','209335','209336','209337','209338','209339','209340','209341','209342','209343','209344','209345','209346','209347','209348','209349','209350','209351','209352','209353','209354','209355','209356','209357','209358','209359','209360','209361','209362','209363','209364','209365','209366','209367','209368','209369','209370','209371','241628','264844','265050','266002','299291','299729','141926','142708','154637','154803','154804','155077','155078','155079','155373','155374','155375','155376','159914','169788','202791','215927','215928','215929','232739','238157','238513','240887','241756','242445','243465','247778','249170','249171','275760','279230','282943','284839','154809','154810','154811','154812','154813','154814','154815','157249','157250','157251','157252','238416','247218','247219','247220','247221','247222','301981','141657','141658','141659','144137','144252','150442','150443','150943','153797','154259','154680','158089','158718','163375','163376','165007','165008','165009','165010','165357','165358','165359','165360','168270','169190','213242','213243','213244','213245','213246','213247','213248','213249','213250','213251','213252','213253','213254','213255','213256','213257','213258','213259','213260','213261','213262','213263','213264','213265','213266','213267','213268','213269','213270','213271','213272','213273','213274','213275','213276','213277','215214','215215','232782','232783','232784','232785','232786','238100','238101','238102','238248','238295','238296','238307','238308','238309','238310','238311','238312','238313','239007','239008','239009','239010','239011','239012','239445','239446','239447','239448','239449','239450','239519','239520','239522','239840','241311','241312','241313','241314','241327','241328','241463','243730','243732','245926','248655','250022','250023','250024','250025','250026','250259','251178','251626','251627','251630','251970','251971','279810','143015','147071','151310','157659','158471','158706','159819','160614','160675','160676','162562','163535','164478','167194','167489','215505','215725','232750','232754','232755','238046','238206','238317','238413','238478','238949','239185','239524','239645','239654','240648','241772','242650','243521','245273','245503','250144','261774','267693','281481','142018','146493','146933','147738','147878','147879','151308','151309','153898','154258','154417','158705','159760','159761','159762','159798','160734','202770','215723','215724','232640','232748','232749','232751','232752','238058','238204','238205','238315','238540','238544','238945','238946','238947','240297','240298','240299','240609','240610','243036','243400','243401','245497','245498','245502','250053','266239','141425','141786','141851','141853','141936','142140','143279','144959','144961','144965','144966','145116','145117','145118','146204','146507','146508','146579','146858','146943','146997','147752','147881','147888','148708','149630','150542','150555','150556','150557','150558','150589','150698','150699','150700','150701','151478','153392','153401','153779','153780','153781','154325','154500','154528','154549','155018','155019','155021','155285','155317','155492','155555','155647','155862','155863','157236','157237','157238','157239','157240','157241','157242','157243','157244','157245','157246','157247','157248','157582','158003','158079','158080','158081','158107','158108','158168','158470','158523','158524','158527','158547','158548','158549','158574','158607','158756','158961','159056','159057','159176','159554','160067','160509','161393','161394','162368','162498','162927','162928','163074','163075','164164','164248','164781','164977','165531','165623','165659','165700','165800','165999','166201','166236','167053','167329','167413','167414','167797','168388','169121','169144','169307','169330','170770','201254','202832','215251','215252','215454','215709','215862','215998','215999','216040','232500','232539','238805','238836','238974','238975','238976','238978','239144','239515','239960','240103','240106','240351','240355','240402','240471','240576','240659','240780','240781','241627','241629','241863','242116','242117','242118','242375','242536','242537','242862','245117','245118','245303','245455','245499','245539','245624','246375','246376','246377','246922','247214','247727','247728','247939','247976','248696','249646','251466','254372','254373','254450','254628','254701','255247','255248','255249','255250','255251','255252','255253','255254','255255','255256','255257','255258','255259','255260','255261','255262','255263','255264','255265','255266','255267','255268','255269','255270','255271','255272','255273','255274','255275','255276','261714','261715','261716','261719','261721','262408','262410','264375','264376','264432','265172','265324','267490','267677','267678','267922','273497','273565','273566','273567','274608','274609','275032','275187','275956','277472','277510','279466','284310','294999','300517') 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 ('141341','141426','141427','141428','141429','141430','141431','141432','141433','141434','141435','141436','141437','141438','141439','141440','141464','141465','141515','141584','141585','141586','141587','141656','141657','141658','141659','141669','141674','141704','141706','141707','141727','141728','141732','141735','141850','141852','141854','141869','141898','141899','141900','141901','141902','141904','141905','141906','141926','141936','141984','142018','142033','142044','142046','142047','142048','142049','142109','142110','142138','142139','142140','142143','142144','142155','142157','142171','142195','142196','142197','142220','142641','142642','142643','142644','142645','142691','142692','142693','142694','142695','142697','142701','142708','142754','142755','142766','142811','142857','142860','142866','142867','142868','142869','142870','142871','142872','142873','142874','142908','142909','142910','142986','142998','143000','143001','143002','143003','143004','143005','143006','143007','143008','143009','143010','143011','143012','143013','143014','143015','143016','143017','143018','143019','143020','143021','143022','143024','143025','143026','143027','143028','143029','143030','143031','143032','143033','143034','143035','143036','143038','143039','143040','143041','143042','143044','143048','143085','143089','143090','143091','143094','143100','143102','143103','143104','143105','143106','143107','143108','143109','143110','143111','143112','143113','143114','143115','143116','143117','143118','143119','143120','143121','143122','143123','143165','143203','143204','143206','143207','143209','143213','143215','143218','143279','143411','143416','143536','143580','143782','143783','144133','144137','144146','144147','144167','144168','144169','144170','144221','144233','144234','144235','144236','144237','144239','144240','144244','144246','144247','144248','144249','144250','144252','144940','144956','144957','144958','144960','144962','144963','144964','145116','145119','145121','145122','145123','145178','145179','145180','145268','145270','146204','146491','146493','146494','146495','146496','146497','146499','146500','146501','146502','146503','146504','146505','146511','146522','146524','146525','146527','146529','146530','146533','146538','146540','146563','146564','146569','146579','146590','146728','146861','146862','146863','146864','146865','146866','146867','146933','146997','147002','147044','147071','147216','147708','147738','147752','147878','147879','147884','147888','148016','148018','148019','148150','148151','148172','148174','148175','148176','148177','148178','148179','148180','148181','148182','148183','148184','148185','148186','148363','148372','148373','148395','148400','148401','148402','148405','148414','148669','148704','148708','148741','148990','149475','149479','149480','149481','149482','149619','149907','150281','150423','150424','150442','150443','150462','150542','150555','150556','150557','150558','150589','150593','150617','150665','150696','150698','150699','150700','150701','150702','150820','150822','150838','150839','150840','150913','150914','150915','150917','150918','150943','151009','151010','151089','151099','151100','151101','151102','151103','151238','151252','151293','151294','151308','151309','151310','151408','151426','151478','151578','151735','151869','151874','151978','151989','152508','153060','153381','153382','153392','153401','153427','153452','153539','153548','153650','153750','153779','153780','153781','153797','153816','153881','153882','153883','153884','153895','153896','153898','153939','153940','154146','154161','154258','154259','154325','154417','154424','154500','154509','154528','154549','154568','154637','154644','154680','154725','154737','154738','154752','154753','154754','154755','154756','154757','154758','154803','154804','154809','154810','154811','154812','154813','154814','154815','154816','154908','154910','154999','155015','155016','155017','155018','155019','155021','155040','155041','155042','155043','155077','155078','155079','155116','155130','155131','155132','155285','155287','155291','155292','155293','155294','155301','155304','155305','155343','155373','155374','155375','155376','155452','155488','155489','155558','155632','155633','155665','155823','155824','156833','156834','156835','156836','156837','156838','156839','156840','156841','156842','156843','156844','156845','156846','157022','157023','157024','157025','157026','157027','157028','157029','157030','157031','157032','157033','157034','157035','157036','157037','157038','157039','157040','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157053','157054','157055','157056','157057','157058','157059','157060','157061','157062','157063','157064','157065','157066','157067','157068','157069','157070','157071','157072','157073','157074','157075','157076','157077','157078','157079','157080','157081','157082','157083','157084','157085','157086','157087','157088','157089','157090','157091','157092','157093','157094','157095','157096','157097','157098','157099','157100','157101','157102','157103','157104','157105','157106','157107','157108','157109','157110','157111','157112','157113','157114','157115','157116','157117','157118','157119','157120','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157192','157232','157233','157234','157235','157238','157239','157245','157249','157250','157251','157252','157253','157254','157255','157256','157257','157571','157572','157573','157574','157575','157576','157577','157578','157580','157582','157636','157658','157659','157742','157743','157744','157745','157757','157769','157770','157771','157772','157773','157774','157775','157776','157807','157842','157846','157907','157945','157948','157949','158003','158006','158008','158035','158036','158037','158038','158058','158059','158060','158061','158062','158067','158068','158070','158071','158079','158081','158086','158087','158088','158089','158107','158108','158168','158169','158208','158232','158272','158293','158317','158318','158324','158325','158326','158329','158330','158331','158332','158333','158356','158387','158427','158428','158429','158430','158431','158432','158433','158434','158435','158436','158437','158470','158471','158472','158475','158487','158488','158489','158490','158513','158514','158523','158524','158527','158547','158548','158549','158574','158580','158602','158607','158608','158666','158667','158668','158700','158701','158705','158706','158715','158717','158718','158719','158720','158756','158788','158855','158877','158878','158879','158886','158949','158961','159011','159056','159057','159065','159066','159162','159172','159173','159174','159175','159176','159242','159246','159278','159283','159284','159285','159286','159287','159288','159289','159290','159291','159292','159293','159294','159295','159338','159339','159358','159359','159360','159391','159472','159477','159512','159513','159514','159545','159581','159585','159644','159760','159761','159762','159777','159778','159798','159819','159867','159886','159890','159902','159903','159904','159905','159914','159949','159950','159951','159952','159956','160020','160067','160101','160102','160104','160113','160128','160129','160130','160131','160247','160248','160249','160265','160293','160346','160373','160374','160415','160487','160508','160509','160592','160610','160611','160612','160613','160614','160637','160671','160672','160673','160674','160675','160676','160717','160734','160746','160774','160791','160922','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161078','161081','161082','161083','161122','161174','161175','161176','161177','161178','161179','161184','161212','161213','161284','161393','161394','161439','161576','161577','161578','161579','161580','161581','161582','161583','161584','161585','161586','161587','161609','161688','161749','161750','161751','161753','161754','161755','161778','161779','161780','161781','161786','161911','162008','162152','162167','162168','162265','162368','162461','162498','162561','162562','162634','162733','162744','162855','162887','162927','162928','162951','162996','162997','163016','163074','163075','163200','163202','163203','163205','163206','163207','163208','163211','163375','163376','163534','163535','163577','163706','163801','163833','163854','163870','163871','163872','163873','163874','163875','163885','164103','164164','164248','164320','164321','164323','164324','164325','164326','164327','164328','164329','164330','164331','164332','164333','164334','164335','164336','164337','164338','164339','164340','164351','164352','164475','164476','164477','164478','164642','164676','164677','164781','164977','165007','165008','165009','165010','165049','165051','165052','165212','165213','165214','165215','165216','165217','165219','165220','165221','165222','165223','165224','165225','165226','165237','165250','165293','165295','165296','165357','165358','165359','165360','165429','165430','165433','165434','165435','165436','165437','165476','165531','165554','165622','165623','165659','165700','165800','165965','165985','165986','165987','165988','165998','165999','166082','166083','166084','166085','166144','166201','166236','166407','166435','166532','166565','166783','167031','167032','167053','167115','167141','167194','167240','167307','167329','167342','167343','167413','167414','167424','167489','167490','167706','167797','167847','167967','167968','167995','168020','168021','168022','168023','168024','168124','168153','168169','168270','168308','168315','168388','168405','169095','169106','169122','169123','169124','169125','169126','169127','169128','169129','169130','169131','169132','169133','169137','169138','169143','169144','169171','169176','169177','169190','169210','169211','169254','169270','169271','169295','169296','169305','169307','169315','169320','169325','169330','169331','169332','169336','169341','169343','169344','169345','169349','169733','169772','169779','169788','169975','169976','169977','169982','169983','169984','169985','170016','170017','170018','170053','170086','170102','170104','170105','170106','170107','170108','170109','170110','170111','170112','170153','170296','170393','170394','170645','170711','170767','170768','170769','170770','170771','170772','170773','185926','185927','185928','201239','201240','201254','201255','201283','202570','202577','202660','202729','202770','202791','202832','202857','202858','202859','206108','207570','208173','208777','208778','208779','208780','208781','208782','208783','208784','208785','208786','208787','208788','208789','208790','208791','208792','208793','208794','208795','208796','208797','208798','208799','208800','208801','208802','208803','208804','208805','208806','208807','208808','208809','208810','208811','208812','208813','208814','208815','208816','208817','208818','208819','208820','208821','208822','208823','208824','208825','208826','208827','208828','208829','208830','208831','208832','208833','208834','208835','208836','208837','208838','208839','208840','208841','208842','208843','208844','208845','208846','208847','208848','208849','208850','208851','208852','208853','208854','208855','208856','208857','208858','208859','208860','208861','208862','208863','208864','208865','208866','208867','208868','208869','208870','208871','208872','208873','208874','208875','208876','208877','208878','208879','208880','208881','208882','208883','208884','208885','208886','208887','208888','208889','208890','208891','208892','208893','208894','208895','208896','208897','209105','209106','209107','209108','209109','209110','209111','209112','209113','209114','209115','209116','209117','209118','209119','209120','209121','209122','209123','209124','209125','209126','209127','209128','209129','209130','209131','209132','209133','209134','209135','209136','209137','209138','209139','209140','209141','209142','209143','209144','209145','209146','209147','209148','209149','209150','209151','209152','209153','209154','209155','209156','209157','209158','209159','209160','209161','209162','209163','209164','209165','209166','209167','209168','209169','209170','209171','209172','209173','209174','209175','209176','209177','209178','209179','209180','209181','209182','209183','209184','209185','209186','209187','209188','209189','209190','209191','209192','209193','209194','209195','209196','209197','209198','209199','209200','209201','209202','209203','209204','209205','209206','209207','209208','209209','209210','209211','209212','209213','209214','209215','209216','209217','209218','209219','209220','209221','209222','209223','209224','209225','209226','209227','209228','209229','209230','209231','209232','209233','209234','209235','209236','209237','209238','209239','209240','209241','209242','209243','209244','209245','209246','209247','209248','209249','209250','209251','209252','209253','209254','209255','209256','209257','209258','209259','209260','209261','209262','209263','209264','209265','209266','209267','209268','209269','209270','209271','209272','209273','209274','209275','209276','209277','209278','209279','209280','209281','209282','209283','209284','209285','209286','209287','209288','209289','209290','209291','209292','209293','209294','209295','209296','209297','209298','209299','209300','209301','209302','209303','209304','209305','209306','209307','209308','209309','209310','209311','209312','209313','209314','209315','209316','209317','209318','209319','209320','209321','209322','209323','209324','209325','209326','209327','209328','209329','209330','209331','209332','209333','209334','209335','209336','209337','209338','209339','209340','209341','209342','209343','209344','209345','209346','209347','209348','209349','209350','209351','209352','209353','209354','209355','209356','209357','209358','209359','209360','209361','209362','209363','209364','209365','209366','209367','209368','209369','209370','209371','210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','211011','211877','211878','211879','211880','211881','211882','211883','211884','211885','211886','211887','211888','211889','211890','211891','211892','211893','211894','211895','211896','211897','211898','211899','211900','211901','211902','211903','211904','211905','211906','211907','211908','211909','211910','211911','211912','211913','211914','211915','211916','211917','211918','211919','211920','211921','211922','211923','211924','211925','211926','211927','211928','211929','211930','211931','211932','211933','211934','211935','211936','211937','211938','211939','211940','211941','211942','211943','211944','211945','211946','211947','211948','211949','211950','211951','211952','211953','211954','211955','211956','211957','211958','212850','212851','212852','212853','212854','212855','212856','212857','212858','212859','212860','212861','212862','212863','212864','212865','212866','212867','212868','212869','212870','212871','212872','212873','212874','212875','212876','212877','212878','212879','212880','212881','212882','212883','212884','212885','212886','212887','212888','212889','212890','212891','212892','212893','212894','212895','212896','212897','212898','212899','212900','212901','212902','212903','212904','212905','212906','212907','212908','212909','212910','213242','213243','213244','213245','213246','213247','213248','213249','213250','213251','213252','213253','213254','213255','213256','213257','213258','213259','213260','213261','213262','213263','213264','213265','213266','213267','213268','213269','213270','213271','213272','213273','213274','213275','213276','213277','215214','215215','215239','215251','215252','215287','215371','215372','215373','215408','215417','215454','215505','215526','215557','215586','215594','215627','215628','215629','215631','215632','215633','215638','215714','215715','215716','215717','215718','215719','215723','215724','215725','215754','215755','215756','215757','215758','215777','215781','215830','215831','215862','215885','215927','215928','215929','215998','215999','216040','216041','216042','216076','216086','216105','216106','219728','219751','232500','232539','232623','232640','232677','232739','232748','232749','232750','232751','232752','232753','232754','232755','232782','232783','232784','232785','232786','238026','238027','238046','238058','238059','238100','238101','238102','238139','238142','238143','238144','238154','238157','238185','238186','238203','238204','238205','238206','238248','238266','238271','238272','238275','238295','238296','238307','238308','238309','238310','238311','238312','238313','238315','238316','238317','238387','238412','238413','238416','238440','238441','238477','238478','238502','238513','238514','238515','238516','238517','238518','238540','238544','238578','238581','238582','238601','238602','238616','238617','238631','238632','238633','238644','238646','238671','238680','238681','238739','238770','238771','238772','238773','238774','238775','238776','238777','238778','238779','238780','238781','238782','238783','238784','238785','238786','238789','238793','238794','238795','238796','238797','238798','238799','238800','238801','238805','238821','238835','238836','238878','238906','238907','238909','238910','238911','238912','238913','238914','238924','238925','238945','238946','238947','238948','238949','238974','238975','238976','238977','238978','238979','238981','239007','239008','239009','239010','239011','239012','239044','239045','239046','239047','239048','239049','239050','239051','239052','239053','239054','239055','239056','239057','239058','239060','239061','239062','239063','239064','239065','239066','239067','239068','239069','239070','239071','239072','239073','239074','239075','239076','239077','239079','239080','239081','239082','239083','239084','239086','239087','239088','239089','239090','239091','239092','239093','239094','239095','239144','239184','239185','239214','239223','239224','239232','239251','239252','239323','239327','239445','239446','239447','239448','239449','239450','239460','239461','239462','239463','239464','239465','239491','239516','239519','239520','239522','239523','239524','239636','239644','239645','239654','239689','239691','239692','239840','239859','239870','239876','239916','239917','239960','239966','240085','240101','240102','240103','240116','240134','240139','240140','240141','240179','240191','240192','240205','240275','240276','240284','240297','240298','240299','240315','240316','240317','240318','240330','240336','240351','240355','240402','240432','240450','240481','240482','240495','240515','240532','240576','240609','240610','240611','240612','240620','240621','240648','240659','240735','240755','240780','240916','240919','240920','240921','240973','240974','240975','240976','241008','241018','241019','241023','241026','241027','241028','241029','241118','241311','241312','241313','241314','241327','241328','241451','241463','241475','241577','241599','241624','241626','241627','241628','241629','241677','241756','241772','241773','241824','241825','241863','241891','241917','241981','241982','242056','242104','242105','242116','242117','242118','242154','242175','242207','242208','242210','242282','242283','242375','242383','242384','242437','242438','242439','242440','242445','242447','242448','242460','242485','242498','242536','242537','242570','242574','242597','242626','242627','242633','242648','242649','242650','242791','242792','242863','242864','242865','242866','242867','242898','242909','243036','243037','243079','243082','243092','243126','243369','243398','243399','243400','243401','243415','243416','243465','243521','243522','243697','243730','243732','243741','243828','243895','244189','244190','244191','244379','244424','244425','244426','244427','244428','244640','244655','244656','244698','244925','244929','244930','244931','244932','244933','245117','245118','245161','245162','245163','245164','245166','245271','245272','245273','245277','245303','245304','245305','245472','245497','245498','245499','245500','245501','245502','245503','245539','245582','245624','245743','245926','245996','245997','245998','246077','246276','246277','246375','246377','246409','246482','246723','246818','246922','247204','247218','247219','247220','247221','247222','247225','247226','247329','247330','247374','247477','247576','247727','247728','247729','247778','247939','247976','248047','248092','248335','248419','248649','248655','248837','249026','249027','249029','249198','249199','249200','249201','249202','249204','249205','249218','249245','249300','249646','249922','250002','250022','250023','250024','250025','250026','250046','250051','250052','250053','250076','250077','250078','250143','250144','250165','250259','250345','250656','250736','250742','250743','250862','251038','251072','251178','251181','251182','251183','251241','251242','251243','251273','251466','251479','251480','251601','251626','251627','251630','251649','251708','251906','251970','251971','252068','252102','252192','252193','253336','253492','253707','254372','254373','254450','254466','254467','254468','254469','254473','254474','254475','254628','255252','255267','255273','255276','255391','255402','255431','255524','255525','255782','255948','255989','255990','256021','256583','256595','256800','256918','256942','256943','257136','261714','261715','261716','261717','261718','261719','261720','261721','261774','262403','262405','262406','262407','262408','262409','262410','262575','263615','263718','264375','264376','264432','264693','264730','264770','264844','264911','265050','265172','265186','265234','265324','265388','265389','265691','265739','265749','265750','265836','266002','266079','266080','266081','266144','266239','266246','266247','266411','266556','266695','266979','267250','267327','267328','267490','267491','267543','267544','267545','267546','267547','267549','267550','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563','267564','267637','267677','267678','267692','267693','267824','267921','267922','268007','268147','268148','268149','268150','268414','268658','269026','269125','269126','269127','269128','269129','269130','269131','269132','269133','269134','269135','269136','269137','269138','269139','269140','269141','269142','269143','269144','269368','269397','269625','273399','273468','273497','273511','273565','273566','273567','274085','274282','274608','274609','274821','274822','274823','274824','274922','274944','275032','275127','275187','275599','275760','275956','276068','276096','276252','276403','276601','277244','277245','277246','277247','277376','277472','277510','277939','278008','278123','278124','278164','278184','278623','278715','278764','278765','279333','279465','279466','279660','279661','279757','279810','280349','280664','280927','281031','281432','281481','281694','281699','282089','282757','282944','283135','283334','283335','283488','283504','283796','284310','284502','284551','284552','284553','284554','284646','284647','284648','284839','284938','284939','284940','284942','284944','284945','285048','285201','285202','285203','285204','285696','285819','286024','286162','286285','286427','286824','286825','286879','288213','288337','288448','288449','288538','289415','291863','292016','292234','292348','293430','293469','293896','293898','293900','293901','293902','293903','293905','294041','294338','294813','294999','295277','297324','297934','298413','298414','298415','298416','298417','298418','298419','298420','298421','298422','298423','298424','298425','298426','298427','298428','298429','298430','298431','298432','298433','298477','299291','299377','299663','299729','300275','300516','300517','300518','301800','301924','301981','302112','302113','302114','302115','302116','302117','302118') 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 ('20','152','153','154','156','246','247','249','289','157945','170767','170768','216105','216106','240205','242447','242448','242570','242574','245743','246409','246818','249245','249922','250345','251038','251273','251316','253707','262407','293896','293898','293900','293901','293902','293903','293905','210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136','167706','250862','251241','251242','251243','252192','252193','264730','265234','265836','273399','274922','274944','278164','278623','286824','286825','294041','294454','294455','294456','294457','294458','294459','294460','298477','143580','153881','158877','159339','211877','211878','211879','211880','211881','211882','211883','211884','211885','211886','211887','211888','211889','211890','211891','211892','211893','211894','211895','211896','211897','211898','211899','211900','211901','211902','211903','211904','211905','211906','211907','211908','211909','211910','211911','211912','211913','211914','211915','211916','211917','211918','211919','215287','240532','268147','268148','268658','281031','292016','294338','142755','147708','157636','158293','160373','160374','160746','160922','167995','170393','170394','202577','209215','211920','211921','211922','211923','211924','211925','211926','211927','211928','211929','211930','211931','211932','211933','211934','211935','211936','211937','211938','211939','211940','211941','211942','211943','211944','211945','211946','211947','211948','211949','211950','211951','211952','211953','211954','211955','211956','211957','211958','238644','238646','240085','240276','243895','244189','244190','244191','244424','244425','244426','244427','244428','250165','265186','265691','266081','266144','266556','268149','268150','269125','269126','269127','269128','269129','269130','269131','269132','269133','269134','269135','269136','269137','269138','269139','269140','269141','269142','269143','269144','275127','277376','278715','282089','285819','292348','293469','297324','297934','141707','142033','142046','142047','142048','142049','142857','143536','148669','150462','151238','151426','153060','153882','153883','153884','154424','155287','155452','155823','155824','158700','159242','159644','160592','161751','161753','161754','161755','163016','163801','164103','164642','168124','169315','208173','215627','215628','215629','215631','215632','215633','215754','215755','215756','215757','215758','215777','238059','238142','238143','238144','238185','238502','239251','239252','240116','240139','240140','240450','241027','242104','242105','242175','242282','242498','243079','244640','244655','244656','245472','249026','249027','249198','249199','249200','249201','249202','249218','250656','251649','255782','256918','266080','266411','269397','269625','278123','278124','284551','284552','284553','284554','285201','285202','285203','285204','302','150281','150665','151293','151294','151735','158232','159011','159890','165965','166144','211011','212850','212851','212852','212853','212854','212855','212856','212857','212858','212859','212860','212861','212862','212863','212864','212865','212866','212867','212868','212869','212870','212871','212872','212873','212874','212875','212876','212877','212878','212879','212880','212881','212882','212883','212884','212885','212886','212887','212888','212889','212890','212891','212892','212893','212894','212895','212896','212897','212898','212899','212900','212901','212902','212903','212904','212905','212906','212907','212908','212909','212910','215714','215715','215716','215717','215718','215719','238878','240101','240102','240134','240191','240192','240919','240920','240921','241023','245997','245998','246482','247204','249300','250046','250736','251601','251906','256021','256942','256943','262403','265749','278008','279333','280349','283334','283335','286879','288337','289415','291863','295277','299377','141674','141869','142155','142986','149907','150915','157253','157254','157255','157256','157257','160020','165237','165250','169106','169320','215638','238739','241451','267250','288538','167424','244925','244929','244930','244931','244932','244933','245996','246077','246723','248047','276252','279660','279661','283504','286024','288213','300275','301800','73','148','191','193','248','250','251','254','255','256','257','259','261','298','305','313','322','141850','141852','141854','146564','157022','158070','158608','161750','169137','169254','169345','169349','215586','215594','216076','240330','240620','240621','267824','280927','164475','166532','168315','247576','250051','261717','261718','267692','274085','279465','281699','148016','148018','148019','157807','202660','238271','238272','239460','239461','239462','239463','239464','239465','242283','242437','242438','242439','242440','245305','266979','267327','267328','286427','141454','141455','142169','142170','142748','142832','142833','142834','142835','142859','143720','144127','144128','144129','144130','144132','144133','144134','144135','144136','144138','144139','144140','144141','144142','144143','144144','144145','144231','144232','144241','144242','144243','144245','144251','144955','148171','150712','151012','151092','151254','151255','151821','151822','151823','151824','152546','153750','153811','153938','154161','154328','154929','154981','155000','156996','156997','156998','156999','157000','157001','157002','157003','157004','157005','157006','157007','158090','158581','158789','160114','162156','164371','169298','169324','169770','169771','170460','170587','170703','170704','170705','170706','170707','170708','170709','170710','170771','170772','212290','212291','212292','212293','212294','212295','212296','212297','212298','212299','212300','212301','212302','212303','212304','212305','212306','212307','212308','212309','212310','212311','212312','212313','212314','212315','212316','212317','212318','212319','212320','212321','212322','212323','212324','212325','212326','212327','212328','212329','212330','212331','212332','212333','212334','212335','212336','212337','212338','212339','212340','212341','212342','212343','212344','212345','212346','212347','212348','212349','212350','212351','212352','212353','212354','212355','212356','212357','212358','212359','212360','212361','212362','212363','212364','212365','212366','212367','212368','212369','212370','212371','212372','212373','212374','212375','212376','212377','212378','212379','212380','212381','212382','212383','212384','212385','212386','212387','212388','212389','212390','212391','212392','212393','212394','212395','212396','212397','212398','212399','212400','212401','212402','212403','212404','212405','212406','212407','212408','212409','212410','212411','212412','212413','212414','212415','215238','215656','215748','215971','215972','215973','215974','215975','215976','232677','232791','238020','238509','238519','238648','238766','238767','238768','240086','240227','240228','241316','241317','241588','241873','243731','245842','250883','254466','254467','254468','254469','269026','294813','143014','143206','143207','143208','143209','143213','143215','143218','151089','153895','153896','154910','157658','158427','158428','158429','158430','158431','158432','158433','158434','158435','158436','158437','158472','158475','158487','158488','158489','159065','159391','159472','160128','160129','160130','160131','160508','160610','160611','160612','160613','160672','160673','160674','160791','161078','161174','161175','161176','161177','161178','161179','161609','162561','163534','163577','164476','164477','164676','164677','165293','165295','165296','166407','166783','167490','168020','168021','168022','168023','168024','170102','170104','170105','170106','170107','170108','170109','170110','170111','170112','201283','215526','232753','238154','238203','238275','238316','238477','238601','238602','238821','238948','239184','239491','239523','239644','239859','240275','240284','240315','240316','240317','240318','240611','240612','240973','240974','240975','240976','241026','241028','241029','241577','241773','241824','241825','242208','242460','242485','242626','242627','242648','242649','242863','242864','242865','242866','243037','243399','245164','245166','245271','245272','245501','247225','247226','250143','255402','255431','255524','255525','261720','262405','263615','267637','276068','281432','282944','283135','283796','284502','284646','284647','284648','284938','284939','284940','284942','284944','284945','300516','300518','159777','241677','141341','141464','141465','141515','141584','141585','141586','141587','141704','141898','141899','141900','141901','141902','141903','141904','141905','141906','141984','142143','142144','142691','142697','142754','142766','142811','142860','142908','142909','142910','143042','143044','143048','143411','143416','143782','143783','144221','144246','144247','144248','144249','144250','144940','144957','144958','144960','144962','144963','144964','145178','145179','145180','145268','145270','146524','146529','146533','146538','146540','146563','146728','147216','148405','148741','149619','150617','150702','150820','150822','150838','150839','150840','150913','150914','150917','150918','151009','151010','151252','151408','151578','151869','151978','151989','153381','153382','153452','153539','153816','153939','153940','154146','154568','154725','154752','154753','154754','154755','154756','154757','154758','154908','154999','155116','155291','155292','155293','155294','155301','155304','155305','155343','155488','155489','155558','155632','155633','155665','157023','157024','157025','157026','157027','157028','157029','157030','157031','157032','157033','157034','157035','157036','157037','157038','157039','157040','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157053','157054','157055','157056','157057','157058','157059','157060','157061','157062','157063','157064','157065','157066','157067','157068','157069','157070','157071','157072','157073','157074','157075','157076','157077','157078','157079','157080','157081','157082','157083','157084','157085','157086','157087','157088','157089','157090','157091','157092','157093','157094','157095','157096','157097','157098','157099','157100','157101','157102','157103','157104','157105','157106','157107','157108','157109','157110','157111','157112','157113','157114','157115','157571','157572','157742','157743','157744','157745','157769','157770','157771','157772','157773','157774','157775','157776','158006','158008','158071','158086','158087','158088','158169','158208','158666','158667','158668','158701','158717','158719','158720','158788','158878','158879','158886','158949','159066','159246','159338','159477','159512','159513','159514','159545','159886','159949','159950','159951','159952','160247','160248','160249','160265','160346','160415','161122','161184','161778','161779','161780','161781','162996','162997','169095','169138','169171','169176','169210','169270','169271','169295','169296','169331','169332','169336','169772','169977','169982','169983','169984','169985','170153','170296','170645','185926','185927','185928','201255','202570','208777','208778','208779','208780','208781','208782','208783','208784','208785','208786','208787','208788','208789','208790','208791','208792','208793','208794','208795','208796','208797','208798','208799','208800','208801','208802','208803','208804','208805','208806','208807','208808','208809','208810','208811','208812','208813','208814','208815','208816','208817','208818','208819','208820','208821','208822','208823','208824','208825','208826','208827','208828','208829','208830','208831','208832','208833','208834','208835','208836','208837','208838','208839','208840','208841','208842','208843','208844','208845','208846','208847','208848','208849','208850','208851','208852','208853','208854','208855','208856','208857','208858','208859','208860','208861','208862','208863','208864','208865','208866','208867','208868','208869','208870','208871','208872','208873','208874','208875','208876','208877','208878','208879','208880','208881','208882','208883','208884','208885','208886','208887','208888','208889','208890','208891','208892','208893','208894','208895','208896','208897','215239','215371','215372','215373','215408','215417','215557','215830','215831','215885','238026','238027','238266','238633','238671','238681','238770','238771','238772','238773','238774','238775','238776','238777','238778','238779','238780','238781','238782','238783','238981','239223','239224','240916','241118','241981','241982','242383','242384','242867','277939','279757','299663','141426','141427','141428','141429','141430','141431','141432','141433','141434','141435','141436','141437','141438','141439','141440','141602','141728','142044','142157','142171','142195','142196','142197','142220','142998','142999','143000','143001','143002','143003','143004','143005','143006','143007','143008','143009','143010','143011','143012','143013','143016','143017','143018','143019','143020','143021','143022','143023','143024','143025','143026','143027','143028','143029','143030','143031','143032','143033','143034','143035','143036','143037','143038','143039','143040','143041','143093','143094','143100','143102','143103','143104','143105','143106','143107','143108','143109','143110','143111','143112','143113','143114','143115','143116','143117','143118','143119','143120','143121','143122','143123','143165','144146','144147','144167','144168','144169','144170','144233','144234','144235','144236','144237','144238','144239','144240','144244','144253','144254','144255','144256','144956','146497','146532','146590','146861','146862','146863','146864','146865','146866','146867','147002','147014','147015','148173','148174','148175','148176','148177','148178','148179','148180','148181','148182','148183','148184','148185','148186','148372','148373','149471','150693','150694','150695','150696','153650','154738','154816','154998','155040','155041','155042','155043','155130','155131','155132','157116','157117','157118','157119','157120','157163','157764','157907','157947','157948','157949','158289','158317','158318','158324','158325','158326','158329','158330','158331','158332','158333','158490','159278','159283','159284','159285','159286','159287','159288','159289','159290','159291','159292','159293','159294','159295','159778','159902','159903','159904','159905','160101','160102','160104','160113','160293','161576','161577','161578','161579','161580','161581','161582','161583','161584','161585','161586','161587','162265','163205','163206','163207','163208','163833','164352','165431','165432','165433','165434','165435','165436','165437','165622','166085','167141','167240','167342','167343','168169','169122','169123','169124','169125','169126','169127','169128','169129','169130','169131','169132','169133','169175','169177','169305','169325','169341','169343','169344','169779','169975','169976','170016','170017','170018','170053','170086','170711','170769','170773','201135','201136','201258','202729','206108','207570','208898','208899','208900','208901','208902','208903','208904','208905','208906','208907','208908','208909','208910','208911','208912','208913','208914','208915','208916','208917','208918','208919','208920','208921','208922','208923','208924','208925','208926','208927','208928','208929','208930','208931','208932','208933','208934','208935','208936','208937','208938','208939','208940','208941','208942','208943','208944','208945','208946','208947','208948','208949','208950','208951','208952','208953','208954','208955','208956','208957','208958','208959','208960','208961','208962','208963','208964','208965','208966','208967','208968','208969','208970','208971','208972','208973','208974','208975','208976','208977','208978','208979','208980','208981','208982','208983','208984','208985','208986','208987','208988','208989','208990','208991','208992','208993','208994','208995','208996','208997','208998','208999','209000','209001','209002','209003','209004','209005','209006','209007','209008','209009','209010','209011','209012','209013','209014','209015','209016','209017','209018','209019','209020','209021','209022','209023','209024','209025','209026','209027','209028','209029','209030','209031','209032','209033','209034','209035','209036','209037','209038','209039','209040','209041','209042','209043','209044','209045','209046','209047','209048','209049','209050','209051','209052','209053','209054','209055','209056','209057','209058','209059','209060','209061','209062','209063','209064','209065','209066','209067','209068','209069','209070','209071','209072','209073','209074','209075','209076','209077','209078','209079','209080','209081','209082','209083','209084','209085','209086','209087','209088','209089','209090','209091','209092','209093','209094','209095','209096','209097','209098','209099','209100','209101','209102','209103','209104','215781','216041','216042','219728','238321','238387','238440','238441','238514','238515','238516','238517','238518','238523','238578','238616','238617','238631','238632','238634','238635','238680','238784','238785','238786','238787','238788','238789','238790','238791','238792','238793','238794','238795','238796','238797','238798','238799','238800','238801','238835','238896','238897','238898','238899','238900','238901','238902','238903','238904','238905','238906','238907','238908','238909','238910','238911','238912','238913','238914','238915','238916','238917','238918','238919','238920','238921','238922','238923','238924','238925','238926','238977','239044','239045','239046','239047','239048','239049','239050','239051','239052','239053','239054','239055','239056','239057','239058','239059','239060','239061','239062','239063','239064','239065','239066','239067','239068','239069','239070','239071','239072','239073','239074','239075','239076','239077','239079','239080','239081','239082','239083','239084','239086','239087','239088','239089','239090','239091','239092','239093','239094','239095','239214','239232','239323','239327','239329','239516','239636','239689','239691','239692','239876','239916','239917','240135','240179','240336','240432','240495','240755','241018','241019','241475','241599','241624','241626','241891','241917','242154','242207','242210','242597','242791','242792','242909','243398','243741','243828','244379','244620','244621','244622','244858','245083','245161','245162','245163','245277','245304','245500','247329','247330','247477','247729','248092','248419','248837','249029','249205','250002','250052','250329','250742','250743','253492','254473','254474','254475','255948','256800','262406','263718','264770','264911','265388','265389','265739','266246','266247','266695','267491','267543','267544','267545','267546','267547','267549','267550','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563','267564','268007','269368','273468','273511','274282','274821','274822','275599','276096','276403','276601','277244','277245','277246','277247','278184','278764','278765','281694','285048','285696','286285','288448','288449','298417','298418','298419','298420','298421','298422','298423','298424','298425','298426','298427','298428','298429','298430','298431','298432','298433','141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142198','142199','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143086','143087','143088','143089','143090','143091','143092','143570','144164','145119','145120','145121','145122','145123','145124','145125','145126','145127','145128','145129','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146513','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148742','148990','150422','150423','150424','150593','151099','151100','151101','151102','151103','151104','151105','151106','151110','151632','151873','151874','152508','153548','154505','154506','154507','154508','154509','154644','157121','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157133','157134','157135','157136','157137','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158664','158674','158715','158988','158989','159161','159162','159358','159359','159360','159398','159581','159585','159633','159634','159635','159636','159867','160094','160133','160261','160262','160263','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161021','161022','161023','161024','161025','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162186','162187','162188','162189','162277','162281','162461','162634','162733','162744','162855','162887','162892','162951','163200','163201','163202','163203','163204','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169346','169733','201239','201240','202857','202858','202859','215203','215469','215470','215471','215472','215473','215474','215475','215476','215759','216086','219751','232623','238139','238186','238412','238581','238582','238927','238928','238929','238930','238931','238932','239870','239966','240073','240141','240224','241008','242056','242075','242076','242077','242078','242079','242080','242081','242082','242083','242084','242085','242086','242087','242088','242089','242157','242223','242224','242225','242226','242227','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245074','245582','246276','246277','246278','246741','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118','141453','141605','141705','141822','141823','141824','141825','142200','143045','143046','143068','143070','143071','143072','143203','143204','146489','146490','146492','146572','146573','146574','146584','147078','148414','148572','148573','148574','148575','148576','148577','148578','150674','151473','151474','153547','153775','153920','154239','154278','154560','154569','155022','155085','155649','156832','157167','157168','157169','157170','157171','157172','157173','157174','157175','157176','157177','157178','157971','157972','158084','158085','158091','158305','158334','158335','158669','158671','158672','158880','158881','158882','158883','158884','158885','159249','159458','159487','159502','159515','159801','159953','159954','159955','159956','159957','159958','160250','160251','160343','160397','160416','160417','160418','160419','160677','161185','161186','161782','161783','162139','162817','162818','162998','162999','163000','163001','164213','165361','169188','169189','169208','169209','169321','169347','169780','170008','170100','170317','170318','170399','170400','170401','185925','202784','211012','215277','215427','215538','215891','232411','232474','232584','232585','232639','238080','238081','238082','238083','238467','238669','238802','238879','238880','239129','239130','239163','239195','239227','239228','239300','239328','239496','239711','240083','240222','240229','240885','241015','241335','241336','241342','241510','241511','241837','241838','242010','242385','242462','242861','242946','243142','243283','243558','243687','243707','243902','245101','245279','246171','246378','246379','247154','247212','247250','249330','249431','249463','249464','249465','249466','249467','249907','250016','250017','250018','250019','250884','250885','251628','251629','253579','253580','253581','253582','253583','266079','301924','149475','158855','160637','160671','167847','167848','209105','209106','209107','209108','209109','209110','209111','209112','209113','209114','209115','209116','209117','209118','209119','209120','209121','209122','209123','209124','209125','209126','209127','209128','209129','209130','209131','209132','209133','209134','209135','209136','209137','209138','209139','209140','209141','209142','209143','209144','209145','209146','209147','209148','209149','209150','209151','209152','209153','209154','209155','209156','209157','209158','209159','209160','209161','209162','209163','209164','209165','209166','209167','209168','209169','209170','209171','209172','209173','209174','209175','209176','209177','209178','209179','209180','209181','209182','209183','209184','209185','209186','209187','209188','209189','209190','209191','209192','209193','209194','209195','209196','209197','209198','209199','209200','209201','209202','209203','209204','209205','209206','209207','209208','209209','209210','209211','209212','209213','209214','240481','240482','240515','240735','27','143095','143096','143097','143098','143099','148139','154737','155074','155075','155101','155102','155103','157179','157180','157181','157182','157183','157184','157185','157186','157187','157188','157189','157190','157191','157192','157193','157579','159971','159972','161784','161785','161786','163730','163731','163732','163733','163854','163870','163871','163872','163873','163874','163875','164323','164324','164325','164326','164327','164328','164329','164330','164331','164332','164333','164334','164335','164336','164337','164338','164339','164340','165049','165050','165051','165052','165215','165216','165217','165219','165220','165221','165222','165223','165224','165225','165226','167031','167032','168308','238521','238522','238524','238525','238526','238536','238537','238803','244698','247374','248335','252068','253336','262409','262575','264693','265750','293430','148150','148151','155015','155016','155017','156833','156834','156835','156836','156837','156838','156839','156840','156841','156842','156843','156844','156845','156846','157232','157233','157234','157235','157573','157574','157575','157576','157577','157578','157757','157842','159172','159173','159174','159175','238979','149479','149480','149481','149482','153427','158058','158059','158060','158061','158062','166082','166083','166084','209216','209217','209218','209219','209220','209221','209222','209223','209224','209225','209226','209227','209228','209229','209230','209231','209232','209233','209234','209235','209236','209237','209238','209239','209240','209241','209242','209243','209244','209245','209246','209247','209248','209249','209250','209251','209252','209253','209254','209255','209256','209257','209258','209259','209260','209261','209262','209263','209264','209265','209266','209267','209268','209269','209270','209271','209272','209273','209274','209275','209276','209277','209278','209279','209280','209281','209282','209283','209284','209285','209286','209287','209288','209289','209290','209291','209292','209293','209294','209295','209296','209297','209298','209299','209300','209301','209302','209303','209304','209305','209306','209307','209308','209309','209310','209311','209312','209313','209314','209315','209316','209317','209318','209319','209320','209321','209322','209323','209324','209325','209326','209327','209328','209329','209330','209331','209332','209333','209334','209335','209336','209337','209338','209339','209340','209341','209342','209343','209344','209345','209346','209347','209348','209349','209350','209351','209352','209353','209354','209355','209356','209357','209358','209359','209360','209361','209362','209363','209364','209365','209366','209367','209368','209369','209370','209371','241628','264844','265050','266002','299291','299729','141926','142708','154637','154803','154804','155077','155078','155079','155373','155374','155375','155376','159914','169788','202791','215927','215928','215929','232739','238157','238513','240887','241756','242445','243465','247778','249170','249171','275760','279230','282943','284839','154809','154810','154811','154812','154813','154814','154815','157249','157250','157251','157252','238416','247218','247219','247220','247221','247222','301981','141657','141658','141659','144137','144252','150442','150443','150943','153797','154259','154680','158089','158718','163375','163376','165007','165008','165009','165010','165357','165358','165359','165360','168270','169190','213242','213243','213244','213245','213246','213247','213248','213249','213250','213251','213252','213253','213254','213255','213256','213257','213258','213259','213260','213261','213262','213263','213264','213265','213266','213267','213268','213269','213270','213271','213272','213273','213274','213275','213276','213277','215214','215215','232782','232783','232784','232785','232786','238100','238101','238102','238248','238295','238296','238307','238308','238309','238310','238311','238312','238313','239007','239008','239009','239010','239011','239012','239445','239446','239447','239448','239449','239450','239519','239520','239522','239840','241311','241312','241313','241314','241327','241328','241463','243730','243732','245926','248655','250022','250023','250024','250025','250026','250259','251178','251626','251627','251630','251970','251971','279810','143015','147071','151310','157659','158471','158706','159819','160614','160675','160676','162562','163535','164478','167194','167489','215505','215725','232750','232754','232755','238046','238206','238317','238413','238478','238949','239185','239524','239645','239654','240648','241772','242650','243521','245273','245503','250144','261774','267693','281481','142018','146493','146933','147738','147878','147879','151308','151309','153898','154258','154417','158705','159760','159761','159762','159798','160734','202770','215723','215724','232640','232748','232749','232751','232752','238058','238204','238205','238315','238540','238544','238945','238946','238947','240297','240298','240299','240609','240610','243036','243400','243401','245497','245498','245502','250053','266239','141425','141786','141851','141853','141936','142140','143279','144959','144961','144965','144966','145116','145117','145118','146204','146507','146508','146579','146858','146943','146997','147752','147881','147888','148708','149630','150542','150555','150556','150557','150558','150589','150698','150699','150700','150701','151478','153392','153401','153779','153780','153781','154325','154500','154528','154549','155018','155019','155021','155285','155317','155492','155555','155647','155862','155863','157236','157237','157238','157239','157240','157241','157242','157243','157244','157245','157246','157247','157248','157582','158003','158079','158080','158081','158107','158108','158168','158470','158523','158524','158527','158547','158548','158549','158574','158607','158756','158961','159056','159057','159176','159554','160067','160509','161393','161394','162368','162498','162927','162928','163074','163075','164164','164248','164781','164977','165531','165623','165659','165700','165800','165999','166201','166236','167053','167329','167413','167414','167797','168388','169121','169144','169307','169330','170770','201254','202832','215251','215252','215454','215709','215862','215998','215999','216040','232500','232539','238805','238836','238974','238975','238976','238978','239144','239515','239960','240103','240106','240351','240355','240402','240471','240576','240659','240780','240781','241627','241629','241863','242116','242117','242118','242375','242536','242537','242862','245117','245118','245303','245455','245499','245539','245624','246375','246376','246377','246922','247214','247727','247728','247939','247976','248696','249646','251466','254372','254373','254450','254628','254701','255247','255248','255249','255250','255251','255252','255253','255254','255255','255256','255257','255258','255259','255260','255261','255262','255263','255264','255265','255266','255267','255268','255269','255270','255271','255272','255273','255274','255275','255276','261714','261715','261716','261719','261721','262408','262410','264375','264376','264432','265172','265324','267490','267677','267678','267922','273497','273565','273566','273567','274608','274609','275032','275187','275956','277472','277510','279466','284310','294999','300517') 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 ('141341','141426','141427','141428','141429','141430','141431','141432','141433','141434','141435','141436','141437','141438','141439','141440','141464','141465','141515','141584','141585','141586','141587','141656','141657','141658','141659','141669','141674','141704','141706','141707','141727','141728','141732','141735','141850','141852','141854','141869','141898','141899','141900','141901','141902','141904','141905','141906','141926','141936','141984','142018','142033','142044','142046','142047','142048','142049','142109','142110','142138','142139','142140','142143','142144','142155','142157','142171','142195','142196','142197','142220','142641','142642','142643','142644','142645','142691','142692','142693','142694','142695','142697','142701','142708','142754','142755','142766','142811','142857','142860','142866','142867','142868','142869','142870','142871','142872','142873','142874','142908','142909','142910','142986','142998','143000','143001','143002','143003','143004','143005','143006','143007','143008','143009','143010','143011','143012','143013','143014','143015','143016','143017','143018','143019','143020','143021','143022','143024','143025','143026','143027','143028','143029','143030','143031','143032','143033','143034','143035','143036','143038','143039','143040','143041','143042','143044','143048','143085','143089','143090','143091','143094','143100','143102','143103','143104','143105','143106','143107','143108','143109','143110','143111','143112','143113','143114','143115','143116','143117','143118','143119','143120','143121','143122','143123','143165','143203','143204','143206','143207','143209','143213','143215','143218','143279','143411','143416','143536','143580','143782','143783','144133','144137','144146','144147','144167','144168','144169','144170','144221','144233','144234','144235','144236','144237','144239','144240','144244','144246','144247','144248','144249','144250','144252','144940','144956','144957','144958','144960','144962','144963','144964','145116','145119','145121','145122','145123','145178','145179','145180','145268','145270','146204','146491','146493','146494','146495','146496','146497','146499','146500','146501','146502','146503','146504','146505','146511','146522','146524','146525','146527','146529','146530','146533','146538','146540','146563','146564','146569','146579','146590','146728','146861','146862','146863','146864','146865','146866','146867','146933','146997','147002','147044','147071','147216','147708','147738','147752','147878','147879','147884','147888','148016','148018','148019','148150','148151','148172','148174','148175','148176','148177','148178','148179','148180','148181','148182','148183','148184','148185','148186','148363','148372','148373','148395','148400','148401','148402','148405','148414','148669','148704','148708','148741','148990','149475','149479','149480','149481','149482','149619','149907','150281','150423','150424','150442','150443','150462','150542','150555','150556','150557','150558','150589','150593','150617','150665','150696','150698','150699','150700','150701','150702','150820','150822','150838','150839','150840','150913','150914','150915','150917','150918','150943','151009','151010','151089','151099','151100','151101','151102','151103','151238','151252','151293','151294','151308','151309','151310','151408','151426','151478','151578','151735','151869','151874','151978','151989','152508','153060','153381','153382','153392','153401','153427','153452','153539','153548','153650','153750','153779','153780','153781','153797','153816','153881','153882','153883','153884','153895','153896','153898','153939','153940','154146','154161','154258','154259','154325','154417','154424','154500','154509','154528','154549','154568','154637','154644','154680','154725','154737','154738','154752','154753','154754','154755','154756','154757','154758','154803','154804','154809','154810','154811','154812','154813','154814','154815','154816','154908','154910','154999','155015','155016','155017','155018','155019','155021','155040','155041','155042','155043','155077','155078','155079','155116','155130','155131','155132','155285','155287','155291','155292','155293','155294','155301','155304','155305','155343','155373','155374','155375','155376','155452','155488','155489','155558','155632','155633','155665','155823','155824','156833','156834','156835','156836','156837','156838','156839','156840','156841','156842','156843','156844','156845','156846','157022','157023','157024','157025','157026','157027','157028','157029','157030','157031','157032','157033','157034','157035','157036','157037','157038','157039','157040','157041','157042','157043','157044','157045','157046','157047','157048','157049','157050','157051','157052','157053','157054','157055','157056','157057','157058','157059','157060','157061','157062','157063','157064','157065','157066','157067','157068','157069','157070','157071','157072','157073','157074','157075','157076','157077','157078','157079','157080','157081','157082','157083','157084','157085','157086','157087','157088','157089','157090','157091','157092','157093','157094','157095','157096','157097','157098','157099','157100','157101','157102','157103','157104','157105','157106','157107','157108','157109','157110','157111','157112','157113','157114','157115','157116','157117','157118','157119','157120','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157192','157232','157233','157234','157235','157238','157239','157245','157249','157250','157251','157252','157253','157254','157255','157256','157257','157571','157572','157573','157574','157575','157576','157577','157578','157580','157582','157636','157658','157659','157742','157743','157744','157745','157757','157769','157770','157771','157772','157773','157774','157775','157776','157807','157842','157846','157907','157945','157948','157949','158003','158006','158008','158035','158036','158037','158038','158058','158059','158060','158061','158062','158067','158068','158070','158071','158079','158081','158086','158087','158088','158089','158107','158108','158168','158169','158208','158232','158272','158293','158317','158318','158324','158325','158326','158329','158330','158331','158332','158333','158356','158387','158427','158428','158429','158430','158431','158432','158433','158434','158435','158436','158437','158470','158471','158472','158475','158487','158488','158489','158490','158513','158514','158523','158524','158527','158547','158548','158549','158574','158580','158602','158607','158608','158666','158667','158668','158700','158701','158705','158706','158715','158717','158718','158719','158720','158756','158788','158855','158877','158878','158879','158886','158949','158961','159011','159056','159057','159065','159066','159162','159172','159173','159174','159175','159176','159242','159246','159278','159283','159284','159285','159286','159287','159288','159289','159290','159291','159292','159293','159294','159295','159338','159339','159358','159359','159360','159391','159472','159477','159512','159513','159514','159545','159581','159585','159644','159760','159761','159762','159777','159778','159798','159819','159867','159886','159890','159902','159903','159904','159905','159914','159949','159950','159951','159952','159956','160020','160067','160101','160102','160104','160113','160128','160129','160130','160131','160247','160248','160249','160265','160293','160346','160373','160374','160415','160487','160508','160509','160592','160610','160611','160612','160613','160614','160637','160671','160672','160673','160674','160675','160676','160717','160734','160746','160774','160791','160922','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161078','161081','161082','161083','161122','161174','161175','161176','161177','161178','161179','161184','161212','161213','161284','161393','161394','161439','161576','161577','161578','161579','161580','161581','161582','161583','161584','161585','161586','161587','161609','161688','161749','161750','161751','161753','161754','161755','161778','161779','161780','161781','161786','161911','162008','162152','162167','162168','162265','162368','162461','162498','162561','162562','162634','162733','162744','162855','162887','162927','162928','162951','162996','162997','163016','163074','163075','163200','163202','163203','163205','163206','163207','163208','163211','163375','163376','163534','163535','163577','163706','163801','163833','163854','163870','163871','163872','163873','163874','163875','163885','164103','164164','164248','164320','164321','164323','164324','164325','164326','164327','164328','164329','164330','164331','164332','164333','164334','164335','164336','164337','164338','164339','164340','164351','164352','164475','164476','164477','164478','164642','164676','164677','164781','164977','165007','165008','165009','165010','165049','165051','165052','165212','165213','165214','165215','165216','165217','165219','165220','165221','165222','165223','165224','165225','165226','165237','165250','165293','165295','165296','165357','165358','165359','165360','165429','165430','165433','165434','165435','165436','165437','165476','165531','165554','165622','165623','165659','165700','165800','165965','165985','165986','165987','165988','165998','165999','166082','166083','166084','166085','166144','166201','166236','166407','166435','166532','166565','166783','167031','167032','167053','167115','167141','167194','167240','167307','167329','167342','167343','167413','167414','167424','167489','167490','167706','167797','167847','167967','167968','167995','168020','168021','168022','168023','168024','168124','168153','168169','168270','168308','168315','168388','168405','169095','169106','169122','169123','169124','169125','169126','169127','169128','169129','169130','169131','169132','169133','169137','169138','169143','169144','169171','169176','169177','169190','169210','169211','169254','169270','169271','169295','169296','169305','169307','169315','169320','169325','169330','169331','169332','169336','169341','169343','169344','169345','169349','169733','169772','169779','169788','169975','169976','169977','169982','169983','169984','169985','170016','170017','170018','170053','170086','170102','170104','170105','170106','170107','170108','170109','170110','170111','170112','170153','170296','170393','170394','170645','170711','170767','170768','170769','170770','170771','170772','170773','185926','185927','185928','201239','201240','201254','201255','201283','202570','202577','202660','202729','202770','202791','202832','202857','202858','202859','206108','207570','208173','208777','208778','208779','208780','208781','208782','208783','208784','208785','208786','208787','208788','208789','208790','208791','208792','208793','208794','208795','208796','208797','208798','208799','208800','208801','208802','208803','208804','208805','208806','208807','208808','208809','208810','208811','208812','208813','208814','208815','208816','208817','208818','208819','208820','208821','208822','208823','208824','208825','208826','208827','208828','208829','208830','208831','208832','208833','208834','208835','208836','208837','208838','208839','208840','208841','208842','208843','208844','208845','208846','208847','208848','208849','208850','208851','208852','208853','208854','208855','208856','208857','208858','208859','208860','208861','208862','208863','208864','208865','208866','208867','208868','208869','208870','208871','208872','208873','208874','208875','208876','208877','208878','208879','208880','208881','208882','208883','208884','208885','208886','208887','208888','208889','208890','208891','208892','208893','208894','208895','208896','208897','209105','209106','209107','209108','209109','209110','209111','209112','209113','209114','209115','209116','209117','209118','209119','209120','209121','209122','209123','209124','209125','209126','209127','209128','209129','209130','209131','209132','209133','209134','209135','209136','209137','209138','209139','209140','209141','209142','209143','209144','209145','209146','209147','209148','209149','209150','209151','209152','209153','209154','209155','209156','209157','209158','209159','209160','209161','209162','209163','209164','209165','209166','209167','209168','209169','209170','209171','209172','209173','209174','209175','209176','209177','209178','209179','209180','209181','209182','209183','209184','209185','209186','209187','209188','209189','209190','209191','209192','209193','209194','209195','209196','209197','209198','209199','209200','209201','209202','209203','209204','209205','209206','209207','209208','209209','209210','209211','209212','209213','209214','209215','209216','209217','209218','209219','209220','209221','209222','209223','209224','209225','209226','209227','209228','209229','209230','209231','209232','209233','209234','209235','209236','209237','209238','209239','209240','209241','209242','209243','209244','209245','209246','209247','209248','209249','209250','209251','209252','209253','209254','209255','209256','209257','209258','209259','209260','209261','209262','209263','209264','209265','209266','209267','209268','209269','209270','209271','209272','209273','209274','209275','209276','209277','209278','209279','209280','209281','209282','209283','209284','209285','209286','209287','209288','209289','209290','209291','209292','209293','209294','209295','209296','209297','209298','209299','209300','209301','209302','209303','209304','209305','209306','209307','209308','209309','209310','209311','209312','209313','209314','209315','209316','209317','209318','209319','209320','209321','209322','209323','209324','209325','209326','209327','209328','209329','209330','209331','209332','209333','209334','209335','209336','209337','209338','209339','209340','209341','209342','209343','209344','209345','209346','209347','209348','209349','209350','209351','209352','209353','209354','209355','209356','209357','209358','209359','209360','209361','209362','209363','209364','209365','209366','209367','209368','209369','209370','209371','210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','211011','211877','211878','211879','211880','211881','211882','211883','211884','211885','211886','211887','211888','211889','211890','211891','211892','211893','211894','211895','211896','211897','211898','211899','211900','211901','211902','211903','211904','211905','211906','211907','211908','211909','211910','211911','211912','211913','211914','211915','211916','211917','211918','211919','211920','211921','211922','211923','211924','211925','211926','211927','211928','211929','211930','211931','211932','211933','211934','211935','211936','211937','211938','211939','211940','211941','211942','211943','211944','211945','211946','211947','211948','211949','211950','211951','211952','211953','211954','211955','211956','211957','211958','212850','212851','212852','212853','212854','212855','212856','212857','212858','212859','212860','212861','212862','212863','212864','212865','212866','212867','212868','212869','212870','212871','212872','212873','212874','212875','212876','212877','212878','212879','212880','212881','212882','212883','212884','212885','212886','212887','212888','212889','212890','212891','212892','212893','212894','212895','212896','212897','212898','212899','212900','212901','212902','212903','212904','212905','212906','212907','212908','212909','212910','213242','213243','213244','213245','213246','213247','213248','213249','213250','213251','213252','213253','213254','213255','213256','213257','213258','213259','213260','213261','213262','213263','213264','213265','213266','213267','213268','213269','213270','213271','213272','213273','213274','213275','213276','213277','215214','215215','215239','215251','215252','215287','215371','215372','215373','215408','215417','215454','215505','215526','215557','215586','215594','215627','215628','215629','215631','215632','215633','215638','215714','215715','215716','215717','215718','215719','215723','215724','215725','215754','215755','215756','215757','215758','215777','215781','215830','215831','215862','215885','215927','215928','215929','215998','215999','216040','216041','216042','216076','216086','216105','216106','219728','219751','232500','232539','232623','232640','232677','232739','232748','232749','232750','232751','232752','232753','232754','232755','232782','232783','232784','232785','232786','238026','238027','238046','238058','238059','238100','238101','238102','238139','238142','238143','238144','238154','238157','238185','238186','238203','238204','238205','238206','238248','238266','238271','238272','238275','238295','238296','238307','238308','238309','238310','238311','238312','238313','238315','238316','238317','238387','238412','238413','238416','238440','238441','238477','238478','238502','238513','238514','238515','238516','238517','238518','238540','238544','238578','238581','238582','238601','238602','238616','238617','238631','238632','238633','238644','238646','238671','238680','238681','238739','238770','238771','238772','238773','238774','238775','238776','238777','238778','238779','238780','238781','238782','238783','238784','238785','238786','238789','238793','238794','238795','238796','238797','238798','238799','238800','238801','238805','238821','238835','238836','238878','238906','238907','238909','238910','238911','238912','238913','238914','238924','238925','238945','238946','238947','238948','238949','238974','238975','238976','238977','238978','238979','238981','239007','239008','239009','239010','239011','239012','239044','239045','239046','239047','239048','239049','239050','239051','239052','239053','239054','239055','239056','239057','239058','239060','239061','239062','239063','239064','239065','239066','239067','239068','239069','239070','239071','239072','239073','239074','239075','239076','239077','239079','239080','239081','239082','239083','239084','239086','239087','239088','239089','239090','239091','239092','239093','239094','239095','239144','239184','239185','239214','239223','239224','239232','239251','239252','239323','239327','239445','239446','239447','239448','239449','239450','239460','239461','239462','239463','239464','239465','239491','239516','239519','239520','239522','239523','239524','239636','239644','239645','239654','239689','239691','239692','239840','239859','239870','239876','239916','239917','239960','239966','240085','240101','240102','240103','240116','240134','240139','240140','240141','240179','240191','240192','240205','240275','240276','240284','240297','240298','240299','240315','240316','240317','240318','240330','240336','240351','240355','240402','240432','240450','240481','240482','240495','240515','240532','240576','240609','240610','240611','240612','240620','240621','240648','240659','240735','240755','240780','240916','240919','240920','240921','240973','240974','240975','240976','241008','241018','241019','241023','241026','241027','241028','241029','241118','241311','241312','241313','241314','241327','241328','241451','241463','241475','241577','241599','241624','241626','241627','241628','241629','241677','241756','241772','241773','241824','241825','241863','241891','241917','241981','241982','242056','242104','242105','242116','242117','242118','242154','242175','242207','242208','242210','242282','242283','242375','242383','242384','242437','242438','242439','242440','242445','242447','242448','242460','242485','242498','242536','242537','242570','242574','242597','242626','242627','242633','242648','242649','242650','242791','242792','242863','242864','242865','242866','242867','242898','242909','243036','243037','243079','243082','243092','243126','243369','243398','243399','243400','243401','243415','243416','243465','243521','243522','243697','243730','243732','243741','243828','243895','244189','244190','244191','244379','244424','244425','244426','244427','244428','244640','244655','244656','244698','244925','244929','244930','244931','244932','244933','245117','245118','245161','245162','245163','245164','245166','245271','245272','245273','245277','245303','245304','245305','245472','245497','245498','245499','245500','245501','245502','245503','245539','245582','245624','245743','245926','245996','245997','245998','246077','246276','246277','246375','246377','246409','246482','246723','246818','246922','247204','247218','247219','247220','247221','247222','247225','247226','247329','247330','247374','247477','247576','247727','247728','247729','247778','247939','247976','248047','248092','248335','248419','248649','248655','248837','249026','249027','249029','249198','249199','249200','249201','249202','249204','249205','249218','249245','249300','249646','249922','250002','250022','250023','250024','250025','250026','250046','250051','250052','250053','250076','250077','250078','250143','250144','250165','250259','250345','250656','250736','250742','250743','250862','251038','251072','251178','251181','251182','251183','251241','251242','251243','251273','251466','251479','251480','251601','251626','251627','251630','251649','251708','251906','251970','251971','252068','252102','252192','252193','253336','253492','253707','254372','254373','254450','254466','254467','254468','254469','254473','254474','254475','254628','255252','255267','255273','255276','255391','255402','255431','255524','255525','255782','255948','255989','255990','256021','256583','256595','256800','256918','256942','256943','257136','261714','261715','261716','261717','261718','261719','261720','261721','261774','262403','262405','262406','262407','262408','262409','262410','262575','263615','263718','264375','264376','264432','264693','264730','264770','264844','264911','265050','265172','265186','265234','265324','265388','265389','265691','265739','265749','265750','265836','266002','266079','266080','266081','266144','266239','266246','266247','266411','266556','266695','266979','267250','267327','267328','267490','267491','267543','267544','267545','267546','267547','267549','267550','267552','267553','267554','267555','267556','267557','267558','267559','267560','267561','267562','267563','267564','267637','267677','267678','267692','267693','267824','267921','267922','268007','268147','268148','268149','268150','268414','268658','269026','269125','269126','269127','269128','269129','269130','269131','269132','269133','269134','269135','269136','269137','269138','269139','269140','269141','269142','269143','269144','269368','269397','269625','273399','273468','273497','273511','273565','273566','273567','274085','274282','274608','274609','274821','274822','274823','274824','274922','274944','275032','275127','275187','275599','275760','275956','276068','276096','276252','276403','276601','277244','277245','277246','277247','277376','277472','277510','277939','278008','278123','278124','278164','278184','278623','278715','278764','278765','279333','279465','279466','279660','279661','279757','279810','280349','280664','280927','281031','281432','281481','281694','281699','282089','282757','282944','283135','283334','283335','283488','283504','283796','284310','284502','284551','284552','284553','284554','284646','284647','284648','284839','284938','284939','284940','284942','284944','284945','285048','285201','285202','285203','285204','285696','285819','286024','286162','286285','286427','286824','286825','286879','288213','288337','288448','288449','288538','289415','291863','292016','292234','292348','293430','293469','293896','293898','293900','293901','293902','293903','293905','294041','294338','294813','294999','295277','297324','297934','298413','298414','298415','298416','298417','298418','298419','298420','298421','298422','298423','298424','298425','298426','298427','298428','298429','298430','298431','298432','298433','298477','299291','299377','299663','299729','300275','300516','300517','300518','301800','301924','301981','302112','302113','302114','302115','302116','302117','302118') GROUP BY `manuf` ORDER BY `manuf` ASC