childsstroke: tip
SELECT `tip`,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 `tip` !='' AND `modx_site_content`.`id` IN ('143059','143181','143201','143344','143615','143950','144015','146477','148702','148934','150609','150610','150630','150631','150677','150954','150955','151531','151655','151785','153584','153917','154147','154423','154461','154799','154800','158123','158199','158337','158633','160002','160072','160356','160847','161575','161977','162582','162671','163631','163632','164290','164421','164448','164724','164728','164881','165234','165427','165818','166041','166679','166744','166769','167521','167522','167534','167914','168030','169207','169835','169904','170082','170240','170314','170412','170418','170544','215511','215933','238138','239392','239854','240000','240123','241108','241589','242302','242310','243878','243879','244671','245094','245824','247306','247794','247946','247947','248006','248431','248984','249110','249618','250296','250580','250581','251469','251937','252090','252210','253422','253613','253667','253759','254263','255520','255563','255577','255792','255842','256150','256151','256339','256603','256912','262378','264814','265013','265161','265252','265951','266092','266093','266909','267212','268729','269075','269213','273427','273674','273721','274810','274993','275005','275989','276123','276124','276126','276143','276369','276536','278418','279683','280860','281187','281326','281464','284605','285888','286060','286590','286937','288138','288701','291634','291840','291944','292506','292509','292632','293432','293984','294027','294243','294404','295740','295827','297605','297608','297881','298123','298217','298218','298527','301068','302321','302363','303954') GROUP BY `tip` ORDER BY `tip` ASC
childsstroke1: tip
SELECT `tip`,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 `tip` !='' AND `modx_site_content`.`id` IN ('143059','143181','143201','143344','143615','143950','144015','146477','148702','148934','150609','150610','150630','150631','150677','150954','150955','151531','151655','151785','153584','153917','154147','154423','154461','154799','154800','158123','158199','158337','158633','160002','160072','160356','160847','161575','161977','162582','162671','163631','163632','164290','164421','164448','164724','164728','164881','165234','165427','165818','166041','166679','166744','166769','167521','167522','167534','167914','168030','169207','169835','169904','170082','170240','170314','170412','170418','170544','215511','215933','238138','239392','239854','240000','240123','241108','241589','242302','242310','243878','243879','244671','245094','245824','247306','247794','247946','247947','248006','248431','248984','249110','249618','250296','250580','250581','251469','251937','252090','252210','253422','253613','253667','253759','254263','255520','255563','255577','255792','255842','256150','256151','256339','256603','256912','262378','264814','265013','265161','265252','265951','266092','266093','266909','267212','268729','269075','269213','273427','273674','273721','274810','274993','275005','275989','276123','276124','276126','276143','276369','276536','278418','279683','280860','281187','281326','281464','284605','285888','286060','286590','286937','288138','288701','291634','291840','291944','292506','292509','292632','293984','294027','294243','294404','295740','295827','297605','297608','297881','298123','298217','298218','298527','301068','302321','302363','303954') GROUP BY `tip` ORDER BY `tip` ASC
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 ('143059','143181','143201','143344','143615','143950','144015','146477','148702','148934','150609','150610','150630','150631','150677','150954','150955','151531','151655','151785','153584','153917','154147','154423','154461','154799','154800','158123','158199','158337','158633','160002','160072','160356','160847','161575','161977','162582','162671','163631','163632','164290','164421','164448','164724','164728','164881','165234','165427','165818','166041','166679','166744','166769','167521','167522','167534','167914','168030','169207','169835','169904','170082','170240','170314','170412','170418','170544','215511','215933','238138','239392','239854','240000','240123','241108','241589','242302','242310','243878','243879','244671','245094','245824','247306','247794','247946','247947','248006','248431','248984','249110','249618','250296','250580','250581','251469','251937','252090','252210','253422','253613','253667','253759','254263','255520','255563','255577','255792','255842','256150','256151','256339','256603','256912','262378','264814','265013','265161','265252','265951','266092','266093','266909','267212','268729','269075','269213','273427','273674','273721','274810','274993','275005','275989','276123','276124','276126','276143','276369','276536','278418','279683','280860','281187','281326','281464','284605','285888','286060','286590','286937','288138','288701','291634','291840','291944','292506','292509','292632','293432','293984','294027','294243','294404','295740','295827','297605','297608','297881','298123','298217','298218','298527','301068','302321','302363','303954') 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 ('143059','143181','143201','143344','143615','143950','144015','146477','148702','148934','150609','150610','150630','150631','150677','150954','150955','151531','151655','151785','153584','153917','154147','154423','154461','154799','154800','158123','158199','158337','158633','160002','160072','160356','160847','161575','161977','162582','162671','163631','163632','164290','164421','164448','164724','164728','164881','165234','165427','165818','166041','166679','166744','166769','167521','167522','167534','167914','168030','169207','169835','169904','170082','170240','170314','170412','170418','170544','215511','215933','238138','239392','239854','240000','240123','241108','241589','242302','242310','243878','243879','244671','245094','245824','247306','247794','247946','247947','248006','248431','248984','249110','249618','250296','250580','250581','251469','251937','252090','252210','253422','253613','253667','253759','254263','255520','255563','255577','255792','255842','256150','256151','256339','256603','256912','262378','264814','265013','265161','265252','265951','266092','266093','266909','267212','268729','269075','269213','273427','273674','273721','274810','274993','275005','275989','276123','276124','276126','276143','276369','276536','278418','279683','280860','281187','281326','281464','284605','285888','286060','286590','286937','288138','288701','291634','291840','291944','292506','292509','292632','293984','294027','294243','294404','295740','295827','297605','297608','297881','298123','298217','298218','298527','301068','302321','302363','303954') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: packages
SELECT `packages`,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 `packages` !='' AND `modx_site_content`.`id` IN ('143059','143181','143201','143344','143615','143950','144015','146477','148702','148934','150609','150610','150630','150631','150677','150954','150955','151531','151655','151785','153584','153917','154147','154423','154461','154799','154800','158123','158199','158337','158633','160002','160072','160356','160847','161575','161977','162582','162671','163631','163632','164290','164421','164448','164724','164728','164881','165234','165427','165818','166041','166679','166744','166769','167521','167522','167534','167914','168030','169207','169835','169904','170082','170240','170314','170412','170418','170544','215511','215933','238138','239392','239854','240000','240123','241108','241589','242302','242310','243878','243879','244671','245094','245824','247306','247794','247946','247947','248006','248431','248984','249110','249618','250296','250580','250581','251469','251937','252090','252210','253422','253613','253667','253759','254263','255520','255563','255577','255792','255842','256150','256151','256339','256603','256912','262378','264814','265013','265161','265252','265951','266092','266093','266909','267212','268729','269075','269213','273427','273674','273721','274810','274993','275005','275989','276123','276124','276126','276143','276369','276536','278418','279683','280860','281187','281326','281464','284605','285888','286060','286590','286937','288138','288701','291634','291840','291944','292506','292509','292632','293432','293984','294027','294243','294404','295740','295827','297605','297608','297881','298123','298217','298218','298527','301068','302321','302363','303954') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke1: packages
SELECT `packages`,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 `packages` !='' AND `modx_site_content`.`id` IN ('143059','143181','143201','143344','143615','143950','144015','146477','148702','148934','150609','150610','150630','150631','150677','150954','150955','151531','151655','151785','153584','153917','154147','154423','154461','154799','154800','158123','158199','158337','158633','160002','160072','160356','160847','161575','161977','162582','162671','163631','163632','164290','164421','164448','164724','164728','164881','165234','165427','165818','166041','166679','166744','166769','167521','167522','167534','167914','168030','169207','169835','169904','170082','170240','170314','170412','170418','170544','215511','215933','238138','239392','239854','240000','240123','241108','241589','242302','242310','243878','243879','244671','245094','245824','247306','247794','247946','247947','248006','248431','248984','249110','249618','250296','250580','250581','251469','251937','252090','252210','253422','253613','253667','253759','254263','255520','255563','255577','255792','255842','256150','256151','256339','256603','256912','262378','264814','265013','265161','265252','265951','266092','266093','266909','267212','268729','269075','269213','273427','273674','273721','274810','274993','275005','275989','276123','276124','276126','276143','276369','276536','278418','279683','280860','281187','281326','281464','284605','285888','286060','286590','286937','288138','288701','291634','291840','291944','292506','292509','292632','293984','294027','294243','294404','295740','295827','297605','297608','297881','298123','298217','298218','298527','301068','302321','302363','303954') GROUP BY `packages` ORDER BY `packages` ASC