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 ('15','46','141226','141318','150473','156817','156818','156819','156820','156821','156822','162929','163035','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','215369','215556','215562','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','291833','292806','294064','294225','294973','300038','300426','300631','302050','141220','141221','141222','141223','141224','141225','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150620','152543','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215433','215953','216049','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') 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 ('141220','141221','141222','141223','141224','141225','141226','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141318','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150473','150620','152543','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215369','215433','215556','215562','215953','216049','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `manuf` ORDER BY `manuf` 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 ('15','46','141226','141318','150473','156817','156818','156819','156820','156821','156822','162929','163035','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','215369','215556','215562','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','291833','292806','294064','294225','294973','300038','300426','300631','302050','141220','141221','141222','141223','141224','141225','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150620','152543','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215433','215953','216049','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') 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 ('141220','141221','141222','141223','141224','141225','141226','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141318','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150473','150620','152543','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215369','215433','215556','215562','215953','216049','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `tip` ORDER BY `tip` ASC
childsstroke: series
SELECT `series`,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 `series` !='' AND `modx_site_content`.`id` IN ('15','46','141226','141318','150473','156817','156818','156819','156820','156821','156822','162929','163035','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','215369','215556','215562','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','291833','292806','294064','294225','294973','300038','300426','300631','302050','141220','141221','141222','141223','141224','141225','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150620','152543','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215433','215953','216049','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `series` ORDER BY `series` ASC
childsstroke1: series
SELECT `series`,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 `series` !='' AND `modx_site_content`.`id` IN ('141220','141221','141222','141223','141224','141225','141226','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141318','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150473','150620','152543','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215369','215433','215556','215562','215953','216049','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `series` ORDER BY `series` ASC
childsstroke: class_voltage
SELECT `class_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 `class_voltage` !='' AND `modx_site_content`.`id` IN ('15','46','141226','141318','150473','156817','156818','156819','156820','156821','156822','162929','163035','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','215369','215556','215562','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','291833','292806','294064','294225','294973','300038','300426','300631','302050','141220','141221','141222','141223','141224','141225','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150620','152543','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215433','215953','216049','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `class_voltage` ORDER BY `class_voltage` ASC
childsstroke1: class_voltage
SELECT `class_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 `class_voltage` !='' AND `modx_site_content`.`id` IN ('141220','141221','141222','141223','141224','141225','141226','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141318','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150473','150620','152543','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215369','215433','215556','215562','215953','216049','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `class_voltage` ORDER BY `class_voltage` ASC
childsstroke: max_current
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 ('15','46','141226','141318','150473','156817','156818','156819','156820','156821','156822','162929','163035','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','215369','215556','215562','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','291833','292806','294064','294225','294973','300038','300426','300631','302050','141220','141221','141222','141223','141224','141225','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150620','152543','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215433','215953','216049','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `max_current` ORDER BY `max_current` ASC
childsstroke1: max_current
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 ('141220','141221','141222','141223','141224','141225','141226','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141318','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150473','150620','152543','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215369','215433','215556','215562','215953','216049','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `max_current` ORDER BY `max_current` ASC
childsstroke: energy_imp
SELECT `energy_imp`,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 `energy_imp` !='' AND `modx_site_content`.`id` IN ('15','46','141226','141318','150473','156817','156818','156819','156820','156821','156822','162929','163035','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','215369','215556','215562','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','291833','292806','294064','294225','294973','300038','300426','300631','302050','141220','141221','141222','141223','141224','141225','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150620','152543','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215433','215953','216049','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `energy_imp` ORDER BY `energy_imp` ASC
childsstroke1: energy_imp
SELECT `energy_imp`,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 `energy_imp` !='' AND `modx_site_content`.`id` IN ('141220','141221','141222','141223','141224','141225','141226','141227','141228','141229','141230','141231','141232','141233','141234','141235','141236','141237','141238','141239','141240','141241','141242','141243','141244','141245','141246','141247','141248','141249','141250','141251','141252','141253','141254','141255','141256','141257','141258','141259','141260','141261','141262','141263','141264','141265','141266','141267','141268','141269','141270','141271','141272','141273','141274','141275','141276','141277','141278','141279','141280','141281','141282','141283','141284','141285','141286','141287','141288','141289','141290','141291','141292','141293','141294','141295','141296','141297','141298','141299','141300','141301','141302','141303','141304','141305','141306','141307','141308','141309','141310','141311','141312','141313','141314','141315','141316','141317','141318','141819','144122','144183','144185','144186','144187','144188','144189','144190','144191','144192','144288','144290','144296','145016','150473','150620','152543','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','168411','168412','168413','168414','168415','168416','168417','168418','168419','168420','168421','168422','168423','168424','168425','168426','168427','168428','168429','168430','168431','168432','168433','168434','168435','168436','168437','168438','168439','168440','168441','168442','168443','168444','168445','168446','168447','168448','168449','168450','168451','168452','168453','168454','168455','168456','168457','168458','168459','168460','168461','168462','168463','168464','168465','168466','168467','168468','168469','168470','168471','168472','168473','168474','168475','168476','168477','168478','168479','168480','168481','168482','168483','168484','168485','168486','168487','168488','168489','168490','168491','168492','168493','168494','168495','168496','168497','168498','168499','168500','168501','168502','168503','168504','168505','168506','168507','168508','168509','168510','168511','168512','168513','168514','168515','168516','168517','168518','168519','168520','168521','168522','168523','168524','168525','168526','168527','168528','168529','168530','168531','168532','168533','168534','168535','168536','168537','168538','168539','168540','168541','168542','168543','168544','168545','168546','168547','168548','168549','168550','168551','168552','168553','168554','168555','168556','168557','168558','168559','168560','168561','168562','168563','168564','168565','168566','168567','168568','168569','168570','168571','168572','168573','168574','168575','168576','168577','168578','168579','168580','168581','168582','168583','168584','168585','168586','168587','168588','168589','168590','168591','168592','168593','168594','168595','168596','168597','168598','168599','168600','168601','168602','168603','168604','168605','168606','168607','168608','168609','168610','168611','168612','168613','168614','168615','168616','168617','168618','168619','168620','168621','168622','168623','168624','168625','168626','168627','168628','168629','168630','168631','168632','168633','168634','168635','168636','168637','168638','168639','168640','168641','168642','168643','168644','168645','168646','168647','168648','168649','168650','168651','168652','168653','168654','168655','168656','168657','168658','168659','168660','168661','168662','168663','168664','168665','168666','168667','168668','168669','168670','168671','168672','168673','168674','168675','168676','168677','168678','168679','168680','168681','168682','168683','168684','168685','168686','168687','168688','168689','168690','168691','168692','168693','168694','168695','168696','168697','168698','168699','168700','168701','168702','168703','168704','168705','168706','168707','168708','168709','168710','168711','168712','168713','168714','168715','168716','168717','168718','168719','168720','168721','168722','168723','168724','168725','168726','168727','168728','168729','168730','168731','168732','168733','168734','168735','168736','168737','168738','168739','168740','168741','168742','168743','168744','168745','168746','168747','168748','168749','168750','168751','168752','168753','168754','168755','168756','168757','168758','168759','168760','168761','168762','168763','168764','168765','168766','168767','168768','168769','168770','168771','168772','168773','168774','168775','168776','168777','168778','168779','168780','168781','168782','168783','168784','168785','168786','168787','168788','168789','168790','168791','168792','168793','168794','168795','168796','168797','168798','168799','168800','168801','168802','168803','168804','168805','168806','168807','168808','168809','168810','168811','168812','168813','168814','168815','168816','168817','168818','168819','168820','168821','168822','168823','168824','168825','168826','168827','168828','168829','168830','168831','168832','168833','168834','168835','168836','168837','168838','168839','168840','168841','168842','168843','168844','168845','168846','168847','168848','168849','168850','168851','168852','168853','168854','168855','168856','168857','168858','168859','168860','168861','168862','168863','168864','168865','168866','168867','168868','168869','168870','168871','168872','168873','168874','168875','168876','168877','168878','168879','168880','168881','168882','168883','168884','168885','168886','168887','168888','168889','168890','168891','168892','168893','168894','168895','168896','168897','168898','168899','168900','168901','168902','168903','168904','168905','168906','168907','168908','168909','168910','168911','168912','168913','168914','168915','168916','168917','168918','168919','168920','168921','168922','168923','168924','168925','168926','168927','168928','168929','168930','168931','168932','168933','168934','168935','168936','168937','168938','168939','168940','168941','168942','168943','168944','168945','168946','168947','168948','168949','168950','168951','168952','168953','168954','168955','168956','168957','168958','168959','168960','168961','168962','168963','168964','168965','168966','168967','168968','168969','168970','168971','168972','168973','168974','168975','168976','168977','168978','168979','168980','168981','168982','168983','168984','168985','168986','168987','168988','168989','168990','168991','168992','168993','168994','168995','168996','168997','168998','168999','169000','169001','169002','169003','169004','169005','169006','169007','169008','169009','169010','169011','169012','169013','169014','169015','169016','169017','169018','169019','169020','169021','169022','169023','169024','169025','169026','169027','169028','169029','169030','169031','169032','169033','169034','169035','169036','169037','169038','169039','169040','169041','169042','169043','169044','169045','169046','169047','169048','169049','169050','169051','169052','169053','169054','169055','169056','169057','169058','169059','169060','169061','169062','169063','169064','169065','169066','169067','169068','169069','169070','169071','169072','169073','169074','169075','169076','169077','169078','169079','169080','169081','169082','169083','169084','169085','169086','169087','169088','169089','169090','169754','169797','170313','170715','170780','170789','170790','170791','170792','170793','170794','170795','215290','215369','215433','215556','215562','215953','216049','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `energy_imp` ORDER BY `energy_imp` ASC
