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 ('210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136') 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 ('210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: cokol
SELECT `cokol`,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 `cokol` !='' AND `modx_site_content`.`id` IN ('210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136') GROUP BY `cokol` ORDER BY `cokol` ASC
childsstroke1: cokol
SELECT `cokol`,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 `cokol` !='' AND `modx_site_content`.`id` IN ('210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136') GROUP BY `cokol` ORDER BY `cokol` ASC
childsstroke: voltage
SELECT `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 `voltage` !='' AND `modx_site_content`.`id` IN ('210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136') GROUP BY `voltage` ORDER BY `voltage` ASC
childsstroke1: voltage
SELECT `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 `voltage` !='' AND `modx_site_content`.`id` IN ('210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136') GROUP BY `voltage` ORDER BY `voltage` 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 ('210532','210533','210534','210535','210536','210537','210538','210539','210540','210541','210542','210543','210544','210545','210546','210547','210548','210549','210550','210551','210552','210553','210554','210555','210556','210557','210558','210559','210560','210561','210562','210563','210564','210565','210566','210567','210568','210569','210570','210571','210572','210573','210574','210575','210576','210577','210578','210579','210580','210581','210582','210583','210584','210585','210586','210587','210588','210589','210590','210591','210592','210593','210594','210595','257136') GROUP BY `power` ORDER BY `power` ASC