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 ('141560','141612','142526','142979','143331','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','151349','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157996','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','166981','167687','169164','169165','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','232506','232606','232744','238108','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256334','256335','256336','256337','256338','256798','262446','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','280826','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 ('141560','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','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','169164','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','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 ('141560','141612','142526','142979','143331','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','151349','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157996','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','166981','167687','169164','169165','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','232506','232606','232744','238108','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256334','256335','256336','256337','256338','256798','262446','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','280826','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 ('141560','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','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','169164','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','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 ('141560','141612','142526','142979','143331','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','151349','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157996','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','166981','167687','169164','169165','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','232506','232606','232744','238108','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256334','256335','256336','256337','256338','256798','262446','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','280826','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 ('141560','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','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','169164','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','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 ('141560','141612','142526','142979','143331','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','151349','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157996','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','166981','167687','169164','169165','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','232506','232606','232744','238108','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256334','256335','256336','256337','256338','256798','262446','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','280826','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 ('141560','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','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','169164','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','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 ('141560','141612','142526','142979','143331','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','151349','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157996','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','166981','167687','169164','169165','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','232506','232606','232744','238108','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256334','256335','256336','256337','256338','256798','262446','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','280826','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 ('141560','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','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','169164','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','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 ('141560','141612','142526','142979','143331','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','151349','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157996','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','166981','167687','169164','169165','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','232506','232606','232744','238108','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256334','256335','256336','256337','256338','256798','262446','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','280826','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 ('141560','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','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','169164','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','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
