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 ('158','142938','143052','143313','147081','148896','149597','149598','149599','149600','149601','151267','151600','151601','151602','151603','151604','151607','151608','151611','151612','151614','151693','151694','151751','151759','151760','151761','151794','153806','154220','158382','158639','159300','159310','159311','159560','159714','159805','159901','160088','160155','160329','160330','160528','161191','161787','161788','161801','161804','162087','162088','162089','162165','162166','163102','163864','164126','165928','165968','166151','166332','166560','166632','167029','167119','167120','167121','167122','167123','167124','167195','167196','167197','167289','167290','167338','167880','167881','168150','168248','168304','202624','204050','204051','204052','204053','204054','204055','204056','204057','204058','204059','204060','204061','204062','204063','204064','204065','204066','204067','204068','204069','204070','204071','204072','204073','204074','204075','204076','204077','204078','204079','204080','204081','204082','204083','204084','204085','204086','204087','204088','204089','204090','204091','204092','204093','204094','204095','204096','204097','204098','204099','204100','204101','204102','204103','204104','204105','204106','204107','204108','204109','204110','204111','204112','204113','204114','204115','204116','204117','204118','204119','204120','204121','204122','204123','204124','204125','204126','204127','204128','204129','204130','204131','204132','204133','204134','204135','204136','204137','204138','204139','204140','204141','204142','204143','204144','204145','204146','204147','204148','204149','204150','204151','204152','204153','204154','204155','204156','204157','204158','204159','204160','204161','204162','204163','204164','204165','204166','204167','204168','204169','204170','204171','204172','204173','204174','204175','204176','204177','204178','204179','204180','204181','204182','204183','204184','204185','204186','204187','204188','204189','204190','204191','204192','204193','204194','204195','204196','204197','204198','204199','204200','204201','204202','204203','204204','204205','204206','204207','210217','210218','210219','210220','210221','210222','210223','210224','210225','210226','210227','210228','210229','210230','210231','210232','210233','210234','210235','210236','210237','210238','210239','210240','210241','210242','210243','210244','210245','210246','210247','210248','210249','210250','210251','210252','210253','210254','210255','210256','210257','210258','210259','210260','210261','210262','210263','210264','210265','210266','210267','210268','210269','210270','210271','210272','210273','210274','210275','210276','210277','210278','210279','210280','210281','210282','210283','210284','210285','210286','210287','210288','210289','210290','210291','210292','210293','210294','210295','210296','210297','210298','210299','210300','210301','210302','210303','210304','210305','210306','210307','210308','210309','210310','210311','210312','210313','210314','210315','210316','210317','210318','210319','210320','210321','210322','210323','215262','215615','215873','215888','215950','215951','219764','232609','232656','232707','238955','239606','239789','239796','239850','239889','239905','239954','239955','239957','240157','240246','240454','240461','240914','241025','241035','241043','241044','241045','241046','241047','241048','241049','241050','241051','241052','241053','241054','241055','241062','241343','241344','241345','241377','241378','241380','241381','241546','241548','241549','241569','241575','241679','241682','241688','241689','241744','241848','241890','241892','241932','241933','241934','241935','241936','241937','241938','242048','242178','242179','242180','242181','242182','242183','242475','242476','242812','242817','242818','243136','243284','243285','243286','243719','244101','244285','244319','244407','244408','244409','244410','244411','244412','244413','244414','244415','244416','244417','244418','244419','244420','244421','244422','244423','244444','244678','244700','244919','244934','245195','245205','245322','245542','245664','245819','246046','246428','246975','247702','247736','248730','248759','248762','249006','249395','249396','249498','249740','249847','249917','249918','249919','250258','250271','250272','250275','250473','250679','251282','251968','251998','251999','252000','253058','253116','253119','253343','253423','253500','253624','253625','253673','253704','254566','254707','254720','254906','254971','255371','255881','256026','256027','256028','256029','256030','256031','256032','256033','256034','256035','256036','256037','256038','256039','256040','256041','256042','256043','256044','256045','256046','256047','256048','256049','256050','256051','256052','256053','256054','256055','256059','256814','261974','261991','261995','262251','262300','262668','263091','263105','263106','263107','263108','263118','263141','263480','263745','264419','264448','264686','265150','265363','265503','265638','265639','265640','265641','265642','265643','265644','265645','265646','265647','265648','265649','265650','265651','265652','265653','265654','265655','265656','265714','265715','265716','265717','265718','265719','265720','265721','265722','265723','265724','265725','265726','265727','265728','265729','265730','265731','265732','265733','265734','265735','265961','265989','265990','266184','266328','266329','266389','266582','266625','266750','266751','266763','266764','266906','266914','267161','267320','267394','267508','267811','268070','268614','268796','268797','269067','273520','273540','273563','274099','274648','274651','274726','274727','274902','275204','275517','275518','275519','275520','275598','275656','275837','276207','276533','276604','276641','276645','277026','277522','277901','278120','278407','278839','279402','279427','279635','280464','280533','280916','280936','281114','281426','281739','282423','282475','282509','282827','283119','283312','284130','284229','285016','285279','285483','285484','285485','285486','285654','285666','285847','285859','286650','286659','287226','287385','288333','288650','288759','289099','292052','292237','292238','292460','292461','292462','292575','293229','293878','293879','293929','294157','294348','295539','295575','295634','295713','295714','295716','295717','295718','295796','295933','296256','297135','297147','297206','298095','298233','298408','299637','299846','299847','300001','300203','300307','300358','300422','300545','302252','302294') 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 ('142938','143052','143313','147081','148896','149597','149598','149599','149600','149601','151267','151600','151601','151602','151603','151604','151607','151608','151611','151612','151614','151693','151694','151751','151759','151760','151761','151794','153806','154220','158382','158639','159300','159310','159311','159560','159714','159805','159901','160088','160155','160329','160330','160528','161191','161787','161788','161801','161804','162087','162088','162089','162165','162166','163102','163864','164126','165928','165968','166151','166332','166560','166632','167029','167119','167120','167121','167122','167123','167124','167195','167196','167197','167289','167290','167338','167880','167881','168150','168248','168304','202624','204050','204051','204052','204053','204054','204055','204056','204057','204058','204059','204060','204061','204062','204063','204064','204065','204066','204067','204068','204069','204070','204071','204072','204073','204074','204075','204076','204077','204078','204079','204080','204081','204082','204083','204084','204085','204086','204087','204088','204089','204090','204091','204092','204093','204094','204095','204096','204097','204098','204099','204100','204101','204102','204103','204104','204105','204106','204107','204108','204109','204110','204111','204112','204113','204114','204115','204116','204117','204118','204119','204120','204121','204122','204123','204124','204125','204126','204127','204128','204129','204130','204131','204132','204133','204134','204135','204136','204137','204138','204139','204140','204141','204142','204143','204144','204145','204146','204147','204148','204149','204150','204151','204152','204153','204154','204155','204156','204157','204158','204159','204160','204161','204162','204163','204164','204165','204166','204167','204168','204169','204170','204171','204172','204173','204174','204175','204176','204177','204178','204179','204180','204181','204182','204183','204184','204185','204186','204187','204188','204189','204190','204191','204192','204193','204194','204195','204196','204197','204198','204199','204200','204201','204202','204203','204204','204205','204206','204207','210217','210218','210219','210220','210221','210222','210223','210224','210225','210226','210227','210228','210229','210230','210231','210232','210233','210234','210235','210236','210237','210238','210239','210240','210241','210242','210243','210244','210245','210246','210247','210248','210249','210250','210251','210252','210253','210254','210255','210256','210257','210258','210259','210260','210261','210262','210263','210264','210265','210266','210267','210268','210269','210270','210271','210272','210273','210274','210275','210276','210277','210278','210279','210280','210281','210282','210283','210284','210285','210286','210287','210288','210289','210290','210291','210292','210293','210294','210295','210296','210297','210298','210299','210300','210301','210302','210303','210304','210305','210306','210307','210308','210309','210310','210311','210312','210313','210314','210315','210316','210317','210318','210319','210320','210321','210322','210323','215262','215615','215873','215888','215950','215951','219764','232609','232656','232707','238955','239606','239789','239796','239850','239889','239905','239954','239955','239957','240157','240246','240454','240461','240914','241025','241035','241043','241044','241045','241046','241047','241048','241049','241050','241051','241052','241053','241054','241055','241062','241343','241344','241345','241377','241378','241380','241381','241546','241548','241549','241569','241575','241679','241682','241688','241689','241744','241848','241890','241892','241932','241933','241934','241935','241936','241937','241938','242048','242178','242179','242180','242181','242182','242183','242475','242476','242812','242817','242818','243136','243284','243285','243286','243719','244101','244285','244319','244407','244408','244409','244410','244411','244412','244413','244414','244415','244416','244417','244418','244419','244420','244421','244422','244423','244444','244678','244700','244919','244934','245195','245205','245322','245542','245664','245819','246046','246428','246975','247702','247736','248730','248759','248762','249006','249395','249396','249498','249740','249847','249917','249918','249919','250258','250271','250272','250275','250473','250679','251282','251968','251998','251999','252000','253058','253116','253119','253343','253423','253500','253624','253625','253673','253704','254566','254707','254720','254906','254971','255371','255881','256026','256027','256028','256029','256030','256031','256032','256033','256034','256035','256036','256037','256038','256039','256040','256041','256042','256043','256044','256045','256046','256047','256048','256049','256050','256051','256052','256053','256054','256055','256059','256814','261974','261991','261995','262251','262300','262668','263091','263105','263106','263107','263108','263118','263141','263480','263745','264419','264448','264686','265150','265363','265503','265638','265639','265640','265641','265642','265643','265644','265645','265646','265647','265648','265649','265650','265651','265652','265653','265654','265655','265656','265714','265715','265716','265717','265718','265719','265720','265721','265722','265723','265724','265725','265726','265727','265728','265729','265730','265731','265732','265733','265734','265735','265961','265989','265990','266184','266328','266329','266389','266582','266625','266750','266751','266763','266764','266906','266914','267161','267320','267394','267508','267811','268070','268614','268796','268797','269067','273520','273540','273563','274099','274648','274651','274726','274727','274902','275204','275517','275518','275519','275520','275598','275656','275837','276207','276533','276604','276641','276645','277026','277522','277901','278120','278407','278839','279402','279427','279635','280464','280533','280916','280936','281114','281426','281739','282423','282475','282509','282827','283119','283312','284130','284229','285016','285279','285483','285484','285485','285486','285654','285666','285847','285859','286650','286659','287226','287385','288333','288650','288759','289099','292052','292237','292238','292460','292461','292462','292575','293229','293878','293879','293929','294157','294348','295539','295575','295634','295713','295714','295716','295717','295718','295796','295933','296256','297135','297147','297206','298095','298233','298408','299637','299846','299847','300001','300203','300307','300358','300422','300545','302252','302294') GROUP BY `manuf` ORDER BY `manuf` ASC
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 ('158','142938','143052','143313','147081','148896','149597','149598','149599','149600','149601','151267','151600','151601','151602','151603','151604','151607','151608','151611','151612','151614','151693','151694','151751','151759','151760','151761','151794','153806','154220','158382','158639','159300','159310','159311','159560','159714','159805','159901','160088','160155','160329','160330','160528','161191','161787','161788','161801','161804','162087','162088','162089','162165','162166','163102','163864','164126','165928','165968','166151','166332','166560','166632','167029','167119','167120','167121','167122','167123','167124','167195','167196','167197','167289','167290','167338','167880','167881','168150','168248','168304','202624','204050','204051','204052','204053','204054','204055','204056','204057','204058','204059','204060','204061','204062','204063','204064','204065','204066','204067','204068','204069','204070','204071','204072','204073','204074','204075','204076','204077','204078','204079','204080','204081','204082','204083','204084','204085','204086','204087','204088','204089','204090','204091','204092','204093','204094','204095','204096','204097','204098','204099','204100','204101','204102','204103','204104','204105','204106','204107','204108','204109','204110','204111','204112','204113','204114','204115','204116','204117','204118','204119','204120','204121','204122','204123','204124','204125','204126','204127','204128','204129','204130','204131','204132','204133','204134','204135','204136','204137','204138','204139','204140','204141','204142','204143','204144','204145','204146','204147','204148','204149','204150','204151','204152','204153','204154','204155','204156','204157','204158','204159','204160','204161','204162','204163','204164','204165','204166','204167','204168','204169','204170','204171','204172','204173','204174','204175','204176','204177','204178','204179','204180','204181','204182','204183','204184','204185','204186','204187','204188','204189','204190','204191','204192','204193','204194','204195','204196','204197','204198','204199','204200','204201','204202','204203','204204','204205','204206','204207','210217','210218','210219','210220','210221','210222','210223','210224','210225','210226','210227','210228','210229','210230','210231','210232','210233','210234','210235','210236','210237','210238','210239','210240','210241','210242','210243','210244','210245','210246','210247','210248','210249','210250','210251','210252','210253','210254','210255','210256','210257','210258','210259','210260','210261','210262','210263','210264','210265','210266','210267','210268','210269','210270','210271','210272','210273','210274','210275','210276','210277','210278','210279','210280','210281','210282','210283','210284','210285','210286','210287','210288','210289','210290','210291','210292','210293','210294','210295','210296','210297','210298','210299','210300','210301','210302','210303','210304','210305','210306','210307','210308','210309','210310','210311','210312','210313','210314','210315','210316','210317','210318','210319','210320','210321','210322','210323','215262','215615','215873','215888','215950','215951','219764','232609','232656','232707','238955','239606','239789','239796','239850','239889','239905','239954','239955','239957','240157','240246','240454','240461','240914','241025','241035','241043','241044','241045','241046','241047','241048','241049','241050','241051','241052','241053','241054','241055','241062','241343','241344','241345','241377','241378','241380','241381','241546','241548','241549','241569','241575','241679','241682','241688','241689','241744','241848','241890','241892','241932','241933','241934','241935','241936','241937','241938','242048','242178','242179','242180','242181','242182','242183','242475','242476','242812','242817','242818','243136','243284','243285','243286','243719','244101','244285','244319','244407','244408','244409','244410','244411','244412','244413','244414','244415','244416','244417','244418','244419','244420','244421','244422','244423','244444','244678','244700','244919','244934','245195','245205','245322','245542','245664','245819','246046','246428','246975','247702','247736','248730','248759','248762','249006','249395','249396','249498','249740','249847','249917','249918','249919','250258','250271','250272','250275','250473','250679','251282','251968','251998','251999','252000','253058','253116','253119','253343','253423','253500','253624','253625','253673','253704','254566','254707','254720','254906','254971','255371','255881','256026','256027','256028','256029','256030','256031','256032','256033','256034','256035','256036','256037','256038','256039','256040','256041','256042','256043','256044','256045','256046','256047','256048','256049','256050','256051','256052','256053','256054','256055','256059','256814','261974','261991','261995','262251','262300','262668','263091','263105','263106','263107','263108','263118','263141','263480','263745','264419','264448','264686','265150','265363','265503','265638','265639','265640','265641','265642','265643','265644','265645','265646','265647','265648','265649','265650','265651','265652','265653','265654','265655','265656','265714','265715','265716','265717','265718','265719','265720','265721','265722','265723','265724','265725','265726','265727','265728','265729','265730','265731','265732','265733','265734','265735','265961','265989','265990','266184','266328','266329','266389','266582','266625','266750','266751','266763','266764','266906','266914','267161','267320','267394','267508','267811','268070','268614','268796','268797','269067','273520','273540','273563','274099','274648','274651','274726','274727','274902','275204','275517','275518','275519','275520','275598','275656','275837','276207','276533','276604','276641','276645','277026','277522','277901','278120','278407','278839','279402','279427','279635','280464','280533','280916','280936','281114','281426','281739','282423','282475','282509','282827','283119','283312','284130','284229','285016','285279','285483','285484','285485','285486','285654','285666','285847','285859','286650','286659','287226','287385','288333','288650','288759','289099','292052','292237','292238','292460','292461','292462','292575','293229','293878','293879','293929','294157','294348','295539','295575','295634','295713','295714','295716','295717','295718','295796','295933','296256','297135','297147','297206','298095','298233','298408','299637','299846','299847','300001','300203','300307','300358','300422','300545','302252','302294') 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 ('142938','143052','143313','147081','148896','149597','149598','149599','149600','149601','151267','151600','151601','151602','151603','151604','151607','151608','151611','151612','151614','151693','151694','151751','151759','151760','151761','151794','153806','154220','158382','158639','159300','159310','159311','159560','159714','159805','159901','160088','160155','160329','160330','160528','161191','161787','161788','161801','161804','162087','162088','162089','162165','162166','163102','163864','164126','165928','165968','166151','166332','166560','166632','167029','167119','167120','167121','167122','167123','167124','167195','167196','167197','167289','167290','167338','167880','167881','168150','168248','168304','202624','204050','204051','204052','204053','204054','204055','204056','204057','204058','204059','204060','204061','204062','204063','204064','204065','204066','204067','204068','204069','204070','204071','204072','204073','204074','204075','204076','204077','204078','204079','204080','204081','204082','204083','204084','204085','204086','204087','204088','204089','204090','204091','204092','204093','204094','204095','204096','204097','204098','204099','204100','204101','204102','204103','204104','204105','204106','204107','204108','204109','204110','204111','204112','204113','204114','204115','204116','204117','204118','204119','204120','204121','204122','204123','204124','204125','204126','204127','204128','204129','204130','204131','204132','204133','204134','204135','204136','204137','204138','204139','204140','204141','204142','204143','204144','204145','204146','204147','204148','204149','204150','204151','204152','204153','204154','204155','204156','204157','204158','204159','204160','204161','204162','204163','204164','204165','204166','204167','204168','204169','204170','204171','204172','204173','204174','204175','204176','204177','204178','204179','204180','204181','204182','204183','204184','204185','204186','204187','204188','204189','204190','204191','204192','204193','204194','204195','204196','204197','204198','204199','204200','204201','204202','204203','204204','204205','204206','204207','210217','210218','210219','210220','210221','210222','210223','210224','210225','210226','210227','210228','210229','210230','210231','210232','210233','210234','210235','210236','210237','210238','210239','210240','210241','210242','210243','210244','210245','210246','210247','210248','210249','210250','210251','210252','210253','210254','210255','210256','210257','210258','210259','210260','210261','210262','210263','210264','210265','210266','210267','210268','210269','210270','210271','210272','210273','210274','210275','210276','210277','210278','210279','210280','210281','210282','210283','210284','210285','210286','210287','210288','210289','210290','210291','210292','210293','210294','210295','210296','210297','210298','210299','210300','210301','210302','210303','210304','210305','210306','210307','210308','210309','210310','210311','210312','210313','210314','210315','210316','210317','210318','210319','210320','210321','210322','210323','215262','215615','215873','215888','215950','215951','219764','232609','232656','232707','238955','239606','239789','239796','239850','239889','239905','239954','239955','239957','240157','240246','240454','240461','240914','241025','241035','241043','241044','241045','241046','241047','241048','241049','241050','241051','241052','241053','241054','241055','241062','241343','241344','241345','241377','241378','241380','241381','241546','241548','241549','241569','241575','241679','241682','241688','241689','241744','241848','241890','241892','241932','241933','241934','241935','241936','241937','241938','242048','242178','242179','242180','242181','242182','242183','242475','242476','242812','242817','242818','243136','243284','243285','243286','243719','244101','244285','244319','244407','244408','244409','244410','244411','244412','244413','244414','244415','244416','244417','244418','244419','244420','244421','244422','244423','244444','244678','244700','244919','244934','245195','245205','245322','245542','245664','245819','246046','246428','246975','247702','247736','248730','248759','248762','249006','249395','249396','249498','249740','249847','249917','249918','249919','250258','250271','250272','250275','250473','250679','251282','251968','251998','251999','252000','253058','253116','253119','253343','253423','253500','253624','253625','253673','253704','254566','254707','254720','254906','254971','255371','255881','256026','256027','256028','256029','256030','256031','256032','256033','256034','256035','256036','256037','256038','256039','256040','256041','256042','256043','256044','256045','256046','256047','256048','256049','256050','256051','256052','256053','256054','256055','256059','256814','261974','261991','261995','262251','262300','262668','263091','263105','263106','263107','263108','263118','263141','263480','263745','264419','264448','264686','265150','265363','265503','265638','265639','265640','265641','265642','265643','265644','265645','265646','265647','265648','265649','265650','265651','265652','265653','265654','265655','265656','265714','265715','265716','265717','265718','265719','265720','265721','265722','265723','265724','265725','265726','265727','265728','265729','265730','265731','265732','265733','265734','265735','265961','265989','265990','266184','266328','266329','266389','266582','266625','266750','266751','266763','266764','266906','266914','267161','267320','267394','267508','267811','268070','268614','268796','268797','269067','273520','273540','273563','274099','274648','274651','274726','274727','274902','275204','275517','275518','275519','275520','275598','275656','275837','276207','276533','276604','276641','276645','277026','277522','277901','278120','278407','278839','279402','279427','279635','280464','280533','280916','280936','281114','281426','281739','282423','282475','282509','282827','283119','283312','284130','284229','285016','285279','285483','285484','285485','285486','285654','285666','285847','285859','286650','286659','287226','287385','288333','288650','288759','289099','292052','292237','292238','292460','292461','292462','292575','293229','293878','293879','293929','294157','294348','295539','295575','295634','295713','295714','295716','295717','295718','295796','295933','296256','297135','297147','297206','298095','298233','298408','299637','299846','299847','300001','300203','300307','300358','300422','300545','302252','302294') GROUP BY `tip` ORDER BY `tip` ASC