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 ('153579','158539','158653','158820','159101','159804','159842','159843','159959','159960','160143','160563','160579','160660','160712','161541','161595','161762','163330','163516','163642','163840','163949','164870','165487','165489','166430','166486','166922','167226','167629','167940','168018','168296','232448','238934','239398','239487','239592','239607','239647','239907','239929','240468','240590','241074','241075','241096','241587','241610','241791','241852','241884','241885','241898','241958','242676','242879','243027','243035','243053','243054','243055','243201','243224','243634','243635','243647','244069','244222','244390','244438','244849','245360','246066','246173','246220','246737','246780','246781','246822','247249','247290','247906','248281','248715','248818','249374','249554','249721','249760','250167','250354','250681','250905','251030','251371','251854','251890','251972','252165','253043','253683','253702','253732','253761','253807','254348','254365','254472','254623','254633','254767','254947','255423','255639','255652','256586','256602','262178','262243','262651','262738','262739','263533','263579','264361','264470','264521','264555','264731','264931','264959','265281','265319','265321','265408','265490','265498','265519','265955','266006','266455','266560','266818','266952','267352','267447','267624','267865','267875','267876','267877','267915','267916','267919','267937','268449','268450','268489','268499','268524','268527','268605','268776','269173','269183','269592','269627','273309','273411','273764','273859','273905','273906','274028','274090','274277','274328','274423','274825','275221','275510','275523','275947','276368','276545','276663','277019','277811','277812','277813','277879','277880','277881','277898','278195','278203','278306','278423','278498','278689','279448','279538','279539','279544','279545','279546','279555','279556','279557','279713','280480','280481','280537','280833','280877','280890','281747','281754','282103','282774','282805','282807','282808','282809','283145','283220','283592','283607','283713','284950','285007','285074','285433','285756','285768','286058','286596','286821','286982','287230','287564','287565','287566','287567','287568','287569','287570','287571','287572','287573','287574','287575','287576','287577','287578','287579','287580','287581','287582','287583','287584','287585','287586','287587','287588','287589','287590','287591','287592','287593','287594','287595','287596','287597','287598','287599','287600','287601','287602','287603','287604','287605','287606','287607','287608','287609','287610','287611','287612','287613','287614','287615','287616','287617','287618','287619','287620','287621','287622','287623','287624','287625','287626','287627','287628','287629','287630','287631','287632','287633','287634','287635','287636','287637','287638','287639','287640','287641','287642','287643','287644','287645','287646','287647','287648','287649','287650','287651','287652','287653','287654','287655','287656','287657','287658','287659','287660','287661','287662','287663','287664','287665','287666','287667','287668','287669','287670','287671','287672','287673','287674','287675','287676','287677','287678','287679','287680','287681','287682','287683','287684','287685','287686','287687','287688','287689','287690','287691','287692','287693','287694','287695','287696','287697','287698','287699','287700','287701','287702','287703','287704','287705','287706','287707','287708','287709','287710','287711','287712','287713','287714','287715','287716','287717','287718','287719','287720','287721','287722','287723','287724','287725','287726','287727','287728','287729','287730','287731','287732','287733','287734','287735','287736','287737','287738','287739','287740','287741','287742','287743','287744','287745','287746','287747','287748','287749','287750','287751','287752','287753','287754','287755','287756','287757','287758','287774','288419','288436','288446','288483','288567','288692','288708','288835','289018','289240','289256','289417','291895','292051','292402','292543','293888','294427','295597','295664','296246','297418','297544','297639','297991','298302','299114','299161','299429','299660','299685','299686','299742','300427','300576','300659','301899','301900','303809','303810','303811','303812','303813') 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 ('153579','158539','158653','158820','159101','159804','159842','159843','159959','159960','160143','160563','160579','160660','160712','161541','161595','161762','163330','163516','163642','163840','163949','164870','165487','165489','166430','166486','166922','167226','167629','167940','168018','168296','232448','238934','239398','239487','239592','239607','239647','239907','239929','240468','240590','241074','241075','241096','241587','241610','241791','241852','241884','241885','241898','241958','242676','242879','243027','243035','243053','243054','243055','243201','243224','243634','243635','243647','244069','244222','244390','244438','244849','245360','246066','246173','246220','246737','246780','246781','246822','247249','247290','247906','248281','248715','248818','249374','249554','249721','249760','250167','250354','250681','250905','251030','251371','251854','251890','251972','252165','253043','253683','253702','253732','253761','253807','254348','254365','254472','254623','254633','254767','254947','255423','255639','255652','256586','256602','262178','262243','262651','262738','262739','263533','263579','264361','264470','264521','264555','264731','264931','264959','265281','265319','265321','265408','265490','265498','265519','265955','266006','266455','266560','266818','266952','267352','267447','267624','267865','267875','267876','267877','267915','267916','267919','267937','268449','268450','268489','268499','268524','268527','268605','268776','269173','269183','269592','269627','273309','273411','273764','273859','273905','273906','274028','274090','274277','274328','274423','274825','275221','275510','275523','275947','276368','276545','276663','277019','277811','277812','277813','277879','277880','277881','277898','278195','278203','278306','278423','278498','278689','279448','279538','279539','279544','279545','279546','279555','279556','279557','279713','280480','280481','280537','280833','280877','280890','281747','281754','282103','282774','282805','282807','282808','282809','283145','283220','283592','283607','283713','284950','285007','285074','285433','285756','285768','286058','286596','286821','286982','287230','287564','287565','287566','287567','287568','287569','287570','287571','287572','287573','287574','287575','287576','287577','287578','287579','287580','287581','287582','287583','287584','287585','287586','287587','287588','287589','287590','287591','287592','287593','287594','287595','287596','287597','287598','287599','287600','287601','287602','287603','287604','287605','287606','287607','287608','287609','287610','287611','287612','287613','287614','287615','287616','287617','287618','287619','287620','287621','287622','287623','287624','287625','287626','287627','287628','287629','287630','287631','287632','287633','287634','287635','287636','287637','287638','287639','287640','287641','287642','287643','287644','287645','287646','287647','287648','287649','287650','287651','287652','287653','287654','287655','287656','287657','287658','287659','287660','287661','287662','287663','287664','287665','287666','287667','287668','287669','287670','287671','287672','287673','287674','287675','287676','287677','287678','287679','287680','287681','287682','287683','287684','287685','287686','287687','287688','287689','287690','287691','287692','287693','287694','287695','287696','287697','287698','287699','287700','287701','287702','287703','287704','287705','287706','287707','287708','287709','287710','287711','287712','287713','287714','287715','287716','287717','287718','287719','287720','287721','287722','287723','287724','287725','287726','287727','287728','287729','287730','287731','287732','287733','287734','287735','287736','287737','287738','287739','287740','287741','287742','287743','287744','287745','287746','287747','287748','287749','287750','287751','287752','287753','287754','287755','287756','287757','287758','287774','288419','288436','288446','288483','288567','288692','288708','288835','289018','289240','289256','289417','291895','292051','292402','292543','293888','294427','295597','295664','296246','297418','297544','297639','297991','298302','299114','299161','299429','299660','299685','299686','299742','300427','300576','300659','301899','301900','303809','303810','303811','303812','303813') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: gabarity
SELECT `gabarity`,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 `gabarity` !='' AND `modx_site_content`.`id` IN ('153579','158539','158653','158820','159101','159804','159842','159843','159959','159960','160143','160563','160579','160660','160712','161541','161595','161762','163330','163516','163642','163840','163949','164870','165487','165489','166430','166486','166922','167226','167629','167940','168018','168296','232448','238934','239398','239487','239592','239607','239647','239907','239929','240468','240590','241074','241075','241096','241587','241610','241791','241852','241884','241885','241898','241958','242676','242879','243027','243035','243053','243054','243055','243201','243224','243634','243635','243647','244069','244222','244390','244438','244849','245360','246066','246173','246220','246737','246780','246781','246822','247249','247290','247906','248281','248715','248818','249374','249554','249721','249760','250167','250354','250681','250905','251030','251371','251854','251890','251972','252165','253043','253683','253702','253732','253761','253807','254348','254365','254472','254623','254633','254767','254947','255423','255639','255652','256586','256602','262178','262243','262651','262738','262739','263533','263579','264361','264470','264521','264555','264731','264931','264959','265281','265319','265321','265408','265490','265498','265519','265955','266006','266455','266560','266818','266952','267352','267447','267624','267865','267875','267876','267877','267915','267916','267919','267937','268449','268450','268489','268499','268524','268527','268605','268776','269173','269183','269592','269627','273309','273411','273764','273859','273905','273906','274028','274090','274277','274328','274423','274825','275221','275510','275523','275947','276368','276545','276663','277019','277811','277812','277813','277879','277880','277881','277898','278195','278203','278306','278423','278498','278689','279448','279538','279539','279544','279545','279546','279555','279556','279557','279713','280480','280481','280537','280833','280877','280890','281747','281754','282103','282774','282805','282807','282808','282809','283145','283220','283592','283607','283713','284950','285007','285074','285433','285756','285768','286058','286596','286821','286982','287230','287564','287565','287566','287567','287568','287569','287570','287571','287572','287573','287574','287575','287576','287577','287578','287579','287580','287581','287582','287583','287584','287585','287586','287587','287588','287589','287590','287591','287592','287593','287594','287595','287596','287597','287598','287599','287600','287601','287602','287603','287604','287605','287606','287607','287608','287609','287610','287611','287612','287613','287614','287615','287616','287617','287618','287619','287620','287621','287622','287623','287624','287625','287626','287627','287628','287629','287630','287631','287632','287633','287634','287635','287636','287637','287638','287639','287640','287641','287642','287643','287644','287645','287646','287647','287648','287649','287650','287651','287652','287653','287654','287655','287656','287657','287658','287659','287660','287661','287662','287663','287664','287665','287666','287667','287668','287669','287670','287671','287672','287673','287674','287675','287676','287677','287678','287679','287680','287681','287682','287683','287684','287685','287686','287687','287688','287689','287690','287691','287692','287693','287694','287695','287696','287697','287698','287699','287700','287701','287702','287703','287704','287705','287706','287707','287708','287709','287710','287711','287712','287713','287714','287715','287716','287717','287718','287719','287720','287721','287722','287723','287724','287725','287726','287727','287728','287729','287730','287731','287732','287733','287734','287735','287736','287737','287738','287739','287740','287741','287742','287743','287744','287745','287746','287747','287748','287749','287750','287751','287752','287753','287754','287755','287756','287757','287758','287774','288419','288436','288446','288483','288567','288692','288708','288835','289018','289240','289256','289417','291895','292051','292402','292543','293888','294427','295597','295664','296246','297418','297544','297639','297991','298302','299114','299161','299429','299660','299685','299686','299742','300427','300576','300659','301899','301900','303809','303810','303811','303812','303813') GROUP BY `gabarity` ORDER BY `gabarity` ASC
childsstroke1: gabarity
SELECT `gabarity`,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 `gabarity` !='' AND `modx_site_content`.`id` IN ('153579','158539','158653','158820','159101','159804','159842','159843','159959','159960','160143','160563','160579','160660','160712','161541','161595','161762','163330','163516','163642','163840','163949','164870','165487','165489','166430','166486','166922','167226','167629','167940','168018','168296','232448','238934','239398','239487','239592','239607','239647','239907','239929','240468','240590','241074','241075','241096','241587','241610','241791','241852','241884','241885','241898','241958','242676','242879','243027','243035','243053','243054','243055','243201','243224','243634','243635','243647','244069','244222','244390','244438','244849','245360','246066','246173','246220','246737','246780','246781','246822','247249','247290','247906','248281','248715','248818','249374','249554','249721','249760','250167','250354','250681','250905','251030','251371','251854','251890','251972','252165','253043','253683','253702','253732','253761','253807','254348','254365','254472','254623','254633','254767','254947','255423','255639','255652','256586','256602','262178','262243','262651','262738','262739','263533','263579','264361','264470','264521','264555','264731','264931','264959','265281','265319','265321','265408','265490','265498','265519','265955','266006','266455','266560','266818','266952','267352','267447','267624','267865','267875','267876','267877','267915','267916','267919','267937','268449','268450','268489','268499','268524','268527','268605','268776','269173','269183','269592','269627','273309','273411','273764','273859','273905','273906','274028','274090','274277','274328','274423','274825','275221','275510','275523','275947','276368','276545','276663','277019','277811','277812','277813','277879','277880','277881','277898','278195','278203','278306','278423','278498','278689','279448','279538','279539','279544','279545','279546','279555','279556','279557','279713','280480','280481','280537','280833','280877','280890','281747','281754','282103','282774','282805','282807','282808','282809','283145','283220','283592','283607','283713','284950','285007','285074','285433','285756','285768','286058','286596','286821','286982','287230','287564','287565','287566','287567','287568','287569','287570','287571','287572','287573','287574','287575','287576','287577','287578','287579','287580','287581','287582','287583','287584','287585','287586','287587','287588','287589','287590','287591','287592','287593','287594','287595','287596','287597','287598','287599','287600','287601','287602','287603','287604','287605','287606','287607','287608','287609','287610','287611','287612','287613','287614','287615','287616','287617','287618','287619','287620','287621','287622','287623','287624','287625','287626','287627','287628','287629','287630','287631','287632','287633','287634','287635','287636','287637','287638','287639','287640','287641','287642','287643','287644','287645','287646','287647','287648','287649','287650','287651','287652','287653','287654','287655','287656','287657','287658','287659','287660','287661','287662','287663','287664','287665','287666','287667','287668','287669','287670','287671','287672','287673','287674','287675','287676','287677','287678','287679','287680','287681','287682','287683','287684','287685','287686','287687','287688','287689','287690','287691','287692','287693','287694','287695','287696','287697','287698','287699','287700','287701','287702','287703','287704','287705','287706','287707','287708','287709','287710','287711','287712','287713','287714','287715','287716','287717','287718','287719','287720','287721','287722','287723','287724','287725','287726','287727','287728','287729','287730','287731','287732','287733','287734','287735','287736','287737','287738','287739','287740','287741','287742','287743','287744','287745','287746','287747','287748','287749','287750','287751','287752','287753','287754','287755','287756','287757','287758','287774','288419','288436','288446','288483','288567','288692','288708','288835','289018','289240','289256','289417','291895','292051','292402','292543','293888','294427','295597','295664','296246','297418','297544','297639','297991','298302','299114','299161','299429','299660','299685','299686','299742','300427','300576','300659','301899','301900','303809','303810','303811','303812','303813') GROUP BY `gabarity` ORDER BY `gabarity` ASC
