Tianbo Relay

SELECT `industry`,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 `industry` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `industry` ORDER BY `industry` ASC

SELECT `industry`,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 `industry` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `industry` ORDER BY `industry` ASC

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 ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `series` ORDER BY `series` ASC

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 ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `series` ORDER BY `series` ASC

SELECT `ac_dc`,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 `ac_dc` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `ac_dc` ORDER BY `ac_dc` ASC

SELECT `ac_dc`,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 `ac_dc` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `ac_dc` ORDER BY `ac_dc` ASC

SELECT `coil_volt`,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 `coil_volt` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `coil_volt` ORDER BY `coil_volt` ASC

SELECT `coil_volt`,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 `coil_volt` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `coil_volt` ORDER BY `coil_volt` ASC

SELECT `power_upr`,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 `power_upr` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `power_upr` ORDER BY `power_upr` ASC

SELECT `power_upr`,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 `power_upr` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `power_upr` ORDER BY `power_upr` ASC

SELECT `cont_shem`,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 `cont_shem` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `cont_shem` ORDER BY `cont_shem` ASC

SELECT `cont_shem`,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 `cont_shem` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `cont_shem` ORDER BY `cont_shem` ASC

SELECT `max_voltage_ac`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `max_voltage_ac` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `max_voltage_ac` ORDER BY `max_voltage_ac` ASC

SELECT `max_voltage_ac`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `max_voltage_ac` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `max_voltage_ac` ORDER BY `max_voltage_ac` ASC

SELECT `max_voltage`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `max_voltage` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `max_voltage` ORDER BY `max_voltage` ASC

SELECT `max_voltage`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `max_voltage` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `max_voltage` ORDER BY `max_voltage` ASC

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 ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `max_current` ORDER BY `max_current` ASC

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 ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `max_current` ORDER BY `max_current` ASC

SELECT `magnetic`,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 `magnetic` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `magnetic` ORDER BY `magnetic` ASC

SELECT `magnetic`,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 `magnetic` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `magnetic` ORDER BY `magnetic` ASC

SELECT `work_temp`,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 `work_temp` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `work_temp` ORDER BY `work_temp` ASC

SELECT `work_temp`,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 `work_temp` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `work_temp` ORDER BY `work_temp` ASC

SELECT `stock_status`,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 `stock_status` !='' AND `modx_site_content`.`id` IN ('141359','141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141532','141541','141542','141580','141589','141590','141625','141627','141629','141639','141640','141642','141695','141710','141768','141769','141770','141771','141772','141872','141873','141959','141999','142017','142052','142070','142071','142072','142088','142093','142149','142151','142158','142159','142160','142172','142232','142233','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144045','144046','144055','144216','144217','144994','144999','147094','147732','147733','150446','150802','150835','151028','151040','151041','151285','151404','151414','151427','151432','151987','152507','152638','153073','153104','153110','153111','153112','153113','153651','153652','153813','153825','153921','153951','154248','154254','154413','154683','154685','154686','154702','154705','154706','154709','154710','154745','154748','155073','156523','156524','156529','156530','156531','156532','156533','156534','156535','156536','156538','156539','158125','158126','158425','158426','158847','158848','159193','159194','159313','161466','161527','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167030','167470','167471','167823','167824','169157','238719','238720','239260','239261','241482','241906','241907','241908','241909','241910','242829','244693','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263856','263857','263858','263859','263860','263861','263862','263863','263864','263865','263866','263867','263868','263869','263870','263871','263872','263873','263874','263875','263876','263877','263878','263879','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263924','263925','263926','263928','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263983','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264012','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264101','264102','264103','264104','264105','264106','264107','264108','264109','264110','264111','264112','264114','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264266','264267','264268','264269','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','266376','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','278155','279158','279714','281078','281217','285580','285581','285582','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','292552','292700','295834','297103','299115','299385','299563','301988') GROUP BY `stock_status` ORDER BY `stock_status` ASC

SELECT `stock_status`,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 `stock_status` !='' AND `modx_site_content`.`id` IN ('141397','141398','141399','141400','141401','141402','141403','141404','141405','141406','141407','141470','141471','141472','141473','141474','141523','141531','141580','141589','141590','141625','141627','141629','141639','141642','141695','141710','141769','141770','141771','141772','141872','141873','141959','141999','142070','142071','142093','142151','142158','142159','142160','142172','142667','142668','142690','142699','142700','142718','142776','142777','142778','142779','142780','142781','142782','142783','142858','143390','143559','143598','143930','144216','144994','144999','147094','147732','147733','150446','150802','151028','151285','151414','151427','151432','152638','153073','153104','153111','153112','153113','153651','153652','153825','153951','154248','154254','154413','154683','154685','154702','154705','154706','154709','154745','154748','156523','156524','156529','156530','156531','156532','156533','156534','156536','158126','158847','158848','159193','159313','161466','162263','162361','162784','163003','163311','164991','165724','165905','166408','166969','167470','167471','167823','238720','241906','241907','241908','241909','241910','242829','247194','251384','251687','253786','257156','257157','262231','262232','262233','262234','262235','262236','262237','262238','262239','262240','262250','263766','263767','263768','263769','263770','263771','263772','263773','263774','263775','263776','263777','263778','263779','263780','263781','263782','263783','263784','263785','263786','263787','263788','263789','263790','263791','263792','263793','263794','263795','263796','263797','263798','263799','263800','263801','263802','263803','263804','263805','263806','263807','263808','263809','263810','263811','263812','263813','263814','263815','263816','263817','263818','263819','263820','263821','263822','263823','263824','263825','263826','263827','263828','263829','263830','263831','263832','263833','263834','263835','263836','263837','263838','263840','263841','263842','263843','263844','263845','263846','263847','263848','263849','263850','263851','263852','263853','263854','263855','263878','263880','263881','263882','263883','263884','263885','263886','263887','263888','263889','263890','263891','263892','263893','263894','263895','263896','263897','263898','263899','263900','263901','263904','263905','263906','263907','263908','263909','263910','263911','263912','263913','263914','263915','263916','263917','263918','263919','263920','263921','263922','263923','263925','263926','263929','263930','263931','263932','263933','263934','263935','263936','263937','263938','263939','263940','263941','263942','263943','263944','263945','263946','263947','263948','263949','263950','263951','263952','263953','263954','263955','263956','263957','263958','263959','263960','263961','263962','263963','263964','263965','263966','263967','263968','263969','263970','263971','263972','263973','263974','263975','263976','263977','263978','263979','263981','263982','263985','263986','263987','263988','263989','263990','263991','263992','263993','263994','263995','263996','263999','264000','264001','264002','264003','264004','264005','264006','264007','264009','264010','264013','264014','264015','264016','264017','264018','264019','264020','264021','264022','264023','264024','264027','264028','264029','264030','264031','264032','264033','264034','264035','264036','264037','264038','264040','264041','264042','264043','264044','264045','264047','264048','264049','264050','264051','264052','264054','264055','264057','264058','264059','264060','264061','264062','264063','264065','264066','264067','264068','264069','264070','264071','264072','264073','264074','264077','264078','264079','264080','264081','264082','264085','264087','264088','264089','264090','264091','264092','264093','264095','264096','264097','264100','264115','264116','264117','264118','264119','264120','264121','264122','264123','264124','264125','264126','264127','264128','264129','264130','264131','264132','264133','264134','264136','264137','264141','264142','264143','264144','264145','264146','264147','264148','264149','264150','264151','264152','264153','264154','264155','264156','264157','264158','264159','264160','264161','264162','264163','264164','264165','264166','264167','264168','264169','264170','264171','264172','264173','264174','264175','264176','264177','264178','264179','264180','264181','264182','264183','264184','264185','264186','264187','264188','264189','264190','264191','264192','264193','264194','264195','264196','264197','264198','264199','264200','264201','264202','264203','264204','264205','264206','264207','264208','264209','264210','264211','264212','264213','264214','264215','264216','264217','264218','264219','264220','264221','264222','264223','264224','264225','264226','264227','264228','264229','264230','264231','264232','264233','264234','264235','264236','264237','264238','264239','264240','264241','264242','264243','264244','264245','264264','264265','264270','264271','264272','264273','264274','264275','264276','264277','264278','264279','264280','264281','264282','264283','264284','264285','264286','264287','264288','264289','264290','264291','264292','264293','264294','264295','264296','264297','264298','264299','264300','264301','264302','264303','264304','264305','264306','264307','264308','264309','264311','264312','264313','264314','264315','264316','264317','264318','264319','264320','264321','264322','264323','264324','264325','264326','264327','264328','264329','264330','264331','264332','264333','264334','264335','264336','264346','274468','274469','274470','274471','274472','274473','274474','274475','275224','277816','277943','279158','281217','285583','285780','285781','285782','287132','287133','287535','287795','287796','288028','288363','288364','292084','292415','292544','292545','292546','292547','292548','292549','295834','297103','299115','299385','299563','301988') GROUP BY `stock_status` ORDER BY `stock_status` ASC