childsstroke: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: kol_kanalov
SELECT `kol_kanalov`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `kol_kanalov` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `kol_kanalov` ORDER BY `kol_kanalov` ASC
childsstroke1: kol_kanalov
SELECT `kol_kanalov`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `kol_kanalov` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `kol_kanalov` ORDER BY `kol_kanalov` ASC
childsstroke: out_voltage
SELECT `out_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 `out_voltage` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `out_voltage` ORDER BY `out_voltage` ASC
childsstroke1: out_voltage
SELECT `out_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 `out_voltage` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `out_voltage` ORDER BY `out_voltage` ASC
childsstroke: out_voltage2
SELECT `out_voltage2`,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 `out_voltage2` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `out_voltage2` ORDER BY `out_voltage2` ASC
childsstroke1: out_voltage2
SELECT `out_voltage2`,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 `out_voltage2` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `out_voltage2` ORDER BY `out_voltage2` ASC
childsstroke1: SELECT `power`,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` !='' AND `modx_site_content`.`id` IN ('146470','146597','146598','146599','146600','146601','146602','146603','146604','146605','146606','146649','146650','146651','146652','146653','146654','146655','146656','146657','146658','146659','146660','146661','146662','146663','146664','146665','146666','146667','146668','146669','146670','146671','146672','146673','146674','146675','146680','146681','146682','146683','146684','146685','146686','146798','146799','146800','146801','146802','146803','146804','146805','146806','146807','146808','146809','146810','146811','146812','146813','146814','146815','146816','146817','146818','146819','146820','146821','146822','146823','146824','146825','146832','146833','146834','146835','146836','146837','146838','146839','146840','146841','146842','146843','146844','146845','146846','146847','146848','146849','146850','146851','147099','147100','147107','147108','147109','147110','147111','147112','147113','147114','147115','147116','147117','147118','147119','147120','147140','147141','147142','147143','147144','147145','147146','147147','147148','147149','147150','147761','147762','147763','147764','147765','147766','147767','147768','147769','147770','147771','147776','147777','147778','147779','147780','147781','147782','147791','147792','147793','147794','147932','147933','147934','147935','147936','147937','147938','147939','147940','147941','147948','147949','147950','147951','147952','147953','147954','147955','147956','147957','147958','147959','147960','147961','147962','147963','147964','147965','147966','147967','148003','148004','148005','148006','148007','148008','148009','148010','148011','148012','148013','148014','148015','148017','148020','148021','148022','148023','148024','154980','159096','162254','202584','202589','202661','202704','202705','202706','240001','253921','253922','253923','253924','253925','253926','253927','253928','253929','253930','253931','253932','253933','253934','253935','253937','253938','253939','253940','253941','253942','253943','253944','253945','253946','253947','253948','253949','253950','253951','253952','253953','253954','253955','253956','253957','253958','279030') GROUP BY `power` ORDER BY `power` ASC
