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 ('154980','159096','162254','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 ('154980','159096','162254','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 ('154980','159096','162254','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 ('154980','159096','162254','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 ('154980','159096','162254','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 ('154980','159096','162254','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 ('154980','159096','162254','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 ('154980','159096','162254','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 ('154980','159096','162254','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
