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 ('141760','149614','150502','150628','151532','151660','151726','151889','151937','151959','154762','155634','155635','155636','155637','155639','155642','155643','155644','155645','155646','155666','155667','155675','155687','155688','155689','155690','155691','155692','155693','155694','155696','155697','155698','155699','155700','155701','155702','155703','155704','155705','155706','156540','156541','156542','156543','156544','156545','156546','156547','156548','156549','156550','157664','157935','158965','159372','159387','159631','160655','160876','161875','162040','162140','162171','162234','162677','163649','164117','164118','164988','165446','165619','165620','165696','166089','166199','167248','167711','167895','168123','168125','168126','168140','168196','169216','169217','169218','169219','169224','169818','170190','170692','202853','215948','216013','238721','240281','240699','240700','240701','241197','241198','241199','241362','241382','241404','241593','241656','241657','241669','242761','242762','242830','242831','244445','244447','244448','244892','244893','247116','247553','247754','248568','248792','248802','248836','249361','249362','249386','250482','250691','250874','250987','251142','251143','251197','251402','251440','251642','252117','252137','253049','253056','253074','253746','254876','254969','255026','255155','256460','261789','262323','263012','264875','265909','266601','266646','267120','267343','267812','267813','268118','268392','268458','268558','268559','268560','268604','268638','269229','273326','273526','273801','273810','274253','274272','274467','274867','274893','275082','275811','276518','276678','277169','277475','278094','278163','278196','278996','279209','280564','280601','280734','280781','281651','281652','282202','282275','282448','282876','283311','284205','284378','284405','284406','284407','284408','284909','284910','284911','285219','285224','285855','285862','286229','286240','286364','288389','288761','289370','291616','292314','292380','292766','292807','292821','292868','293203','293425','294071','295939','297347','297475','297833','298168','299103','299112','299266','299267','300334','304026') 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 ('141760','149614','150502','150628','151532','151660','151726','151889','151937','151959','154762','155634','155635','155636','155637','155639','155642','155643','155644','155645','155646','155666','155667','155675','155687','155688','155689','155690','155691','155692','155693','155694','155696','155697','155698','155699','155700','155701','155702','155703','155704','155705','155706','156540','156541','156542','156543','156544','156545','156546','156547','156548','156549','156550','157664','157935','158965','159372','159387','159631','160655','160876','161875','162040','162140','162171','162234','162677','163649','164117','164118','164988','165446','165619','165620','165696','166089','166199','167248','167711','167895','168123','168125','168126','168140','168196','169216','169217','169218','169219','169224','169818','170190','170692','202853','215948','216013','238721','240281','240699','240700','240701','241197','241198','241199','241362','241382','241404','241593','241656','241657','241669','242761','242762','242830','242831','244445','244447','244448','244892','244893','247116','247553','247754','248568','248792','248802','248836','249361','249362','249386','250482','250691','250874','250987','251142','251143','251197','251402','251440','251642','252117','252137','253049','253056','253074','253746','254876','254969','255026','255155','256460','261789','262323','263012','264875','265909','266601','266646','267120','267343','267812','267813','268118','268392','268458','268558','268559','268560','268604','268638','269229','273326','273526','273801','273810','274253','274272','274467','274867','274893','275082','275811','276518','276678','277169','277475','278094','278163','278196','278996','279209','280564','280601','280734','280781','281651','281652','282202','282275','282448','282876','283311','284205','284378','284405','284406','284407','284408','284909','284910','284911','285219','285224','285855','285862','286229','286240','286364','288389','288761','289370','291616','292314','292380','292766','292807','292821','292868','293203','293425','294071','295939','297347','297475','297833','298168','299103','299112','299266','299267','300334','304026') 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 ('141760','149614','150502','150628','151532','151660','151726','151889','151937','151959','154762','155634','155635','155636','155637','155639','155642','155643','155644','155645','155646','155666','155667','155675','155687','155688','155689','155690','155691','155692','155693','155694','155696','155697','155698','155699','155700','155701','155702','155703','155704','155705','155706','156540','156541','156542','156543','156544','156545','156546','156547','156548','156549','156550','157664','157935','158965','159372','159387','159631','160655','160876','161875','162040','162140','162171','162234','162677','163649','164117','164118','164988','165446','165619','165620','165696','166089','166199','167248','167711','167895','168123','168125','168126','168140','168196','169216','169217','169218','169219','169224','169818','170190','170692','202853','215948','216013','238721','240281','240699','240700','240701','241197','241198','241199','241362','241382','241404','241593','241656','241657','241669','242761','242762','242830','242831','244445','244447','244448','244892','244893','247116','247553','247754','248568','248792','248802','248836','249361','249362','249386','250482','250691','250874','250987','251142','251143','251197','251402','251440','251642','252117','252137','253049','253056','253074','253746','254876','254969','255026','255155','256460','261789','262323','263012','264875','265909','266601','266646','267120','267343','267812','267813','268118','268392','268458','268558','268559','268560','268604','268638','269229','273326','273526','273801','273810','274253','274272','274467','274867','274893','275082','275811','276518','276678','277169','277475','278094','278163','278196','278996','279209','280564','280601','280734','280781','281651','281652','282202','282275','282448','282876','283311','284205','284378','284405','284406','284407','284408','284909','284910','284911','285219','285224','285855','285862','286229','286240','286364','288389','288761','289370','291616','292314','292380','292766','292807','292821','292868','293203','293425','294071','295939','297347','297475','297833','298168','299103','299112','299266','299267','300334','304026') 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 ('141760','149614','150502','150628','151532','151660','151726','151889','151937','151959','154762','155634','155635','155636','155637','155639','155642','155643','155644','155645','155646','155666','155667','155675','155687','155688','155689','155690','155691','155692','155693','155694','155696','155697','155698','155699','155700','155701','155702','155703','155704','155705','155706','156540','156541','156542','156543','156544','156545','156546','156547','156548','156549','156550','157664','157935','158965','159372','159387','159631','160655','160876','161875','162040','162140','162171','162234','162677','163649','164117','164118','164988','165446','165619','165620','165696','166089','166199','167248','167711','167895','168123','168125','168126','168140','168196','169216','169217','169218','169219','169224','169818','170190','170692','202853','215948','216013','238721','240281','240699','240700','240701','241197','241198','241199','241362','241382','241404','241593','241656','241657','241669','242761','242762','242830','242831','244445','244447','244448','244892','244893','247116','247553','247754','248568','248792','248802','248836','249361','249362','249386','250482','250691','250874','250987','251142','251143','251197','251402','251440','251642','252117','252137','253049','253056','253074','253746','254876','254969','255026','255155','256460','261789','262323','263012','264875','265909','266601','266646','267120','267343','267812','267813','268118','268392','268458','268558','268559','268560','268604','268638','269229','273326','273526','273801','273810','274253','274272','274467','274867','274893','275082','275811','276518','276678','277169','277475','278094','278163','278196','278996','279209','280564','280601','280734','280781','281651','281652','282202','282275','282448','282876','283311','284205','284378','284405','284406','284407','284408','284909','284910','284911','285219','285224','285855','285862','286229','286240','286364','288389','288761','289370','291616','292314','292380','292766','292807','292821','292868','293203','293425','294071','295939','297347','297475','297833','298168','299103','299112','299266','299267','300334','304026') 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 ('141760','149614','150502','150628','151532','151660','151726','151889','151937','151959','154762','155634','155635','155636','155637','155639','155642','155643','155644','155645','155646','155666','155667','155675','155687','155688','155689','155690','155691','155692','155693','155694','155696','155697','155698','155699','155700','155701','155702','155703','155704','155705','155706','156540','156541','156542','156543','156544','156545','156546','156547','156548','156549','156550','157664','157935','158965','159372','159387','159631','160655','160876','161875','162040','162140','162171','162234','162677','163649','164117','164118','164988','165446','165619','165620','165696','166089','166199','167248','167711','167895','168123','168125','168126','168140','168196','169216','169217','169218','169219','169224','169818','170190','170692','202853','215948','216013','238721','240281','240699','240700','240701','241197','241198','241199','241362','241382','241404','241593','241656','241657','241669','242761','242762','242830','242831','244445','244447','244448','244892','244893','247116','247553','247754','248568','248792','248802','248836','249361','249362','249386','250482','250691','250874','250987','251142','251143','251197','251402','251440','251642','252117','252137','253049','253056','253074','253746','254876','254969','255026','255155','256460','261789','262323','263012','264875','265909','266601','266646','267120','267343','267812','267813','268118','268392','268458','268558','268559','268560','268604','268638','269229','273326','273526','273801','273810','274253','274272','274467','274867','274893','275082','275811','276518','276678','277169','277475','278094','278163','278196','278996','279209','280564','280601','280734','280781','281651','281652','282202','282275','282448','282876','283311','284205','284378','284405','284406','284407','284408','284909','284910','284911','285219','285224','285855','285862','286229','286240','286364','288389','288761','289370','291616','292314','292380','292766','292807','292821','292868','293203','293425','294071','295939','297347','297475','297833','298168','299103','299112','299266','299267','300334','304026') 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 ('141760','149614','150502','150628','151532','151660','151726','151889','151937','151959','154762','155634','155635','155636','155637','155639','155642','155643','155644','155645','155646','155666','155667','155675','155687','155688','155689','155690','155691','155692','155693','155694','155696','155697','155698','155699','155700','155701','155702','155703','155704','155705','155706','156540','156541','156542','156543','156544','156545','156546','156547','156548','156549','156550','157664','157935','158965','159372','159387','159631','160655','160876','161875','162040','162140','162171','162234','162677','163649','164117','164118','164988','165446','165619','165620','165696','166089','166199','167248','167711','167895','168123','168125','168126','168140','168196','169216','169217','169218','169219','169224','169818','170190','170692','202853','215948','216013','238721','240281','240699','240700','240701','241197','241198','241199','241362','241382','241404','241593','241656','241657','241669','242761','242762','242830','242831','244445','244447','244448','244892','244893','247116','247553','247754','248568','248792','248802','248836','249361','249362','249386','250482','250691','250874','250987','251142','251143','251197','251402','251440','251642','252117','252137','253049','253056','253074','253746','254876','254969','255026','255155','256460','261789','262323','263012','264875','265909','266601','266646','267120','267343','267812','267813','268118','268392','268458','268558','268559','268560','268604','268638','269229','273326','273526','273801','273810','274253','274272','274467','274867','274893','275082','275811','276518','276678','277169','277475','278094','278163','278196','278996','279209','280564','280601','280734','280781','281651','281652','282202','282275','282448','282876','283311','284205','284378','284405','284406','284407','284408','284909','284910','284911','285219','285224','285855','285862','286229','286240','286364','288389','288761','289370','291616','292314','292380','292766','292807','292821','292868','293203','293425','294071','295939','297347','297475','297833','298168','299103','299112','299266','299267','300334','304026') GROUP BY `resistance_unit` ORDER BY `resistance_unit` ASC