childsstroke: manuf
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 ('153062','153076','153077','153079','153097','153103','153105','153118','153121','153122','153198','153199','153200','153203','153204','153209','153210','153299','153302','153303','153304','153307','153370','153375','153384','153385','153386','153387','153388','153446','153447','153448','153546','153571','153577','153591','153592','153598','153599','153762','153793','153794','153949','153950','154529','154530','154533','154567','154719','154759','154884','154885','154886','154895','155159','155160','155161','155199','155219','155220','155221','155222','155223','155224','155246','155277','155465','155560','155707','155718','156598','156599','156600','156601','156602','156603','156604','156605','156606','156607','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','157553','157630','157631','157667','157699','158000','158005','158022','158023','158247','158262','158263','158530','158616','158692','158742','158743','158767','159106','159153','159154','159155','159156','159206','159439','159606','159675','159707','159979','159994','159995','160136','160137','160239','160252','160300','160303','160365','160366','160401','160482','160560','160582','160756','160829','161233','161234','161235','161236','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161531','161708','161709','161738','161812','162034','162068','162097','162098','162100','162206','162216','162217','162224','162295','162298','162418','162563','162655','162695','162748','162871','163100','163101','163149','163527','163707','163918','163919','163920','163930','163946','163963','163982','164129','164136','164268','164281','164360','164388','164389','164440','164458','164459','164643','164668','164772','164773','164774','164775','164827','164919','164932','165081','165110','165134','165177','165178','165394','165518','165532','165679','165723','165748','165934','166202','166203','166340','166539','166600','166624','166625','166652','166736','166793','166887','166889','166930','166963','167219','167294','167298','167474','167641','167739','167740','167960','168012','168047','168057','168082','168088','168089','168387','219749','232428','232498','232499','232536','232540','232586','232602','232687','232773','232774','232775','232776','238207','238208','238263','238264','238265','238297','238551','238622','238723','238724','238832','238839','238957','238958','239166','239198','239572','239627','239878','240072','240344','240505','240513','240634','240875','240876','240877','240930','241077','241078','241079','241159','241564','241632','242011','242012','242013','242017','242018','242019','242020','242266','242331','242332','242361','242364','242365','242404','242458','242499','242500','242545','242587','242784','243045','243070','243071','243106','243129','243279','243280','243281','243282','243375','243376','243600','243708','243930','244106','244324','244719','244724','244732','244990','245071','245093','245170','245380','245381','245520','245544','245854','246445','246472','246583','246584','246585','246586','246682','246831','247151','247211','247471','247620','247781','248016','248110','248134','248167','248257','248260','248261','248362','248669','248670','248687','249104','249105','249108','249435','249436','249468','249469','249470','249550','249553','249593','249594','249601','249602','249603','249671','249692','249693','249853','250043','250292','250599','250648','250649','250698','250764','250831','251280','251539','251554','251555','251556','251557','251575','251688','251787','251812','251850','251963','251964','252144','252145','252147','252160','252161','252215','252238','253122','253161','253163','253547','253590','253629','253880','254241','254242','254313','254421','254477','254545','254558','254637','254974','254977','254978','254979','255194','255195','255343','255436','255580','255668','255816','255817','255837','255949','256058','256060','256061','256082','256524','256525','256548','256577','256585','256926','257131','257132','257149','257152','262067','262109','262315','262415','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262517','262521','262565','262720','262721','262854','262880','262888','262889','262937','262949','262950','262951','262952','262953','262954','262955','262995','263491','263683','264401','264438','264503','264504','264505','264894','264895','264932','265239','265297','265298','265299','265300','265331','265342','265465','265480','265481','265482','265483','265704','265746','266005','266051','266052','266077','266253','266270','266426','266427','266428','266666','266715','266771','266833','266834','266835','266839','267073','267265','267291','267292','267580','267663','267718','267944','267945','267946','267947','268152','268348','268522','268535','268561','268595','268751','268816','268817','268818','268819','268820','268821','268822','268823','268824','268832','269028','269093','269113','269422','269512','269513','269514','269525','269749','273350','273472','273728','273729','273730','273738','273739','273740','273851','273911','273920','273948','274097','274133','274290','274439','274440','274722','274804','275000','275025','275048','275049','275200','275214','275220','275474','275476','275740','275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275909','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','276132','276149','276363','276364','276421','276435','276520','276633','276779','276972','276973','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277097','277098','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','277533','277587','277589','277866','277915','277916','277919','277961','277962','277995','277999','278221','278277','278472','278585','278586','278650','278651','278652','278653','278654','278732','278824','278825','278826','278827','278828','278829','278830','278888','279029','279033','279131','279401','279460','279461','279514','279667','280290','280504','280505','280508','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280712','280736','280737','280738','280740','280743','280799','280800','280808','280824','281144','281145','281146','281150','281151','281244','281245','281409','281410','281620','281680','281733','281758','281759','281791','281901','282008','282060','282086','282087','282171','282190','282438','282569','282570','282786','282787','282788','282791','282794','282795','283179','283180','283353','283551','283552','283597','283598','283599','283600','283736','283737','284145','284150','284158','284159','284160','284168','284182','284334','284446','284447','284500','284504','284505','284506','284507','284520','284521','284524','284528','284604','284949','284997','285233','285257','285275','285325','285412','285429','285445','285556','285559','285579','285670','285707','285836','285837','285838','285839','285840','285841','285842','285843','285899','286031','286032','286125','286147','286148','286149','286150','286151','286225','286273','286305','286306','286307','286335','286336','286387','286619','286620','286665','286801','286868','286883','286884','286911','286922','286991','287099','287123','287161','287214','287215','287216','287217','288011','288074','288100','288196','288202','288309','288377','288380','288381','288383','288384','288385','288502','288561','288562','288563','288661','288825','288826','288827','288828','288831','288832','288897','289007','289187','289278','289279','289396','289435','289441','291595','291596','291598','291691','291692','291693','291694','291695','291724','291805','291807','291853','291954','292094','292223','292244','292262','292263','292264','292268','292269','292336','292360','292365','292403','292429','292491','292523','292524','292594','292635','292636','292771','292839','292852','292859','292861','293208','293231','293286','293416','293433','293501','293563','293581','293660','293661','293662','293663','293664','293665','293666','293667','293668','293669','293670','293671','293672','293673','293674','293675','293676','293677','293678','293679','293680','293681','293682','293683','293684','293685','293686','293687','293688','293689','293690','293691','293692','293693','293694','293695','293696','293697','293698','293699','293700','293701','293702','293703','293704','293705','293706','293707','293708','293709','293710','293711','293712','293713','293714','293715','293716','293717','293718','293719','293720','293721','293722','293723','293724','293725','293726','293727','293728','293729','293730','293731','293732','293733','293734','293735','293736','293737','293738','293739','293740','293741','293742','293743','293744','293745','293746','293747','293748','293749','293750','293751','293752','293753','293754','293755','293756','293757','293758','293759','293760','293761','293762','293763','293764','293765','293766','293767','293768','293769','293770','293771','293772','293773','293774','293775','293776','293777','293778','293779','293780','293781','293782','293783','293784','293785','293786','293787','293788','293789','293790','293791','293792','293793','293794','293795','293796','293797','293798','293799','293800','293801','293802','293803','293804','293805','293806','293807','293808','293809','293810','293811','293812','293813','293814','293815','293816','293817','293818','293819','293820','293821','293822','293823','293824','293825','293826','293827','293828','293829','293830','293831','293832','293833','293834','293835','293836','293837','293838','293839','293840','293841','293842','293843','293844','293845','293846','293847','293848','293849','293850','294017','294042','294059','294333','294571','294590','294684','294704','294705','294706','294707','294723','294752','294753','294812','294815','294978','295330','295359','295360','295456','295477','295490','295491','295507','295528','295530','295531','295549','295550','295551','295552','295553','295573','295579','295605','295606','295629','295635','295756','295757','295758','295807','295809','295862','295981','295999','296206','296235','296258','296286','297106','297158','297162','297213','297448','297463','297512','297539','297561','297579','297721','297733','297754','297780','297983','297984','297985','297996','297997','298059','298112','298114','298170','298241','298266','298270','298271','298276','298283','298284','298412','298445','298532','298538','298539','298581','299101','299203','299283','299503','299515','299516','299517','299518','299519','299520','299521','299556','299557','299705','299706','299707','299712','299713','299714','299715','299732','299743','299766','299836','299837','299838','299845','299861','299862','299897','299904','299905','299910','299912','299913','299914','299921','299929','299984','299997','300004','300037','300049','300272','300301','300303','300308','300398','300522','300533','300644','300651','300653','300654','300705','300715','300904','300948','300949','300950','300951','300952','300953','300954','300955','300956','300957','300958','300959','300960','300961','300962','300963','300964','300965','300966','300967','300968','300969','300970','300971','300972','300973','300974','300975','300976','300977','300978','300979','300980','300981','300982','300983','300984','300985','300986','300987','300988','300989','300996','301003','301004','301010','301017','301050','301051','301052','301059','301062','301063','301064','301822','301836','301842','301843','301844','301847','301848','301858','301862','301877','301882','301913','301922','301923','301925','301969','301977','302057','302100','302125','302130','302154','302157','302158','302179','302180','302197','302202','302206','302207','302220','302307','302323','302325','302326','302356','302360','302365','303822','303843','303861','303924','303925','303958','303960','303961','303962','303963','303964') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: manuf
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 ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: SELECT `max_current`,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 `max_current` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `max_current` ORDER BY `max_current` ASC
childsstroke1: SELECT `max_voltage`,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 `max_voltage` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `max_voltage` ORDER BY `max_voltage` ASC
childsstroke: montage2
SELECT `montage2`,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 `montage2` !='' AND `modx_site_content`.`id` IN ('153062','153076','153077','153079','153097','153103','153105','153118','153121','153122','153198','153199','153200','153203','153204','153209','153210','153299','153302','153303','153304','153307','153370','153375','153384','153385','153386','153387','153388','153446','153447','153448','153546','153571','153577','153591','153592','153598','153599','153762','153793','153794','153949','153950','154529','154530','154533','154567','154719','154759','154884','154885','154886','154895','155159','155160','155161','155199','155219','155220','155221','155222','155223','155224','155246','155277','155465','155560','155707','155718','156598','156599','156600','156601','156602','156603','156604','156605','156606','156607','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','157553','157630','157631','157667','157699','158000','158005','158022','158023','158247','158262','158263','158530','158616','158692','158742','158743','158767','159106','159153','159154','159155','159156','159206','159439','159606','159675','159707','159979','159994','159995','160136','160137','160239','160252','160300','160303','160365','160366','160401','160482','160560','160582','160756','160829','161233','161234','161235','161236','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161531','161708','161709','161738','161812','162034','162068','162097','162098','162100','162206','162216','162217','162224','162295','162298','162418','162563','162655','162695','162748','162871','163100','163101','163149','163527','163707','163918','163919','163920','163930','163946','163963','163982','164129','164136','164268','164281','164360','164388','164389','164440','164458','164459','164643','164668','164772','164773','164774','164775','164827','164919','164932','165081','165110','165134','165177','165178','165394','165518','165532','165679','165723','165748','165934','166202','166203','166340','166539','166600','166624','166625','166652','166736','166793','166887','166889','166930','166963','167219','167294','167298','167474','167641','167739','167740','167960','168012','168047','168057','168082','168088','168089','168387','219749','232428','232498','232499','232536','232540','232586','232602','232687','232773','232774','232775','232776','238207','238208','238263','238264','238265','238297','238551','238622','238723','238724','238832','238839','238957','238958','239166','239198','239572','239627','239878','240072','240344','240505','240513','240634','240875','240876','240877','240930','241077','241078','241079','241159','241564','241632','242011','242012','242013','242017','242018','242019','242020','242266','242331','242332','242361','242364','242365','242404','242458','242499','242500','242545','242587','242784','243045','243070','243071','243106','243129','243279','243280','243281','243282','243375','243376','243600','243708','243930','244106','244324','244719','244724','244732','244990','245071','245093','245170','245380','245381','245520','245544','245854','246445','246472','246583','246584','246585','246586','246682','246831','247151','247211','247471','247620','247781','248016','248110','248134','248167','248257','248260','248261','248362','248669','248670','248687','249104','249105','249108','249435','249436','249468','249469','249470','249550','249553','249593','249594','249601','249602','249603','249671','249692','249693','249853','250043','250292','250599','250648','250649','250698','250764','250831','251280','251539','251554','251555','251556','251557','251575','251688','251787','251812','251850','251963','251964','252144','252145','252147','252160','252161','252215','252238','253122','253161','253163','253547','253590','253629','253880','254241','254242','254313','254421','254477','254545','254558','254637','254974','254977','254978','254979','255194','255195','255343','255436','255580','255668','255816','255817','255837','255949','256058','256060','256061','256082','256524','256525','256548','256577','256585','256926','257131','257132','257149','257152','262067','262109','262315','262415','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262517','262521','262565','262720','262721','262854','262880','262888','262889','262937','262949','262950','262951','262952','262953','262954','262955','262995','263491','263683','264401','264438','264503','264504','264505','264894','264895','264932','265239','265297','265298','265299','265300','265331','265342','265465','265480','265481','265482','265483','265704','265746','266005','266051','266052','266077','266253','266270','266426','266427','266428','266666','266715','266771','266833','266834','266835','266839','267073','267265','267291','267292','267580','267663','267718','267944','267945','267946','267947','268152','268348','268522','268535','268561','268595','268751','268816','268817','268818','268819','268820','268821','268822','268823','268824','268832','269028','269093','269113','269422','269512','269513','269514','269525','269749','273350','273472','273728','273729','273730','273738','273739','273740','273851','273911','273920','273948','274097','274133','274290','274439','274440','274722','274804','275000','275025','275048','275049','275200','275214','275220','275474','275476','275740','275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275909','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','276132','276149','276363','276364','276421','276435','276520','276633','276779','276972','276973','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277097','277098','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','277533','277587','277589','277866','277915','277916','277919','277961','277962','277995','277999','278221','278277','278472','278585','278586','278650','278651','278652','278653','278654','278732','278824','278825','278826','278827','278828','278829','278830','278888','279029','279033','279131','279401','279460','279461','279514','279667','280290','280504','280505','280508','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280712','280736','280737','280738','280740','280743','280799','280800','280808','280824','281144','281145','281146','281150','281151','281244','281245','281409','281410','281620','281680','281733','281758','281759','281791','281901','282008','282060','282086','282087','282171','282190','282438','282569','282570','282786','282787','282788','282791','282794','282795','283179','283180','283353','283551','283552','283597','283598','283599','283600','283736','283737','284145','284150','284158','284159','284160','284168','284182','284334','284446','284447','284500','284504','284505','284506','284507','284520','284521','284524','284528','284604','284949','284997','285233','285257','285275','285325','285412','285429','285445','285556','285559','285579','285670','285707','285836','285837','285838','285839','285840','285841','285842','285843','285899','286031','286032','286125','286147','286148','286149','286150','286151','286225','286273','286305','286306','286307','286335','286336','286387','286619','286620','286665','286801','286868','286883','286884','286911','286922','286991','287099','287123','287161','287214','287215','287216','287217','288011','288074','288100','288196','288202','288309','288377','288380','288381','288383','288384','288385','288502','288561','288562','288563','288661','288825','288826','288827','288828','288831','288832','288897','289007','289187','289278','289279','289396','289435','289441','291595','291596','291598','291691','291692','291693','291694','291695','291724','291805','291807','291853','291954','292094','292223','292244','292262','292263','292264','292268','292269','292336','292360','292365','292403','292429','292491','292523','292524','292594','292635','292636','292771','292839','292852','292859','292861','293208','293231','293286','293416','293433','293501','293563','293581','293660','293661','293662','293663','293664','293665','293666','293667','293668','293669','293670','293671','293672','293673','293674','293675','293676','293677','293678','293679','293680','293681','293682','293683','293684','293685','293686','293687','293688','293689','293690','293691','293692','293693','293694','293695','293696','293697','293698','293699','293700','293701','293702','293703','293704','293705','293706','293707','293708','293709','293710','293711','293712','293713','293714','293715','293716','293717','293718','293719','293720','293721','293722','293723','293724','293725','293726','293727','293728','293729','293730','293731','293732','293733','293734','293735','293736','293737','293738','293739','293740','293741','293742','293743','293744','293745','293746','293747','293748','293749','293750','293751','293752','293753','293754','293755','293756','293757','293758','293759','293760','293761','293762','293763','293764','293765','293766','293767','293768','293769','293770','293771','293772','293773','293774','293775','293776','293777','293778','293779','293780','293781','293782','293783','293784','293785','293786','293787','293788','293789','293790','293791','293792','293793','293794','293795','293796','293797','293798','293799','293800','293801','293802','293803','293804','293805','293806','293807','293808','293809','293810','293811','293812','293813','293814','293815','293816','293817','293818','293819','293820','293821','293822','293823','293824','293825','293826','293827','293828','293829','293830','293831','293832','293833','293834','293835','293836','293837','293838','293839','293840','293841','293842','293843','293844','293845','293846','293847','293848','293849','293850','294017','294042','294059','294333','294571','294590','294684','294704','294705','294706','294707','294723','294752','294753','294812','294815','294978','295330','295359','295360','295456','295477','295490','295491','295507','295528','295530','295531','295549','295550','295551','295552','295553','295573','295579','295605','295606','295629','295635','295756','295757','295758','295807','295809','295862','295981','295999','296206','296235','296258','296286','297106','297158','297162','297213','297448','297463','297512','297539','297561','297579','297721','297733','297754','297780','297983','297984','297985','297996','297997','298059','298112','298114','298170','298241','298266','298270','298271','298276','298283','298284','298412','298445','298532','298538','298539','298581','299101','299203','299283','299503','299515','299516','299517','299518','299519','299520','299521','299556','299557','299705','299706','299707','299712','299713','299714','299715','299732','299743','299766','299836','299837','299838','299845','299861','299862','299897','299904','299905','299910','299912','299913','299914','299921','299929','299984','299997','300004','300037','300049','300272','300301','300303','300308','300398','300522','300533','300644','300651','300653','300654','300705','300715','300904','300948','300949','300950','300951','300952','300953','300954','300955','300956','300957','300958','300959','300960','300961','300962','300963','300964','300965','300966','300967','300968','300969','300970','300971','300972','300973','300974','300975','300976','300977','300978','300979','300980','300981','300982','300983','300984','300985','300986','300987','300988','300989','300996','301003','301004','301010','301017','301050','301051','301052','301059','301062','301063','301064','301822','301836','301842','301843','301844','301847','301848','301858','301862','301877','301882','301913','301922','301923','301925','301969','301977','302057','302100','302125','302130','302154','302157','302158','302179','302180','302197','302202','302206','302207','302220','302307','302323','302325','302326','302356','302360','302365','303822','303843','303861','303924','303925','303958','303960','303961','303962','303963','303964') GROUP BY `montage2` ORDER BY `montage2` ASC
childsstroke1: montage2
SELECT `montage2`,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 `montage2` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `montage2` ORDER BY `montage2` ASC
childsstroke: kol_kon
SELECT `kol_kon`,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 `kol_kon` !='' AND `modx_site_content`.`id` IN ('153062','153076','153077','153079','153097','153103','153105','153118','153121','153122','153198','153199','153200','153203','153204','153209','153210','153299','153302','153303','153304','153307','153370','153375','153384','153385','153386','153387','153388','153446','153447','153448','153546','153571','153577','153591','153592','153598','153599','153762','153793','153794','153949','153950','154529','154530','154533','154567','154719','154759','154884','154885','154886','154895','155159','155160','155161','155199','155219','155220','155221','155222','155223','155224','155246','155277','155465','155560','155707','155718','156598','156599','156600','156601','156602','156603','156604','156605','156606','156607','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','157553','157630','157631','157667','157699','158000','158005','158022','158023','158247','158262','158263','158530','158616','158692','158742','158743','158767','159106','159153','159154','159155','159156','159206','159439','159606','159675','159707','159979','159994','159995','160136','160137','160239','160252','160300','160303','160365','160366','160401','160482','160560','160582','160756','160829','161233','161234','161235','161236','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161531','161708','161709','161738','161812','162034','162068','162097','162098','162100','162206','162216','162217','162224','162295','162298','162418','162563','162655','162695','162748','162871','163100','163101','163149','163527','163707','163918','163919','163920','163930','163946','163963','163982','164129','164136','164268','164281','164360','164388','164389','164440','164458','164459','164643','164668','164772','164773','164774','164775','164827','164919','164932','165081','165110','165134','165177','165178','165394','165518','165532','165679','165723','165748','165934','166202','166203','166340','166539','166600','166624','166625','166652','166736','166793','166887','166889','166930','166963','167219','167294','167298','167474','167641','167739','167740','167960','168012','168047','168057','168082','168088','168089','168387','219749','232428','232498','232499','232536','232540','232586','232602','232687','232773','232774','232775','232776','238207','238208','238263','238264','238265','238297','238551','238622','238723','238724','238832','238839','238957','238958','239166','239198','239572','239627','239878','240072','240344','240505','240513','240634','240875','240876','240877','240930','241077','241078','241079','241159','241564','241632','242011','242012','242013','242017','242018','242019','242020','242266','242331','242332','242361','242364','242365','242404','242458','242499','242500','242545','242587','242784','243045','243070','243071','243106','243129','243279','243280','243281','243282','243375','243376','243600','243708','243930','244106','244324','244719','244724','244732','244990','245071','245093','245170','245380','245381','245520','245544','245854','246445','246472','246583','246584','246585','246586','246682','246831','247151','247211','247471','247620','247781','248016','248110','248134','248167','248257','248260','248261','248362','248669','248670','248687','249104','249105','249108','249435','249436','249468','249469','249470','249550','249553','249593','249594','249601','249602','249603','249671','249692','249693','249853','250043','250292','250599','250648','250649','250698','250764','250831','251280','251539','251554','251555','251556','251557','251575','251688','251787','251812','251850','251963','251964','252144','252145','252147','252160','252161','252215','252238','253122','253161','253163','253547','253590','253629','253880','254241','254242','254313','254421','254477','254545','254558','254637','254974','254977','254978','254979','255194','255195','255343','255436','255580','255668','255816','255817','255837','255949','256058','256060','256061','256082','256524','256525','256548','256577','256585','256926','257131','257132','257149','257152','262067','262109','262315','262415','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262517','262521','262565','262720','262721','262854','262880','262888','262889','262937','262949','262950','262951','262952','262953','262954','262955','262995','263491','263683','264401','264438','264503','264504','264505','264894','264895','264932','265239','265297','265298','265299','265300','265331','265342','265465','265480','265481','265482','265483','265704','265746','266005','266051','266052','266077','266253','266270','266426','266427','266428','266666','266715','266771','266833','266834','266835','266839','267073','267265','267291','267292','267580','267663','267718','267944','267945','267946','267947','268152','268348','268522','268535','268561','268595','268751','268816','268817','268818','268819','268820','268821','268822','268823','268824','268832','269028','269093','269113','269422','269512','269513','269514','269525','269749','273350','273472','273728','273729','273730','273738','273739','273740','273851','273911','273920','273948','274097','274133','274290','274439','274440','274722','274804','275000','275025','275048','275049','275200','275214','275220','275474','275476','275740','275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275909','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','276132','276149','276363','276364','276421','276435','276520','276633','276779','276972','276973','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277097','277098','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','277533','277587','277589','277866','277915','277916','277919','277961','277962','277995','277999','278221','278277','278472','278585','278586','278650','278651','278652','278653','278654','278732','278824','278825','278826','278827','278828','278829','278830','278888','279029','279033','279131','279401','279460','279461','279514','279667','280290','280504','280505','280508','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280712','280736','280737','280738','280740','280743','280799','280800','280808','280824','281144','281145','281146','281150','281151','281244','281245','281409','281410','281620','281680','281733','281758','281759','281791','281901','282008','282060','282086','282087','282171','282190','282438','282569','282570','282786','282787','282788','282791','282794','282795','283179','283180','283353','283551','283552','283597','283598','283599','283600','283736','283737','284145','284150','284158','284159','284160','284168','284182','284334','284446','284447','284500','284504','284505','284506','284507','284520','284521','284524','284528','284604','284949','284997','285233','285257','285275','285325','285412','285429','285445','285556','285559','285579','285670','285707','285836','285837','285838','285839','285840','285841','285842','285843','285899','286031','286032','286125','286147','286148','286149','286150','286151','286225','286273','286305','286306','286307','286335','286336','286387','286619','286620','286665','286801','286868','286883','286884','286911','286922','286991','287099','287123','287161','287214','287215','287216','287217','288011','288074','288100','288196','288202','288309','288377','288380','288381','288383','288384','288385','288502','288561','288562','288563','288661','288825','288826','288827','288828','288831','288832','288897','289007','289187','289278','289279','289396','289435','289441','291595','291596','291598','291691','291692','291693','291694','291695','291724','291805','291807','291853','291954','292094','292223','292244','292262','292263','292264','292268','292269','292336','292360','292365','292403','292429','292491','292523','292524','292594','292635','292636','292771','292839','292852','292859','292861','293208','293231','293286','293416','293433','293501','293563','293581','293660','293661','293662','293663','293664','293665','293666','293667','293668','293669','293670','293671','293672','293673','293674','293675','293676','293677','293678','293679','293680','293681','293682','293683','293684','293685','293686','293687','293688','293689','293690','293691','293692','293693','293694','293695','293696','293697','293698','293699','293700','293701','293702','293703','293704','293705','293706','293707','293708','293709','293710','293711','293712','293713','293714','293715','293716','293717','293718','293719','293720','293721','293722','293723','293724','293725','293726','293727','293728','293729','293730','293731','293732','293733','293734','293735','293736','293737','293738','293739','293740','293741','293742','293743','293744','293745','293746','293747','293748','293749','293750','293751','293752','293753','293754','293755','293756','293757','293758','293759','293760','293761','293762','293763','293764','293765','293766','293767','293768','293769','293770','293771','293772','293773','293774','293775','293776','293777','293778','293779','293780','293781','293782','293783','293784','293785','293786','293787','293788','293789','293790','293791','293792','293793','293794','293795','293796','293797','293798','293799','293800','293801','293802','293803','293804','293805','293806','293807','293808','293809','293810','293811','293812','293813','293814','293815','293816','293817','293818','293819','293820','293821','293822','293823','293824','293825','293826','293827','293828','293829','293830','293831','293832','293833','293834','293835','293836','293837','293838','293839','293840','293841','293842','293843','293844','293845','293846','293847','293848','293849','293850','294017','294042','294059','294333','294571','294590','294684','294704','294705','294706','294707','294723','294752','294753','294812','294815','294978','295330','295359','295360','295456','295477','295490','295491','295507','295528','295530','295531','295549','295550','295551','295552','295553','295573','295579','295605','295606','295629','295635','295756','295757','295758','295807','295809','295862','295981','295999','296206','296235','296258','296286','297106','297158','297162','297213','297448','297463','297512','297539','297561','297579','297721','297733','297754','297780','297983','297984','297985','297996','297997','298059','298112','298114','298170','298241','298266','298270','298271','298276','298283','298284','298412','298445','298532','298538','298539','298581','299101','299203','299283','299503','299515','299516','299517','299518','299519','299520','299521','299556','299557','299705','299706','299707','299712','299713','299714','299715','299732','299743','299766','299836','299837','299838','299845','299861','299862','299897','299904','299905','299910','299912','299913','299914','299921','299929','299984','299997','300004','300037','300049','300272','300301','300303','300308','300398','300522','300533','300644','300651','300653','300654','300705','300715','300904','300948','300949','300950','300951','300952','300953','300954','300955','300956','300957','300958','300959','300960','300961','300962','300963','300964','300965','300966','300967','300968','300969','300970','300971','300972','300973','300974','300975','300976','300977','300978','300979','300980','300981','300982','300983','300984','300985','300986','300987','300988','300989','300996','301003','301004','301010','301017','301050','301051','301052','301059','301062','301063','301064','301822','301836','301842','301843','301844','301847','301848','301858','301862','301877','301882','301913','301922','301923','301925','301969','301977','302057','302100','302125','302130','302154','302157','302158','302179','302180','302197','302202','302206','302207','302220','302307','302323','302325','302326','302356','302360','302365','303822','303843','303861','303924','303925','303958','303960','303961','303962','303963','303964') GROUP BY `kol_kon` ORDER BY `kol_kon` ASC
childsstroke1: kol_kon
SELECT `kol_kon`,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 `kol_kon` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `kol_kon` ORDER BY `kol_kon` ASC
childsstroke: tip
SELECT `tip`,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 `tip` !='' AND `modx_site_content`.`id` IN ('153062','153076','153077','153079','153097','153103','153105','153118','153121','153122','153198','153199','153200','153203','153204','153209','153210','153299','153302','153303','153304','153307','153370','153375','153384','153385','153386','153387','153388','153446','153447','153448','153546','153571','153577','153591','153592','153598','153599','153762','153793','153794','153949','153950','154529','154530','154533','154567','154719','154759','154884','154885','154886','154895','155159','155160','155161','155199','155219','155220','155221','155222','155223','155224','155246','155277','155465','155560','155707','155718','156598','156599','156600','156601','156602','156603','156604','156605','156606','156607','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','157553','157630','157631','157667','157699','158000','158005','158022','158023','158247','158262','158263','158530','158616','158692','158742','158743','158767','159106','159153','159154','159155','159156','159206','159439','159606','159675','159707','159979','159994','159995','160136','160137','160239','160252','160300','160303','160365','160366','160401','160482','160560','160582','160756','160829','161233','161234','161235','161236','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161531','161708','161709','161738','161812','162034','162068','162097','162098','162100','162206','162216','162217','162224','162295','162298','162418','162563','162655','162695','162748','162871','163100','163101','163149','163527','163707','163918','163919','163920','163930','163946','163963','163982','164129','164136','164268','164281','164360','164388','164389','164440','164458','164459','164643','164668','164772','164773','164774','164775','164827','164919','164932','165081','165110','165134','165177','165178','165394','165518','165532','165679','165723','165748','165934','166202','166203','166340','166539','166600','166624','166625','166652','166736','166793','166887','166889','166930','166963','167219','167294','167298','167474','167641','167739','167740','167960','168012','168047','168057','168082','168088','168089','168387','219749','232428','232498','232499','232536','232540','232586','232602','232687','232773','232774','232775','232776','238207','238208','238263','238264','238265','238297','238551','238622','238723','238724','238832','238839','238957','238958','239166','239198','239572','239627','239878','240072','240344','240505','240513','240634','240875','240876','240877','240930','241077','241078','241079','241159','241564','241632','242011','242012','242013','242017','242018','242019','242020','242266','242331','242332','242361','242364','242365','242404','242458','242499','242500','242545','242587','242784','243045','243070','243071','243106','243129','243279','243280','243281','243282','243375','243376','243600','243708','243930','244106','244324','244719','244724','244732','244990','245071','245093','245170','245380','245381','245520','245544','245854','246445','246472','246583','246584','246585','246586','246682','246831','247151','247211','247471','247620','247781','248016','248110','248134','248167','248257','248260','248261','248362','248669','248670','248687','249104','249105','249108','249435','249436','249468','249469','249470','249550','249553','249593','249594','249601','249602','249603','249671','249692','249693','249853','250043','250292','250599','250648','250649','250698','250764','250831','251280','251539','251554','251555','251556','251557','251575','251688','251787','251812','251850','251963','251964','252144','252145','252147','252160','252161','252215','252238','253122','253161','253163','253547','253590','253629','253880','254241','254242','254313','254421','254477','254545','254558','254637','254974','254977','254978','254979','255194','255195','255343','255436','255580','255668','255816','255817','255837','255949','256058','256060','256061','256082','256524','256525','256548','256577','256585','256926','257131','257132','257149','257152','262067','262109','262315','262415','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262517','262521','262565','262720','262721','262854','262880','262888','262889','262937','262949','262950','262951','262952','262953','262954','262955','262995','263491','263683','264401','264438','264503','264504','264505','264894','264895','264932','265239','265297','265298','265299','265300','265331','265342','265465','265480','265481','265482','265483','265704','265746','266005','266051','266052','266077','266253','266270','266426','266427','266428','266666','266715','266771','266833','266834','266835','266839','267073','267265','267291','267292','267580','267663','267718','267944','267945','267946','267947','268152','268348','268522','268535','268561','268595','268751','268816','268817','268818','268819','268820','268821','268822','268823','268824','268832','269028','269093','269113','269422','269512','269513','269514','269525','269749','273350','273472','273728','273729','273730','273738','273739','273740','273851','273911','273920','273948','274097','274133','274290','274439','274440','274722','274804','275000','275025','275048','275049','275200','275214','275220','275474','275476','275740','275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275909','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','276132','276149','276363','276364','276421','276435','276520','276633','276779','276972','276973','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277097','277098','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','277533','277587','277589','277866','277915','277916','277919','277961','277962','277995','277999','278221','278277','278472','278585','278586','278650','278651','278652','278653','278654','278732','278824','278825','278826','278827','278828','278829','278830','278888','279029','279033','279131','279401','279460','279461','279514','279667','280290','280504','280505','280508','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280712','280736','280737','280738','280740','280743','280799','280800','280808','280824','281144','281145','281146','281150','281151','281244','281245','281409','281410','281620','281680','281733','281758','281759','281791','281901','282008','282060','282086','282087','282171','282190','282438','282569','282570','282786','282787','282788','282791','282794','282795','283179','283180','283353','283551','283552','283597','283598','283599','283600','283736','283737','284145','284150','284158','284159','284160','284168','284182','284334','284446','284447','284500','284504','284505','284506','284507','284520','284521','284524','284528','284604','284949','284997','285233','285257','285275','285325','285412','285429','285445','285556','285559','285579','285670','285707','285836','285837','285838','285839','285840','285841','285842','285843','285899','286031','286032','286125','286147','286148','286149','286150','286151','286225','286273','286305','286306','286307','286335','286336','286387','286619','286620','286665','286801','286868','286883','286884','286911','286922','286991','287099','287123','287161','287214','287215','287216','287217','288011','288074','288100','288196','288202','288309','288377','288380','288381','288383','288384','288385','288502','288561','288562','288563','288661','288825','288826','288827','288828','288831','288832','288897','289007','289187','289278','289279','289396','289435','289441','291595','291596','291598','291691','291692','291693','291694','291695','291724','291805','291807','291853','291954','292094','292223','292244','292262','292263','292264','292268','292269','292336','292360','292365','292403','292429','292491','292523','292524','292594','292635','292636','292771','292839','292852','292859','292861','293208','293231','293286','293416','293433','293501','293563','293581','293660','293661','293662','293663','293664','293665','293666','293667','293668','293669','293670','293671','293672','293673','293674','293675','293676','293677','293678','293679','293680','293681','293682','293683','293684','293685','293686','293687','293688','293689','293690','293691','293692','293693','293694','293695','293696','293697','293698','293699','293700','293701','293702','293703','293704','293705','293706','293707','293708','293709','293710','293711','293712','293713','293714','293715','293716','293717','293718','293719','293720','293721','293722','293723','293724','293725','293726','293727','293728','293729','293730','293731','293732','293733','293734','293735','293736','293737','293738','293739','293740','293741','293742','293743','293744','293745','293746','293747','293748','293749','293750','293751','293752','293753','293754','293755','293756','293757','293758','293759','293760','293761','293762','293763','293764','293765','293766','293767','293768','293769','293770','293771','293772','293773','293774','293775','293776','293777','293778','293779','293780','293781','293782','293783','293784','293785','293786','293787','293788','293789','293790','293791','293792','293793','293794','293795','293796','293797','293798','293799','293800','293801','293802','293803','293804','293805','293806','293807','293808','293809','293810','293811','293812','293813','293814','293815','293816','293817','293818','293819','293820','293821','293822','293823','293824','293825','293826','293827','293828','293829','293830','293831','293832','293833','293834','293835','293836','293837','293838','293839','293840','293841','293842','293843','293844','293845','293846','293847','293848','293849','293850','294017','294042','294059','294333','294571','294590','294684','294704','294705','294706','294707','294723','294752','294753','294812','294815','294978','295330','295359','295360','295456','295477','295490','295491','295507','295528','295530','295531','295549','295550','295551','295552','295553','295573','295579','295605','295606','295629','295635','295756','295757','295758','295807','295809','295862','295981','295999','296206','296235','296258','296286','297106','297158','297162','297213','297448','297463','297512','297539','297561','297579','297721','297733','297754','297780','297983','297984','297985','297996','297997','298059','298112','298114','298170','298241','298266','298270','298271','298276','298283','298284','298412','298445','298532','298538','298539','298581','299101','299203','299283','299503','299515','299516','299517','299518','299519','299520','299521','299556','299557','299705','299706','299707','299712','299713','299714','299715','299732','299743','299766','299836','299837','299838','299845','299861','299862','299897','299904','299905','299910','299912','299913','299914','299921','299929','299984','299997','300004','300037','300049','300272','300301','300303','300308','300398','300522','300533','300644','300651','300653','300654','300705','300715','300904','300948','300949','300950','300951','300952','300953','300954','300955','300956','300957','300958','300959','300960','300961','300962','300963','300964','300965','300966','300967','300968','300969','300970','300971','300972','300973','300974','300975','300976','300977','300978','300979','300980','300981','300982','300983','300984','300985','300986','300987','300988','300989','300996','301003','301004','301010','301017','301050','301051','301052','301059','301062','301063','301064','301822','301836','301842','301843','301844','301847','301848','301858','301862','301877','301882','301913','301922','301923','301925','301969','301977','302057','302100','302125','302130','302154','302157','302158','302179','302180','302197','302202','302206','302207','302220','302307','302323','302325','302326','302356','302360','302365','303822','303843','303861','303924','303925','303958','303960','303961','303962','303963','303964') GROUP BY `tip` ORDER BY `tip` ASC
childsstroke1: tip
SELECT `tip`,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 `tip` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `tip` ORDER BY `tip` ASC
childsstroke: step
SELECT `step`,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 `step` !='' AND `modx_site_content`.`id` IN ('153062','153076','153077','153079','153097','153103','153105','153118','153121','153122','153198','153199','153200','153203','153204','153209','153210','153299','153302','153303','153304','153307','153370','153375','153384','153385','153386','153387','153388','153446','153447','153448','153546','153571','153577','153591','153592','153598','153599','153762','153793','153794','153949','153950','154529','154530','154533','154567','154719','154759','154884','154885','154886','154895','155159','155160','155161','155199','155219','155220','155221','155222','155223','155224','155246','155277','155465','155560','155707','155718','156598','156599','156600','156601','156602','156603','156604','156605','156606','156607','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','157553','157630','157631','157667','157699','158000','158005','158022','158023','158247','158262','158263','158530','158616','158692','158742','158743','158767','159106','159153','159154','159155','159156','159206','159439','159606','159675','159707','159979','159994','159995','160136','160137','160239','160252','160300','160303','160365','160366','160401','160482','160560','160582','160756','160829','161233','161234','161235','161236','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161531','161708','161709','161738','161812','162034','162068','162097','162098','162100','162206','162216','162217','162224','162295','162298','162418','162563','162655','162695','162748','162871','163100','163101','163149','163527','163707','163918','163919','163920','163930','163946','163963','163982','164129','164136','164268','164281','164360','164388','164389','164440','164458','164459','164643','164668','164772','164773','164774','164775','164827','164919','164932','165081','165110','165134','165177','165178','165394','165518','165532','165679','165723','165748','165934','166202','166203','166340','166539','166600','166624','166625','166652','166736','166793','166887','166889','166930','166963','167219','167294','167298','167474','167641','167739','167740','167960','168012','168047','168057','168082','168088','168089','168387','219749','232428','232498','232499','232536','232540','232586','232602','232687','232773','232774','232775','232776','238207','238208','238263','238264','238265','238297','238551','238622','238723','238724','238832','238839','238957','238958','239166','239198','239572','239627','239878','240072','240344','240505','240513','240634','240875','240876','240877','240930','241077','241078','241079','241159','241564','241632','242011','242012','242013','242017','242018','242019','242020','242266','242331','242332','242361','242364','242365','242404','242458','242499','242500','242545','242587','242784','243045','243070','243071','243106','243129','243279','243280','243281','243282','243375','243376','243600','243708','243930','244106','244324','244719','244724','244732','244990','245071','245093','245170','245380','245381','245520','245544','245854','246445','246472','246583','246584','246585','246586','246682','246831','247151','247211','247471','247620','247781','248016','248110','248134','248167','248257','248260','248261','248362','248669','248670','248687','249104','249105','249108','249435','249436','249468','249469','249470','249550','249553','249593','249594','249601','249602','249603','249671','249692','249693','249853','250043','250292','250599','250648','250649','250698','250764','250831','251280','251539','251554','251555','251556','251557','251575','251688','251787','251812','251850','251963','251964','252144','252145','252147','252160','252161','252215','252238','253122','253161','253163','253547','253590','253629','253880','254241','254242','254313','254421','254477','254545','254558','254637','254974','254977','254978','254979','255194','255195','255343','255436','255580','255668','255816','255817','255837','255949','256058','256060','256061','256082','256524','256525','256548','256577','256585','256926','257131','257132','257149','257152','262067','262109','262315','262415','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262517','262521','262565','262720','262721','262854','262880','262888','262889','262937','262949','262950','262951','262952','262953','262954','262955','262995','263491','263683','264401','264438','264503','264504','264505','264894','264895','264932','265239','265297','265298','265299','265300','265331','265342','265465','265480','265481','265482','265483','265704','265746','266005','266051','266052','266077','266253','266270','266426','266427','266428','266666','266715','266771','266833','266834','266835','266839','267073','267265','267291','267292','267580','267663','267718','267944','267945','267946','267947','268152','268348','268522','268535','268561','268595','268751','268816','268817','268818','268819','268820','268821','268822','268823','268824','268832','269028','269093','269113','269422','269512','269513','269514','269525','269749','273350','273472','273728','273729','273730','273738','273739','273740','273851','273911','273920','273948','274097','274133','274290','274439','274440','274722','274804','275000','275025','275048','275049','275200','275214','275220','275474','275476','275740','275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275909','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','276132','276149','276363','276364','276421','276435','276520','276633','276779','276972','276973','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277097','277098','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','277533','277587','277589','277866','277915','277916','277919','277961','277962','277995','277999','278221','278277','278472','278585','278586','278650','278651','278652','278653','278654','278732','278824','278825','278826','278827','278828','278829','278830','278888','279029','279033','279131','279401','279460','279461','279514','279667','280290','280504','280505','280508','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280712','280736','280737','280738','280740','280743','280799','280800','280808','280824','281144','281145','281146','281150','281151','281244','281245','281409','281410','281620','281680','281733','281758','281759','281791','281901','282008','282060','282086','282087','282171','282190','282438','282569','282570','282786','282787','282788','282791','282794','282795','283179','283180','283353','283551','283552','283597','283598','283599','283600','283736','283737','284145','284150','284158','284159','284160','284168','284182','284334','284446','284447','284500','284504','284505','284506','284507','284520','284521','284524','284528','284604','284949','284997','285233','285257','285275','285325','285412','285429','285445','285556','285559','285579','285670','285707','285836','285837','285838','285839','285840','285841','285842','285843','285899','286031','286032','286125','286147','286148','286149','286150','286151','286225','286273','286305','286306','286307','286335','286336','286387','286619','286620','286665','286801','286868','286883','286884','286911','286922','286991','287099','287123','287161','287214','287215','287216','287217','288011','288074','288100','288196','288202','288309','288377','288380','288381','288383','288384','288385','288502','288561','288562','288563','288661','288825','288826','288827','288828','288831','288832','288897','289007','289187','289278','289279','289396','289435','289441','291595','291596','291598','291691','291692','291693','291694','291695','291724','291805','291807','291853','291954','292094','292223','292244','292262','292263','292264','292268','292269','292336','292360','292365','292403','292429','292491','292523','292524','292594','292635','292636','292771','292839','292852','292859','292861','293208','293231','293286','293416','293433','293501','293563','293581','293660','293661','293662','293663','293664','293665','293666','293667','293668','293669','293670','293671','293672','293673','293674','293675','293676','293677','293678','293679','293680','293681','293682','293683','293684','293685','293686','293687','293688','293689','293690','293691','293692','293693','293694','293695','293696','293697','293698','293699','293700','293701','293702','293703','293704','293705','293706','293707','293708','293709','293710','293711','293712','293713','293714','293715','293716','293717','293718','293719','293720','293721','293722','293723','293724','293725','293726','293727','293728','293729','293730','293731','293732','293733','293734','293735','293736','293737','293738','293739','293740','293741','293742','293743','293744','293745','293746','293747','293748','293749','293750','293751','293752','293753','293754','293755','293756','293757','293758','293759','293760','293761','293762','293763','293764','293765','293766','293767','293768','293769','293770','293771','293772','293773','293774','293775','293776','293777','293778','293779','293780','293781','293782','293783','293784','293785','293786','293787','293788','293789','293790','293791','293792','293793','293794','293795','293796','293797','293798','293799','293800','293801','293802','293803','293804','293805','293806','293807','293808','293809','293810','293811','293812','293813','293814','293815','293816','293817','293818','293819','293820','293821','293822','293823','293824','293825','293826','293827','293828','293829','293830','293831','293832','293833','293834','293835','293836','293837','293838','293839','293840','293841','293842','293843','293844','293845','293846','293847','293848','293849','293850','294017','294042','294059','294333','294571','294590','294684','294704','294705','294706','294707','294723','294752','294753','294812','294815','294978','295330','295359','295360','295456','295477','295490','295491','295507','295528','295530','295531','295549','295550','295551','295552','295553','295573','295579','295605','295606','295629','295635','295756','295757','295758','295807','295809','295862','295981','295999','296206','296235','296258','296286','297106','297158','297162','297213','297448','297463','297512','297539','297561','297579','297721','297733','297754','297780','297983','297984','297985','297996','297997','298059','298112','298114','298170','298241','298266','298270','298271','298276','298283','298284','298412','298445','298532','298538','298539','298581','299101','299203','299283','299503','299515','299516','299517','299518','299519','299520','299521','299556','299557','299705','299706','299707','299712','299713','299714','299715','299732','299743','299766','299836','299837','299838','299845','299861','299862','299897','299904','299905','299910','299912','299913','299914','299921','299929','299984','299997','300004','300037','300049','300272','300301','300303','300308','300398','300522','300533','300644','300651','300653','300654','300705','300715','300904','300948','300949','300950','300951','300952','300953','300954','300955','300956','300957','300958','300959','300960','300961','300962','300963','300964','300965','300966','300967','300968','300969','300970','300971','300972','300973','300974','300975','300976','300977','300978','300979','300980','300981','300982','300983','300984','300985','300986','300987','300988','300989','300996','301003','301004','301010','301017','301050','301051','301052','301059','301062','301063','301064','301822','301836','301842','301843','301844','301847','301848','301858','301862','301877','301882','301913','301922','301923','301925','301969','301977','302057','302100','302125','302130','302154','302157','302158','302179','302180','302197','302202','302206','302207','302220','302307','302323','302325','302326','302356','302360','302365','303822','303843','303861','303924','303925','303958','303960','303961','303962','303963','303964') GROUP BY `step` ORDER BY `step` ASC
childsstroke1: step
SELECT `step`,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 `step` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `step` ORDER BY `step` ASC
childsstroke: color
SELECT `color`,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 `color` !='' AND `modx_site_content`.`id` IN ('153062','153076','153077','153079','153097','153103','153105','153118','153121','153122','153198','153199','153200','153203','153204','153209','153210','153299','153302','153303','153304','153307','153370','153375','153384','153385','153386','153387','153388','153446','153447','153448','153546','153571','153577','153591','153592','153598','153599','153762','153793','153794','153949','153950','154529','154530','154533','154567','154719','154759','154884','154885','154886','154895','155159','155160','155161','155199','155219','155220','155221','155222','155223','155224','155246','155277','155465','155560','155707','155718','156598','156599','156600','156601','156602','156603','156604','156605','156606','156607','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','157553','157630','157631','157667','157699','158000','158005','158022','158023','158247','158262','158263','158530','158616','158692','158742','158743','158767','159106','159153','159154','159155','159156','159206','159439','159606','159675','159707','159979','159994','159995','160136','160137','160239','160252','160300','160303','160365','160366','160401','160482','160560','160582','160756','160829','161233','161234','161235','161236','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161531','161708','161709','161738','161812','162034','162068','162097','162098','162100','162206','162216','162217','162224','162295','162298','162418','162563','162655','162695','162748','162871','163100','163101','163149','163527','163707','163918','163919','163920','163930','163946','163963','163982','164129','164136','164268','164281','164360','164388','164389','164440','164458','164459','164643','164668','164772','164773','164774','164775','164827','164919','164932','165081','165110','165134','165177','165178','165394','165518','165532','165679','165723','165748','165934','166202','166203','166340','166539','166600','166624','166625','166652','166736','166793','166887','166889','166930','166963','167219','167294','167298','167474','167641','167739','167740','167960','168012','168047','168057','168082','168088','168089','168387','219749','232428','232498','232499','232536','232540','232586','232602','232687','232773','232774','232775','232776','238207','238208','238263','238264','238265','238297','238551','238622','238723','238724','238832','238839','238957','238958','239166','239198','239572','239627','239878','240072','240344','240505','240513','240634','240875','240876','240877','240930','241077','241078','241079','241159','241564','241632','242011','242012','242013','242017','242018','242019','242020','242266','242331','242332','242361','242364','242365','242404','242458','242499','242500','242545','242587','242784','243045','243070','243071','243106','243129','243279','243280','243281','243282','243375','243376','243600','243708','243930','244106','244324','244719','244724','244732','244990','245071','245093','245170','245380','245381','245520','245544','245854','246445','246472','246583','246584','246585','246586','246682','246831','247151','247211','247471','247620','247781','248016','248110','248134','248167','248257','248260','248261','248362','248669','248670','248687','249104','249105','249108','249435','249436','249468','249469','249470','249550','249553','249593','249594','249601','249602','249603','249671','249692','249693','249853','250043','250292','250599','250648','250649','250698','250764','250831','251280','251539','251554','251555','251556','251557','251575','251688','251787','251812','251850','251963','251964','252144','252145','252147','252160','252161','252215','252238','253122','253161','253163','253547','253590','253629','253880','254241','254242','254313','254421','254477','254545','254558','254637','254974','254977','254978','254979','255194','255195','255343','255436','255580','255668','255816','255817','255837','255949','256058','256060','256061','256082','256524','256525','256548','256577','256585','256926','257131','257132','257149','257152','262067','262109','262315','262415','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262517','262521','262565','262720','262721','262854','262880','262888','262889','262937','262949','262950','262951','262952','262953','262954','262955','262995','263491','263683','264401','264438','264503','264504','264505','264894','264895','264932','265239','265297','265298','265299','265300','265331','265342','265465','265480','265481','265482','265483','265704','265746','266005','266051','266052','266077','266253','266270','266426','266427','266428','266666','266715','266771','266833','266834','266835','266839','267073','267265','267291','267292','267580','267663','267718','267944','267945','267946','267947','268152','268348','268522','268535','268561','268595','268751','268816','268817','268818','268819','268820','268821','268822','268823','268824','268832','269028','269093','269113','269422','269512','269513','269514','269525','269749','273350','273472','273728','273729','273730','273738','273739','273740','273851','273911','273920','273948','274097','274133','274290','274439','274440','274722','274804','275000','275025','275048','275049','275200','275214','275220','275474','275476','275740','275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275909','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','276132','276149','276363','276364','276421','276435','276520','276633','276779','276972','276973','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277097','277098','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','277533','277587','277589','277866','277915','277916','277919','277961','277962','277995','277999','278221','278277','278472','278585','278586','278650','278651','278652','278653','278654','278732','278824','278825','278826','278827','278828','278829','278830','278888','279029','279033','279131','279401','279460','279461','279514','279667','280290','280504','280505','280508','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280712','280736','280737','280738','280740','280743','280799','280800','280808','280824','281144','281145','281146','281150','281151','281244','281245','281409','281410','281620','281680','281733','281758','281759','281791','281901','282008','282060','282086','282087','282171','282190','282438','282569','282570','282786','282787','282788','282791','282794','282795','283179','283180','283353','283551','283552','283597','283598','283599','283600','283736','283737','284145','284150','284158','284159','284160','284168','284182','284334','284446','284447','284500','284504','284505','284506','284507','284520','284521','284524','284528','284604','284949','284997','285233','285257','285275','285325','285412','285429','285445','285556','285559','285579','285670','285707','285836','285837','285838','285839','285840','285841','285842','285843','285899','286031','286032','286125','286147','286148','286149','286150','286151','286225','286273','286305','286306','286307','286335','286336','286387','286619','286620','286665','286801','286868','286883','286884','286911','286922','286991','287099','287123','287161','287214','287215','287216','287217','288011','288074','288100','288196','288202','288309','288377','288380','288381','288383','288384','288385','288502','288561','288562','288563','288661','288825','288826','288827','288828','288831','288832','288897','289007','289187','289278','289279','289396','289435','289441','291595','291596','291598','291691','291692','291693','291694','291695','291724','291805','291807','291853','291954','292094','292223','292244','292262','292263','292264','292268','292269','292336','292360','292365','292403','292429','292491','292523','292524','292594','292635','292636','292771','292839','292852','292859','292861','293208','293231','293286','293416','293433','293501','293563','293581','293660','293661','293662','293663','293664','293665','293666','293667','293668','293669','293670','293671','293672','293673','293674','293675','293676','293677','293678','293679','293680','293681','293682','293683','293684','293685','293686','293687','293688','293689','293690','293691','293692','293693','293694','293695','293696','293697','293698','293699','293700','293701','293702','293703','293704','293705','293706','293707','293708','293709','293710','293711','293712','293713','293714','293715','293716','293717','293718','293719','293720','293721','293722','293723','293724','293725','293726','293727','293728','293729','293730','293731','293732','293733','293734','293735','293736','293737','293738','293739','293740','293741','293742','293743','293744','293745','293746','293747','293748','293749','293750','293751','293752','293753','293754','293755','293756','293757','293758','293759','293760','293761','293762','293763','293764','293765','293766','293767','293768','293769','293770','293771','293772','293773','293774','293775','293776','293777','293778','293779','293780','293781','293782','293783','293784','293785','293786','293787','293788','293789','293790','293791','293792','293793','293794','293795','293796','293797','293798','293799','293800','293801','293802','293803','293804','293805','293806','293807','293808','293809','293810','293811','293812','293813','293814','293815','293816','293817','293818','293819','293820','293821','293822','293823','293824','293825','293826','293827','293828','293829','293830','293831','293832','293833','293834','293835','293836','293837','293838','293839','293840','293841','293842','293843','293844','293845','293846','293847','293848','293849','293850','294017','294042','294059','294333','294571','294590','294684','294704','294705','294706','294707','294723','294752','294753','294812','294815','294978','295330','295359','295360','295456','295477','295490','295491','295507','295528','295530','295531','295549','295550','295551','295552','295553','295573','295579','295605','295606','295629','295635','295756','295757','295758','295807','295809','295862','295981','295999','296206','296235','296258','296286','297106','297158','297162','297213','297448','297463','297512','297539','297561','297579','297721','297733','297754','297780','297983','297984','297985','297996','297997','298059','298112','298114','298170','298241','298266','298270','298271','298276','298283','298284','298412','298445','298532','298538','298539','298581','299101','299203','299283','299503','299515','299516','299517','299518','299519','299520','299521','299556','299557','299705','299706','299707','299712','299713','299714','299715','299732','299743','299766','299836','299837','299838','299845','299861','299862','299897','299904','299905','299910','299912','299913','299914','299921','299929','299984','299997','300004','300037','300049','300272','300301','300303','300308','300398','300522','300533','300644','300651','300653','300654','300705','300715','300904','300948','300949','300950','300951','300952','300953','300954','300955','300956','300957','300958','300959','300960','300961','300962','300963','300964','300965','300966','300967','300968','300969','300970','300971','300972','300973','300974','300975','300976','300977','300978','300979','300980','300981','300982','300983','300984','300985','300986','300987','300988','300989','300996','301003','301004','301010','301017','301050','301051','301052','301059','301062','301063','301064','301822','301836','301842','301843','301844','301847','301848','301858','301862','301877','301882','301913','301922','301923','301925','301969','301977','302057','302100','302125','302130','302154','302157','302158','302179','302180','302197','302202','302206','302207','302220','302307','302323','302325','302326','302356','302360','302365','303822','303843','303861','303924','303925','303958','303960','303961','303962','303963','303964') GROUP BY `color` ORDER BY `color` ASC
childsstroke1: color
SELECT `color`,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 `color` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `color` ORDER BY `color` ASC
childsstroke: section
SELECT `section`,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 `section` !='' AND `modx_site_content`.`id` IN ('153062','153076','153077','153079','153097','153103','153105','153118','153121','153122','153198','153199','153200','153203','153204','153209','153210','153299','153302','153303','153304','153307','153370','153375','153384','153385','153386','153387','153388','153446','153447','153448','153546','153571','153577','153591','153592','153598','153599','153762','153793','153794','153949','153950','154529','154530','154533','154567','154719','154759','154884','154885','154886','154895','155159','155160','155161','155199','155219','155220','155221','155222','155223','155224','155246','155277','155465','155560','155707','155718','156598','156599','156600','156601','156602','156603','156604','156605','156606','156607','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','157553','157630','157631','157667','157699','158000','158005','158022','158023','158247','158262','158263','158530','158616','158692','158742','158743','158767','159106','159153','159154','159155','159156','159206','159439','159606','159675','159707','159979','159994','159995','160136','160137','160239','160252','160300','160303','160365','160366','160401','160482','160560','160582','160756','160829','161233','161234','161235','161236','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161531','161708','161709','161738','161812','162034','162068','162097','162098','162100','162206','162216','162217','162224','162295','162298','162418','162563','162655','162695','162748','162871','163100','163101','163149','163527','163707','163918','163919','163920','163930','163946','163963','163982','164129','164136','164268','164281','164360','164388','164389','164440','164458','164459','164643','164668','164772','164773','164774','164775','164827','164919','164932','165081','165110','165134','165177','165178','165394','165518','165532','165679','165723','165748','165934','166202','166203','166340','166539','166600','166624','166625','166652','166736','166793','166887','166889','166930','166963','167219','167294','167298','167474','167641','167739','167740','167960','168012','168047','168057','168082','168088','168089','168387','219749','232428','232498','232499','232536','232540','232586','232602','232687','232773','232774','232775','232776','238207','238208','238263','238264','238265','238297','238551','238622','238723','238724','238832','238839','238957','238958','239166','239198','239572','239627','239878','240072','240344','240505','240513','240634','240875','240876','240877','240930','241077','241078','241079','241159','241564','241632','242011','242012','242013','242017','242018','242019','242020','242266','242331','242332','242361','242364','242365','242404','242458','242499','242500','242545','242587','242784','243045','243070','243071','243106','243129','243279','243280','243281','243282','243375','243376','243600','243708','243930','244106','244324','244719','244724','244732','244990','245071','245093','245170','245380','245381','245520','245544','245854','246445','246472','246583','246584','246585','246586','246682','246831','247151','247211','247471','247620','247781','248016','248110','248134','248167','248257','248260','248261','248362','248669','248670','248687','249104','249105','249108','249435','249436','249468','249469','249470','249550','249553','249593','249594','249601','249602','249603','249671','249692','249693','249853','250043','250292','250599','250648','250649','250698','250764','250831','251280','251539','251554','251555','251556','251557','251575','251688','251787','251812','251850','251963','251964','252144','252145','252147','252160','252161','252215','252238','253122','253161','253163','253547','253590','253629','253880','254241','254242','254313','254421','254477','254545','254558','254637','254974','254977','254978','254979','255194','255195','255343','255436','255580','255668','255816','255817','255837','255949','256058','256060','256061','256082','256524','256525','256548','256577','256585','256926','257131','257132','257149','257152','262067','262109','262315','262415','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262517','262521','262565','262720','262721','262854','262880','262888','262889','262937','262949','262950','262951','262952','262953','262954','262955','262995','263491','263683','264401','264438','264503','264504','264505','264894','264895','264932','265239','265297','265298','265299','265300','265331','265342','265465','265480','265481','265482','265483','265704','265746','266005','266051','266052','266077','266253','266270','266426','266427','266428','266666','266715','266771','266833','266834','266835','266839','267073','267265','267291','267292','267580','267663','267718','267944','267945','267946','267947','268152','268348','268522','268535','268561','268595','268751','268816','268817','268818','268819','268820','268821','268822','268823','268824','268832','269028','269093','269113','269422','269512','269513','269514','269525','269749','273350','273472','273728','273729','273730','273738','273739','273740','273851','273911','273920','273948','274097','274133','274290','274439','274440','274722','274804','275000','275025','275048','275049','275200','275214','275220','275474','275476','275740','275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275909','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','276132','276149','276363','276364','276421','276435','276520','276633','276779','276972','276973','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277097','277098','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','277533','277587','277589','277866','277915','277916','277919','277961','277962','277995','277999','278221','278277','278472','278585','278586','278650','278651','278652','278653','278654','278732','278824','278825','278826','278827','278828','278829','278830','278888','279029','279033','279131','279401','279460','279461','279514','279667','280290','280504','280505','280508','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280712','280736','280737','280738','280740','280743','280799','280800','280808','280824','281144','281145','281146','281150','281151','281244','281245','281409','281410','281620','281680','281733','281758','281759','281791','281901','282008','282060','282086','282087','282171','282190','282438','282569','282570','282786','282787','282788','282791','282794','282795','283179','283180','283353','283551','283552','283597','283598','283599','283600','283736','283737','284145','284150','284158','284159','284160','284168','284182','284334','284446','284447','284500','284504','284505','284506','284507','284520','284521','284524','284528','284604','284949','284997','285233','285257','285275','285325','285412','285429','285445','285556','285559','285579','285670','285707','285836','285837','285838','285839','285840','285841','285842','285843','285899','286031','286032','286125','286147','286148','286149','286150','286151','286225','286273','286305','286306','286307','286335','286336','286387','286619','286620','286665','286801','286868','286883','286884','286911','286922','286991','287099','287123','287161','287214','287215','287216','287217','288011','288074','288100','288196','288202','288309','288377','288380','288381','288383','288384','288385','288502','288561','288562','288563','288661','288825','288826','288827','288828','288831','288832','288897','289007','289187','289278','289279','289396','289435','289441','291595','291596','291598','291691','291692','291693','291694','291695','291724','291805','291807','291853','291954','292094','292223','292244','292262','292263','292264','292268','292269','292336','292360','292365','292403','292429','292491','292523','292524','292594','292635','292636','292771','292839','292852','292859','292861','293208','293231','293286','293416','293433','293501','293563','293581','293660','293661','293662','293663','293664','293665','293666','293667','293668','293669','293670','293671','293672','293673','293674','293675','293676','293677','293678','293679','293680','293681','293682','293683','293684','293685','293686','293687','293688','293689','293690','293691','293692','293693','293694','293695','293696','293697','293698','293699','293700','293701','293702','293703','293704','293705','293706','293707','293708','293709','293710','293711','293712','293713','293714','293715','293716','293717','293718','293719','293720','293721','293722','293723','293724','293725','293726','293727','293728','293729','293730','293731','293732','293733','293734','293735','293736','293737','293738','293739','293740','293741','293742','293743','293744','293745','293746','293747','293748','293749','293750','293751','293752','293753','293754','293755','293756','293757','293758','293759','293760','293761','293762','293763','293764','293765','293766','293767','293768','293769','293770','293771','293772','293773','293774','293775','293776','293777','293778','293779','293780','293781','293782','293783','293784','293785','293786','293787','293788','293789','293790','293791','293792','293793','293794','293795','293796','293797','293798','293799','293800','293801','293802','293803','293804','293805','293806','293807','293808','293809','293810','293811','293812','293813','293814','293815','293816','293817','293818','293819','293820','293821','293822','293823','293824','293825','293826','293827','293828','293829','293830','293831','293832','293833','293834','293835','293836','293837','293838','293839','293840','293841','293842','293843','293844','293845','293846','293847','293848','293849','293850','294017','294042','294059','294333','294571','294590','294684','294704','294705','294706','294707','294723','294752','294753','294812','294815','294978','295330','295359','295360','295456','295477','295490','295491','295507','295528','295530','295531','295549','295550','295551','295552','295553','295573','295579','295605','295606','295629','295635','295756','295757','295758','295807','295809','295862','295981','295999','296206','296235','296258','296286','297106','297158','297162','297213','297448','297463','297512','297539','297561','297579','297721','297733','297754','297780','297983','297984','297985','297996','297997','298059','298112','298114','298170','298241','298266','298270','298271','298276','298283','298284','298412','298445','298532','298538','298539','298581','299101','299203','299283','299503','299515','299516','299517','299518','299519','299520','299521','299556','299557','299705','299706','299707','299712','299713','299714','299715','299732','299743','299766','299836','299837','299838','299845','299861','299862','299897','299904','299905','299910','299912','299913','299914','299921','299929','299984','299997','300004','300037','300049','300272','300301','300303','300308','300398','300522','300533','300644','300651','300653','300654','300705','300715','300904','300948','300949','300950','300951','300952','300953','300954','300955','300956','300957','300958','300959','300960','300961','300962','300963','300964','300965','300966','300967','300968','300969','300970','300971','300972','300973','300974','300975','300976','300977','300978','300979','300980','300981','300982','300983','300984','300985','300986','300987','300988','300989','300996','301003','301004','301010','301017','301050','301051','301052','301059','301062','301063','301064','301822','301836','301842','301843','301844','301847','301848','301858','301862','301877','301882','301913','301922','301923','301925','301969','301977','302057','302100','302125','302130','302154','302157','302158','302179','302180','302197','302202','302206','302207','302220','302307','302323','302325','302326','302356','302360','302365','303822','303843','303861','303924','303925','303958','303960','303961','303962','303963','303964') GROUP BY `section` ORDER BY `section` ASC
childsstroke1: section
SELECT `section`,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 `section` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `section` ORDER BY `section` ASC
childsstroke: function
SELECT `function`,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 `function` !='' AND `modx_site_content`.`id` IN ('153062','153076','153077','153079','153097','153103','153105','153118','153121','153122','153198','153199','153200','153203','153204','153209','153210','153299','153302','153303','153304','153307','153370','153375','153384','153385','153386','153387','153388','153446','153447','153448','153546','153571','153577','153591','153592','153598','153599','153762','153793','153794','153949','153950','154529','154530','154533','154567','154719','154759','154884','154885','154886','154895','155159','155160','155161','155199','155219','155220','155221','155222','155223','155224','155246','155277','155465','155560','155707','155718','156598','156599','156600','156601','156602','156603','156604','156605','156606','156607','156608','156609','156610','156611','156612','156613','156614','156615','156616','156617','156618','156620','156621','156622','156625','156626','156627','156628','156630','157553','157630','157631','157667','157699','158000','158005','158022','158023','158247','158262','158263','158530','158616','158692','158742','158743','158767','159106','159153','159154','159155','159156','159206','159439','159606','159675','159707','159979','159994','159995','160136','160137','160239','160252','160300','160303','160365','160366','160401','160482','160560','160582','160756','160829','161233','161234','161235','161236','161239','161240','161241','161242','161243','161244','161245','161246','161247','161248','161249','161250','161251','161252','161253','161254','161255','161256','161257','161309','161531','161708','161709','161738','161812','162034','162068','162097','162098','162100','162206','162216','162217','162224','162295','162298','162418','162563','162655','162695','162748','162871','163100','163101','163149','163527','163707','163918','163919','163920','163930','163946','163963','163982','164129','164136','164268','164281','164360','164388','164389','164440','164458','164459','164643','164668','164772','164773','164774','164775','164827','164919','164932','165081','165110','165134','165177','165178','165394','165518','165532','165679','165723','165748','165934','166202','166203','166340','166539','166600','166624','166625','166652','166736','166793','166887','166889','166930','166963','167219','167294','167298','167474','167641','167739','167740','167960','168012','168047','168057','168082','168088','168089','168387','219749','232428','232498','232499','232536','232540','232586','232602','232687','232773','232774','232775','232776','238207','238208','238263','238264','238265','238297','238551','238622','238723','238724','238832','238839','238957','238958','239166','239198','239572','239627','239878','240072','240344','240505','240513','240634','240875','240876','240877','240930','241077','241078','241079','241159','241564','241632','242011','242012','242013','242017','242018','242019','242020','242266','242331','242332','242361','242364','242365','242404','242458','242499','242500','242545','242587','242784','243045','243070','243071','243106','243129','243279','243280','243281','243282','243375','243376','243600','243708','243930','244106','244324','244719','244724','244732','244990','245071','245093','245170','245380','245381','245520','245544','245854','246445','246472','246583','246584','246585','246586','246682','246831','247151','247211','247471','247620','247781','248016','248110','248134','248167','248257','248260','248261','248362','248669','248670','248687','249104','249105','249108','249435','249436','249468','249469','249470','249550','249553','249593','249594','249601','249602','249603','249671','249692','249693','249853','250043','250292','250599','250648','250649','250698','250764','250831','251280','251539','251554','251555','251556','251557','251575','251688','251787','251812','251850','251963','251964','252144','252145','252147','252160','252161','252215','252238','253122','253161','253163','253547','253590','253629','253880','254241','254242','254313','254421','254477','254545','254558','254637','254974','254977','254978','254979','255194','255195','255343','255436','255580','255668','255816','255817','255837','255949','256058','256060','256061','256082','256524','256525','256548','256577','256585','256926','257131','257132','257149','257152','262067','262109','262315','262415','262447','262448','262449','262450','262451','262452','262453','262454','262455','262456','262457','262458','262459','262460','262461','262462','262463','262464','262465','262466','262467','262468','262469','262470','262471','262472','262473','262474','262476','262477','262478','262517','262521','262565','262720','262721','262854','262880','262888','262889','262937','262949','262950','262951','262952','262953','262954','262955','262995','263491','263683','264401','264438','264503','264504','264505','264894','264895','264932','265239','265297','265298','265299','265300','265331','265342','265465','265480','265481','265482','265483','265704','265746','266005','266051','266052','266077','266253','266270','266426','266427','266428','266666','266715','266771','266833','266834','266835','266839','267073','267265','267291','267292','267580','267663','267718','267944','267945','267946','267947','268152','268348','268522','268535','268561','268595','268751','268816','268817','268818','268819','268820','268821','268822','268823','268824','268832','269028','269093','269113','269422','269512','269513','269514','269525','269749','273350','273472','273728','273729','273730','273738','273739','273740','273851','273911','273920','273948','274097','274133','274290','274439','274440','274722','274804','275000','275025','275048','275049','275200','275214','275220','275474','275476','275740','275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275909','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','276132','276149','276363','276364','276421','276435','276520','276633','276779','276972','276973','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277097','277098','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','277533','277587','277589','277866','277915','277916','277919','277961','277962','277995','277999','278221','278277','278472','278585','278586','278650','278651','278652','278653','278654','278732','278824','278825','278826','278827','278828','278829','278830','278888','279029','279033','279131','279401','279460','279461','279514','279667','280290','280504','280505','280508','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280712','280736','280737','280738','280740','280743','280799','280800','280808','280824','281144','281145','281146','281150','281151','281244','281245','281409','281410','281620','281680','281733','281758','281759','281791','281901','282008','282060','282086','282087','282171','282190','282438','282569','282570','282786','282787','282788','282791','282794','282795','283179','283180','283353','283551','283552','283597','283598','283599','283600','283736','283737','284145','284150','284158','284159','284160','284168','284182','284334','284446','284447','284500','284504','284505','284506','284507','284520','284521','284524','284528','284604','284949','284997','285233','285257','285275','285325','285412','285429','285445','285556','285559','285579','285670','285707','285836','285837','285838','285839','285840','285841','285842','285843','285899','286031','286032','286125','286147','286148','286149','286150','286151','286225','286273','286305','286306','286307','286335','286336','286387','286619','286620','286665','286801','286868','286883','286884','286911','286922','286991','287099','287123','287161','287214','287215','287216','287217','288011','288074','288100','288196','288202','288309','288377','288380','288381','288383','288384','288385','288502','288561','288562','288563','288661','288825','288826','288827','288828','288831','288832','288897','289007','289187','289278','289279','289396','289435','289441','291595','291596','291598','291691','291692','291693','291694','291695','291724','291805','291807','291853','291954','292094','292223','292244','292262','292263','292264','292268','292269','292336','292360','292365','292403','292429','292491','292523','292524','292594','292635','292636','292771','292839','292852','292859','292861','293208','293231','293286','293416','293433','293501','293563','293581','293660','293661','293662','293663','293664','293665','293666','293667','293668','293669','293670','293671','293672','293673','293674','293675','293676','293677','293678','293679','293680','293681','293682','293683','293684','293685','293686','293687','293688','293689','293690','293691','293692','293693','293694','293695','293696','293697','293698','293699','293700','293701','293702','293703','293704','293705','293706','293707','293708','293709','293710','293711','293712','293713','293714','293715','293716','293717','293718','293719','293720','293721','293722','293723','293724','293725','293726','293727','293728','293729','293730','293731','293732','293733','293734','293735','293736','293737','293738','293739','293740','293741','293742','293743','293744','293745','293746','293747','293748','293749','293750','293751','293752','293753','293754','293755','293756','293757','293758','293759','293760','293761','293762','293763','293764','293765','293766','293767','293768','293769','293770','293771','293772','293773','293774','293775','293776','293777','293778','293779','293780','293781','293782','293783','293784','293785','293786','293787','293788','293789','293790','293791','293792','293793','293794','293795','293796','293797','293798','293799','293800','293801','293802','293803','293804','293805','293806','293807','293808','293809','293810','293811','293812','293813','293814','293815','293816','293817','293818','293819','293820','293821','293822','293823','293824','293825','293826','293827','293828','293829','293830','293831','293832','293833','293834','293835','293836','293837','293838','293839','293840','293841','293842','293843','293844','293845','293846','293847','293848','293849','293850','294017','294042','294059','294333','294571','294590','294684','294704','294705','294706','294707','294723','294752','294753','294812','294815','294978','295330','295359','295360','295456','295477','295490','295491','295507','295528','295530','295531','295549','295550','295551','295552','295553','295573','295579','295605','295606','295629','295635','295756','295757','295758','295807','295809','295862','295981','295999','296206','296235','296258','296286','297106','297158','297162','297213','297448','297463','297512','297539','297561','297579','297721','297733','297754','297780','297983','297984','297985','297996','297997','298059','298112','298114','298170','298241','298266','298270','298271','298276','298283','298284','298412','298445','298532','298538','298539','298581','299101','299203','299283','299503','299515','299516','299517','299518','299519','299520','299521','299556','299557','299705','299706','299707','299712','299713','299714','299715','299732','299743','299766','299836','299837','299838','299845','299861','299862','299897','299904','299905','299910','299912','299913','299914','299921','299929','299984','299997','300004','300037','300049','300272','300301','300303','300308','300398','300522','300533','300644','300651','300653','300654','300705','300715','300904','300948','300949','300950','300951','300952','300953','300954','300955','300956','300957','300958','300959','300960','300961','300962','300963','300964','300965','300966','300967','300968','300969','300970','300971','300972','300973','300974','300975','300976','300977','300978','300979','300980','300981','300982','300983','300984','300985','300986','300987','300988','300989','300996','301003','301004','301010','301017','301050','301051','301052','301059','301062','301063','301064','301822','301836','301842','301843','301844','301847','301848','301858','301862','301877','301882','301913','301922','301923','301925','301969','301977','302057','302100','302125','302130','302154','302157','302158','302179','302180','302197','302202','302206','302207','302220','302307','302323','302325','302326','302356','302360','302365','303822','303843','303861','303924','303925','303958','303960','303961','303962','303963','303964') GROUP BY `function` ORDER BY `function` ASC
childsstroke1: function
SELECT `function`,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 `function` !='' AND `modx_site_content`.`id` IN ('275865','275866','275867','275868','275869','275870','275871','275872','275873','275874','275875','275876','275877','275878','275879','275880','275881','275882','275883','275884','275885','275886','275887','275888','275889','275890','275891','275892','275893','275894','275895','275896','275897','275898','275899','275900','275901','275902','275903','275904','275905','275906','275907','275908','275910','275911','275912','275913','275914','275915','275916','275917','275918','275919','275920','275921','275922','275923','275924','275925','275926','275927','275928','275929','275930','275931','275932','275933','275934','275935','275936','275937','275938','275939','275940','275941','275942','275943','275944','275960','275961','276067','277045','277046','277047','277048','277049','277050','277051','277052','277053','277054','277055','277056','277057','277058','277059','277060','277061','277062','277080','277081','277082','277084','277085','277086','277087','277088','277089','277090','277091','277092','277093','277094','277095','277096','277099','277100','277101','277102','277103','277104','277105','277106','277107','277108','277109','277110','277111','277112','277113','277114','277115','277116','277117','277118','277119','277120','277121','277122','277123','277124','277125','277126','277127','277128','277129','277130','277131','277132','277133','277134','277135','277136','277137','277139','277140','277141','277142','277143','277144','277145','277146','277147','277148','277149','277150','277151','277152','277153','277154','277155','277156','277157','277158','277159','277160','277161','277162','277163','277164','277165','277166','277167','277168','280548','280550','280551','280554','280555','280556','280559','280560','280561','280562','280563','280591','280592','280619','280620','280622','280624','280630','280631','280632','280633','280634','280635','280636','280637','280638','280639','280640','280643','280644','280645','280646','280647','280648','280650','280651','280652','280653','280654','280655','280656','280657','280659','280661','280662','280663','280665','280666','280668','280669','280670','280671','280672','280673','280675','280676','280677','280678','280679','280680','280681','280682','280683','280684','280685','280686','280687','280688','280689','280690','280691','280692','280694','280695','280698','280699','280700','280701','280702','280703','280704','280705','280706','280707','280708','280736','280737','280738','280740','280743','281680','281733','281758','281759','282171','283179','283180','283551','283552','285556','285559','285836','285837','285838','285839','285840','285841','285842','285843','286031','286032','286307','286335','286336','286922','288825','288826','288827','288828','288831','288832','292263','292360','292523','292524','293501','294704','294705','294706','294707','295507','295573','298276','298283','298284','299503','299516','299517','299518','299519','299520','299521','300715','301842','301843','301922','301923','302179','302180') GROUP BY `function` ORDER BY `function` ASC
