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 ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') 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 ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: series
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 ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `series` ORDER BY `series` ASC
childsstroke1: series
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 ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `series` ORDER BY `series` ASC
childsstroke: kol_wires
SELECT `kol_wires`,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_wires` !='' AND `modx_site_content`.`id` IN ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `kol_wires` ORDER BY `kol_wires` ASC
childsstroke1: kol_wires
SELECT `kol_wires`,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_wires` !='' AND `modx_site_content`.`id` IN ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `kol_wires` ORDER BY `kol_wires` ASC
childsstroke: step
SELECT `step`,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 `step` !='' AND `modx_site_content`.`id` IN ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `step` ORDER BY `step` ASC
childsstroke1: step
SELECT `step`,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 `step` !='' AND `modx_site_content`.`id` IN ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `step` ORDER BY `step` ASC
childsstroke: calibr_wire
SELECT `calibr_wire`,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 `calibr_wire` !='' AND `modx_site_content`.`id` IN ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `calibr_wire` ORDER BY `calibr_wire` ASC
childsstroke1: calibr_wire
SELECT `calibr_wire`,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 `calibr_wire` !='' AND `modx_site_content`.`id` IN ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `calibr_wire` ORDER BY `calibr_wire` ASC
childsstroke: color
SELECT `color`,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 `color` !='' AND `modx_site_content`.`id` IN ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `color` ORDER BY `color` ASC
childsstroke1: color
SELECT `color`,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 `color` !='' AND `modx_site_content`.`id` IN ('157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801') GROUP BY `color` ORDER BY `color` ASC