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 ('141758','141986','141987','141988','147722','148125','151184','151609','154866','156259','158239','158646','158860','159605','159814','160229','160317','160742','160743','160744','160864','160865','160866','161229','161230','161231','161431','161619','161700','161760','161805','161997','162127','162181','162220','162232','162331','162435','162457','162633','163064','163104','163105','163281','163305','163306','163477','163525','163978','164493','164681','164799','164888','164894','164895','165231','165240','166535','166543','166556','166821','167026','167249','167738','170315','232438','232678','232793','238047','238070','238197','238475','238572','239332','239963','240360','241814','241857','241858','242599','243355','243955','244192','244340','244907','244908','245028','245324','245929','246289','246841','247745','247956','248035','248380','248806','248913','248916','248931','249065','249539','249736','250596','251520','251714','251765','251813','253640','254794','256140','256670','261938','262078','262602','262663','265582','265844','266709','267064','267297','274038','274322','274361','274820','275363','275612','276515','276547','276693','277021','280467','282013','283801','284344','286903','291592','293490','293638','294265','294304','295412','295677','297257','297861','299277','299508','300245','300381','301797','301892','301985','302340') 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 ('141758','141986','141987','141988','147722','148125','151184','151609','154866','156259','158239','158646','158860','159605','159814','160229','160317','160742','160743','160744','160864','160865','160866','161229','161230','161231','161431','161619','161700','161760','161805','161997','162127','162181','162220','162232','162331','162435','162457','162633','163064','163104','163105','163281','163305','163306','163477','163525','163978','164493','164681','164799','164888','164894','164895','165231','165240','166535','166543','166556','166821','167026','167249','167738','170315','232438','232678','232793','238047','238070','238197','238475','238572','239332','239963','240360','241814','241857','241858','242599','243355','243955','244192','244340','244907','244908','245028','245324','245929','246289','246841','247745','247956','248035','248380','248806','248913','248916','248931','249065','249539','249736','250596','251520','251714','251765','251813','253640','254794','256140','256670','261938','262078','262602','262663','265582','265844','266709','267064','267297','274038','274322','274361','274820','275363','275612','276515','276547','276693','277021','280467','282013','283801','284344','286903','291592','293490','293638','294265','294304','295412','295677','297257','297861','299277','299508','300245','300381','301797','301892','301985','302340') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: resistance
SELECT `resistance`,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 `resistance` !='' AND `modx_site_content`.`id` IN ('141758','141986','141987','141988','147722','148125','151184','151609','154866','156259','158239','158646','158860','159605','159814','160229','160317','160742','160743','160744','160864','160865','160866','161229','161230','161231','161431','161619','161700','161760','161805','161997','162127','162181','162220','162232','162331','162435','162457','162633','163064','163104','163105','163281','163305','163306','163477','163525','163978','164493','164681','164799','164888','164894','164895','165231','165240','166535','166543','166556','166821','167026','167249','167738','170315','232438','232678','232793','238047','238070','238197','238475','238572','239332','239963','240360','241814','241857','241858','242599','243355','243955','244192','244340','244907','244908','245028','245324','245929','246289','246841','247745','247956','248035','248380','248806','248913','248916','248931','249065','249539','249736','250596','251520','251714','251765','251813','253640','254794','256140','256670','261938','262078','262602','262663','265582','265844','266709','267064','267297','274038','274322','274361','274820','275363','275612','276515','276547','276693','277021','280467','282013','283801','284344','286903','291592','293490','293638','294265','294304','295412','295677','297257','297861','299277','299508','300245','300381','301797','301892','301985','302340') GROUP BY `resistance` ORDER BY `resistance` ASC
childsstroke1: resistance
SELECT `resistance`,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 `resistance` !='' AND `modx_site_content`.`id` IN ('141758','141986','141987','141988','147722','148125','151184','151609','154866','156259','158239','158646','158860','159605','159814','160229','160317','160742','160743','160744','160864','160865','160866','161229','161230','161231','161431','161619','161700','161760','161805','161997','162127','162181','162220','162232','162331','162435','162457','162633','163064','163104','163105','163281','163305','163306','163477','163525','163978','164493','164681','164799','164888','164894','164895','165231','165240','166535','166543','166556','166821','167026','167249','167738','170315','232438','232678','232793','238047','238070','238197','238475','238572','239332','239963','240360','241814','241857','241858','242599','243355','243955','244192','244340','244907','244908','245028','245324','245929','246289','246841','247745','247956','248035','248380','248806','248913','248916','248931','249065','249539','249736','250596','251520','251714','251765','251813','253640','254794','256140','256670','261938','262078','262602','262663','265582','265844','266709','267064','267297','274038','274322','274361','274820','275363','275612','276515','276547','276693','277021','280467','282013','283801','284344','286903','291592','293490','293638','294265','294304','295412','295677','297257','297861','299277','299508','300245','300381','301797','301892','301985','302340') GROUP BY `resistance` ORDER BY `resistance` ASC
childsstroke: resistance_unit
SELECT `resistance_unit`,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 `resistance_unit` !='' AND `modx_site_content`.`id` IN ('141758','141986','141987','141988','147722','148125','151184','151609','154866','156259','158239','158646','158860','159605','159814','160229','160317','160742','160743','160744','160864','160865','160866','161229','161230','161231','161431','161619','161700','161760','161805','161997','162127','162181','162220','162232','162331','162435','162457','162633','163064','163104','163105','163281','163305','163306','163477','163525','163978','164493','164681','164799','164888','164894','164895','165231','165240','166535','166543','166556','166821','167026','167249','167738','170315','232438','232678','232793','238047','238070','238197','238475','238572','239332','239963','240360','241814','241857','241858','242599','243355','243955','244192','244340','244907','244908','245028','245324','245929','246289','246841','247745','247956','248035','248380','248806','248913','248916','248931','249065','249539','249736','250596','251520','251714','251765','251813','253640','254794','256140','256670','261938','262078','262602','262663','265582','265844','266709','267064','267297','274038','274322','274361','274820','275363','275612','276515','276547','276693','277021','280467','282013','283801','284344','286903','291592','293490','293638','294265','294304','295412','295677','297257','297861','299277','299508','300245','300381','301797','301892','301985','302340') GROUP BY `resistance_unit` ORDER BY `resistance_unit` ASC
childsstroke1: resistance_unit
SELECT `resistance_unit`,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 `resistance_unit` !='' AND `modx_site_content`.`id` IN ('141758','141986','141987','141988','147722','148125','151184','151609','154866','156259','158239','158646','158860','159605','159814','160229','160317','160742','160743','160744','160864','160865','160866','161229','161230','161231','161431','161619','161700','161760','161805','161997','162127','162181','162220','162232','162331','162435','162457','162633','163064','163104','163105','163281','163305','163306','163477','163525','163978','164493','164681','164799','164888','164894','164895','165231','165240','166535','166543','166556','166821','167026','167249','167738','170315','232438','232678','232793','238047','238070','238197','238475','238572','239332','239963','240360','241814','241857','241858','242599','243355','243955','244192','244340','244907','244908','245028','245324','245929','246289','246841','247745','247956','248035','248380','248806','248913','248916','248931','249065','249539','249736','250596','251520','251714','251765','251813','253640','254794','256140','256670','261938','262078','262602','262663','265582','265844','266709','267064','267297','274038','274322','274361','274820','275363','275612','276515','276547','276693','277021','280467','282013','283801','284344','286903','291592','293490','293638','294265','294304','295412','295677','297257','297861','299277','299508','300245','300381','301797','301892','301985','302340') GROUP BY `resistance_unit` ORDER BY `resistance_unit` ASC