Варисторы

SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('15','46','141226','156817','156818','156819','156820','156821','156822','162929','163035','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `manuf` ORDER BY `manuf` ASC

SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('141226','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `manuf` ORDER BY `manuf` ASC

SELECT `tip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `tip` !='' AND `modx_site_content`.`id` IN ('15','46','141226','156817','156818','156819','156820','156821','156822','162929','163035','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `tip` ORDER BY `tip` ASC

SELECT `tip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `tip` !='' AND `modx_site_content`.`id` IN ('141226','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `tip` ORDER BY `tip` ASC

SELECT `series`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `series` !='' AND `modx_site_content`.`id` IN ('15','46','141226','156817','156818','156819','156820','156821','156822','162929','163035','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `series` ORDER BY `series` ASC

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 ('141226','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `series` ORDER BY `series` ASC

SELECT `class_voltage`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `class_voltage` !='' AND `modx_site_content`.`id` IN ('15','46','141226','156817','156818','156819','156820','156821','156822','162929','163035','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `class_voltage` ORDER BY `class_voltage` ASC

SELECT `class_voltage`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `class_voltage` !='' AND `modx_site_content`.`id` IN ('141226','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `class_voltage` ORDER BY `class_voltage` ASC

SELECT `max_current`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `max_current` !='' AND `modx_site_content`.`id` IN ('15','46','141226','156817','156818','156819','156820','156821','156822','162929','163035','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `max_current` ORDER BY `max_current` ASC

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 ('141226','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `max_current` ORDER BY `max_current` ASC

SELECT `energy_imp`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `energy_imp` !='' AND `modx_site_content`.`id` IN ('15','46','141226','156817','156818','156819','156820','156821','156822','162929','163035','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681') GROUP BY `energy_imp` ORDER BY `energy_imp` ASC

SELECT `energy_imp`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `energy_imp` !='' AND `modx_site_content`.`id` IN ('141226','154732','156817','156818','156819','156820','156821','156822','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','162929','163035','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239578','239743','239835','239987','239999','240009','241060','241161','241383','241895','242603','242904','243211','243436','243916','243949','244244','244554','244625','244718','245751','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249076','249103','249709','250098','250244','250245','250246','250353','250869','251523','251677','252053','253021','253022','253023','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','255677','255807','256247','256272','257162','257184','261794','262005','262007','262011','262182','262781','263061','263629','263699','265158','265336','265353','265418','265468','265555','265559','265870','265899','265948','266274','266710','267103','267325','267701','268087','268291','269441','269589','273521','273522','273831','274629','274786','274891','274911','274921','275229','275236','275679','275836','276289','276295','276578','277174','277306','277830','277873','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279600','279825','280453','280603','280604','280778','280867','280870','280987','281321','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','284866','285058','285441','285766','286071','286964','288317','289257','289400','291746','291832','291956','292225','292321','292322','292389','292806','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294360','294588','294973','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300038','300426','300631','300681','302050') GROUP BY `energy_imp` ORDER BY `energy_imp` ASC