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 ('141582','141588','142007','142087','142740','142742','142889','142948','143147','143278','143290','143363','143657','143778','144388','144437','144438','144439','144440','144441','144442','144443','144444','144445','144446','144447','144448','144449','144450','144451','144452','144453','144454','144455','144456','144457','144458','144459','144460','144461','144462','144463','144464','144465','144466','144467','144468','144469','144470','144471','144472','144473','144475','144533','144558','144565','144568','144573','144575','144576','144577','144578','144579','144580','144581','144582','144583','145550','146498','146549','147735','147759','148108','148130','148170','148585','149651','150064','150435','150595','150805','150807','151008','151211','151225','151411','151419','151571','151581','151675','151799','152557','153328','153331','153414','153632','154123','154165','154434','154435','154785','154786','154862','154953','155186','155331','155337','155447','156882','156891','157967','157969','158030','158159','158214','158283','158291','158327','158376','158450','158552','158568','158569','158579','158630','158748','158783','158874','159083','159127','159221','159453','159696','159763','159764','159862','160003','160074','160110','160454','160538','160578','160591','160648','160681','160687','160800','160825','160848','161086','161099','161100','161260','161278','161311','161336','161435','161503','161707','161941','162036','162113','162131','162244','162551','162573','162590','162713','162753','162777','162789','162906','162919','162923','162981','163025','163228','163342','163480','163546','163552','163580','163587','163701','163760','163817','163818','163867','163909','163995','164020','164105','164156','164169','164180','164225','164353','164395','164544','164625','164700','164924','165039','165105','165182','165208','165243','165294','165371','165372','165560','165579','165712','165735','165782','165797','165803','165828','165829','165902','165931','166117','166214','166312','166566','166582','166654','166671','166786','166840','166850','166960','167054','167207','167250','167415','167579','167592','167678','167843','167889','167912','167957','168041','168042','168117','168174','168186','168187','168188','168192','168195','168279','169279','169840','170248','170310','170329','170419','170625','170893','170931','171017','171018','171019','171020','171021','171022','171023','171024','171026','171027','171028','171029','171030','171032','171033','171034','171035','171036','171037','171038','171039','171040','171041','171042','171043','171044','171045','171046','171047','171048','171050','171051','171052','171053','171055','171056','171057','171058','171059','171060','171061','171062','171063','171064','171065','171066','171087','171089','171100','171120','171122','171130','171144','171161','171162','171163','171164','171165','171166','171167','171168','200008','201224','201315','202573','202616','202721','211160','211161','211162','211163','211164','211165','211166','211167','211168','211169','211170','211171','211172','215211','215237','215270','215363','215399','215457','215493','215522','215523','215525','215642','215695','215960','216050','232548','232621','232709','238014','238054','238127','238169','238314','238325','238392','238449','238883','238886','238952','239105','239212','239279','239280','239284','239403','239559','239769','239803','239936','240206','240361','240444','240489','240528','240668','240726','240747','240762','241119','241147','241163','241268','241375','241426','241428','241508','241545','241916','242047','242149','242389','242556','242590','242704','242799','242869','242936','243172','243179','243341','243354','243536','243663','243827','243832','243877','244044','244155','244336','244909','245119','245174','245263','245333','245346','245347','245354','245507','245608','245615','245670','245697','245759','245965','246288','246301','246313','246353','246416','246423','246684','246706','246801','246817','246858','246862','246965','247081','247147','247202','247268','247347','247365','247366','247384','247385','247391','247408','247416','247469','247481','247546','247549','247583','247666','247673','247759','247898','247923','247924','247938','248009','248019','248144','248191','248196','248249','248253','248259','248301','248328','248377','248414','248442','248482','248529','248604','248614','248676','248711','248712','248726','248840','248921','248990','249019','249150','249521','249543','249548','249557','249674','249676','249774','249805','249920','250188','250225','250281','250642','250726','250772','250783','250893','250997','251002','251051','251067','251069','251132','251176','251180','251390','251404','251416','251487','251632','251815','251902','251960','252139','252164','252232','252242','253048','253075','253164','253185','253195','253217','253481','253505','253599','253618','253642','253675','253734','253789','253859','253893','253908','253915','254202','254286','254352','254353','254441','254461','254583','254717','254718','254800','254858','254983','254996','255006','255059','255158','255160','255180','255301','255470','255646','255843','255860','255863','255893','256008','256125','256248','256314','256433','256438','256483','256547','256749','256780','256832','256864','256869','256927','261731','261733','261761','262303','262375','262397','262620','262669','262714','262752','262778','262794','262832','263041','263112','263158','263165','263172','263178','263185','263186','263453','263482','263488','263604','263759','264388','264389','264435','264471','264634','264636','264744','264826','264872','264881','264901','264985','264989','264999','265105','265201','265264','265293','265307','265317','265328','265410','265423','265512','265601','265604','265681','265683','265788','265789','265984','265987','266289','266293','266398','266408','266474','266510','266747','266776','266853','267027','267059','267207','267247','267298','267326','267454','267507','267538','267628','267667','267742','267857','267866','268079','268102','268160','268272','268296','269074','269145','269234','269239','269311','269344','269395','269429','269431','273524','273585','273887','273963','273988','274102','274275','274327','274351','274356','274426','274611','274630','274666','274667','274800','274830','274888','274889','275018','275096','275193','275209','275219','275339','275393','275483','275498','275556','275601','275624','275751','275766','275771','275788','275985','276042','276106','276111','276210','276241','276248','276255','276266','276390','276475','276562','276569','276585','276617','276762','276808','277000','277010','277078','277207','277311','277429','277493','277540','277541','277542','277543','277545','277546','277555','277556','277601','277602','277603','277628','277649','277668','277718','277746','277773','277858','277897','277909','277940','277951','277958','278001','278005','278027','278056','278088','278100','278108','278144','278159','278192','278267','278321','278461','278613','278687','278747','278895','279005','279006','279048','279069','279098','279136','279148','279227','279253','279290','279293','279300','279307','279308','279309','279320','279344','279345','279346','279703','279710','279719','279769','279770','279771','279772','279773','279774','279775','279776','279777','279778','279779','279780','280364','280409','280514','280543','280571','280772','280848','280908','280934','280953','281017','281107','281115','281177','281222','281315','281416','281725','281786','282254','282262','282363','282364','282373','282400','282451','282533','282565','282692','282804','282837','282860','282900','283043','283051','283218','283560','283571','283578','283630','283654','283655','283688','284141','284220','284398','284466','284606','284626','284828','285009','285012','285026','285119','285197','285250','285294','285329','285394','285406','285554','285601','285605','285613','285617','285745','285750','285763','285867','285911','285961','285974','286086','286196','286198','286230','286366','286423','286445','286592','286593','286598','286658','286662','286857','286999','287000','287012','287138','287139','287190','287387','287979','288083','288091','288094','288241','288274','288373','288428','288695','289001','289090','289381','289438','289453','289488','291585','291600','291670','291707','291739','291740','291800','291829','291839','291879','291902','291910','291945','292046','292063','292064','292070','292085','292216','292281','292288','292289','292290','292296','292335','292338','292404','292410','292505','292574','292586','292767','292774','292783','293407','293485','293567','293568','293569','293570','293571','293572','293583','293617','293626','293627','293631','293632','293633','294037','294191','294198','294199','294236','294270','294355','294397','294430','294490','294520','294521','294522','294523','294524','294525','294526','294527','294528','294530','294531','294532','294533','294534','294535','294536','294537','294539','294577','294624','294629','294658','294729','294866','294905','294922','294958','294964','294965','294969','294971','294974','294979','295287','295321','295422','295448','295566','295567','295616','295636','295681','295698','295722','295784','295787','295816','295821','295843','295886','295887','295889','295890','295891','295892','295893','295894','295895','295896','295897','295898','295899','295900','295901','295902','295903','295904','295905','295906','295907','295908','295909','295910','295911','295912','295913','295914','295915','295916','295922','295923','295996','296186','296191','296217','296224','296230','297185','297189','297240','297248','297251','297422','297581','297698','297797','297871','297872','297890','297893','297907','298000','298006','298093','298122','298124','298125','298188','298199','298202','298227','298320','298446','298462','298479','298482','298495','298510','298553','298561','299052','299056','299113','299136','299156','299205','299243','299270','299427','299451','299457','299469','299567','299582','299658','299760','299841','299964','300007','300046','300182','300320','300350','300353','300354','300437','300544','300701','300941','301031','301057','301789','301850','301867','301868','301869','301870','301871','301883','301896','301955','301973','302000','302135','302138','302230','302241','302366','303841','303852','303880','303890','303910','303943') 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 ('141582','141588','142007','142087','142740','142742','142889','142948','143147','143278','143290','143363','143657','143778','144388','144437','144438','144439','144440','144441','144442','144443','144444','144445','144446','144447','144448','144449','144450','144451','144452','144453','144454','144455','144456','144457','144458','144459','144460','144461','144462','144463','144464','144465','144466','144467','144468','144469','144470','144471','144472','144473','144475','144533','144558','144568','144573','144575','144576','144577','144578','144579','144580','144581','144582','144583','145550','146498','146549','147735','147759','148108','148130','148170','148585','149651','150064','150435','150595','150805','150807','151008','151211','151225','151411','151419','151571','151581','151675','151799','152557','153328','153331','153414','153632','154123','154165','154434','154435','154785','154786','154862','154953','155186','155331','155337','155447','156882','156891','157967','157969','158030','158159','158214','158283','158291','158327','158376','158450','158552','158568','158569','158579','158630','158748','158783','158874','159083','159127','159221','159453','159696','159763','159764','159862','160003','160074','160110','160454','160538','160578','160591','160648','160681','160687','160800','160825','160848','161086','161099','161100','161260','161278','161311','161336','161435','161503','161707','161941','162036','162113','162131','162244','162551','162573','162590','162713','162753','162777','162789','162906','162919','162923','162981','163025','163228','163342','163480','163546','163552','163580','163587','163701','163760','163817','163818','163867','163909','163995','164020','164105','164156','164169','164180','164225','164353','164395','164544','164625','164700','164924','165039','165105','165182','165208','165243','165294','165371','165372','165560','165579','165712','165735','165782','165797','165803','165828','165829','165902','165931','166117','166214','166312','166566','166582','166654','166671','166786','166840','166850','166960','167054','167207','167250','167415','167579','167592','167678','167843','167889','167912','167957','168041','168042','168117','168174','168186','168187','168188','168192','168195','168279','169279','169840','170248','170310','170329','170419','170625','170893','170931','171017','171018','171019','171020','171021','171022','171023','171024','171026','171027','171028','171029','171030','171032','171033','171034','171035','171036','171037','171038','171039','171040','171041','171042','171043','171044','171045','171046','171047','171048','171050','171051','171052','171053','171055','171056','171057','171058','171059','171060','171061','171062','171063','171064','171065','171066','171087','171089','171100','171120','171122','171130','171144','171161','171162','171163','171164','171165','171166','171167','171168','200008','201224','201315','202573','202616','202721','211160','211161','211162','211163','211164','211165','211166','211167','211168','211169','211170','211171','211172','215211','215237','215270','215363','215399','215457','215493','215522','215523','215525','215642','215695','215960','216050','232548','232621','232709','238014','238054','238127','238169','238314','238325','238392','238449','238883','238886','238952','239105','239212','239279','239280','239284','239403','239559','239769','239803','239936','240206','240361','240444','240489','240528','240668','240726','240747','240762','241119','241147','241163','241268','241375','241426','241428','241508','241545','241916','242047','242149','242389','242556','242590','242704','242799','242869','242936','243172','243179','243341','243354','243536','243663','243827','243832','243877','244044','244155','244336','244909','245119','245174','245263','245333','245346','245347','245354','245507','245608','245615','245670','245697','245759','245965','246288','246301','246313','246353','246416','246423','246684','246706','246801','246817','246858','246862','246965','247081','247147','247202','247268','247347','247365','247366','247384','247385','247391','247408','247416','247469','247481','247546','247549','247583','247666','247673','247759','247898','247923','247924','247938','248009','248019','248144','248191','248196','248249','248253','248259','248301','248328','248377','248414','248442','248482','248529','248604','248614','248676','248711','248712','248726','248840','248921','248990','249019','249150','249521','249543','249548','249557','249674','249676','249774','249805','249920','250188','250225','250281','250642','250726','250772','250783','250893','250997','251002','251051','251067','251069','251132','251176','251180','251390','251404','251416','251487','251632','251815','251902','251960','252139','252164','252232','252242','253048','253075','253164','253185','253195','253217','253481','253505','253599','253618','253642','253675','253734','253789','253859','253893','253908','253915','254202','254286','254352','254353','254441','254461','254583','254717','254718','254800','254858','254983','254996','255006','255059','255158','255160','255180','255301','255470','255646','255843','255860','255863','255893','256008','256125','256248','256314','256433','256438','256483','256547','256749','256780','256832','256864','256869','256927','261731','261733','261761','262303','262375','262397','262620','262669','262714','262752','262778','262794','262832','263041','263112','263158','263165','263172','263178','263185','263186','263453','263482','263488','263604','263759','264388','264389','264435','264471','264634','264636','264744','264826','264872','264881','264901','264985','264989','264999','265105','265201','265264','265293','265307','265317','265328','265410','265423','265512','265601','265604','265681','265683','265788','265789','265984','265987','266289','266293','266398','266408','266474','266510','266747','266776','266853','267027','267059','267207','267247','267298','267326','267454','267507','267538','267628','267667','267742','267857','267866','268079','268102','268160','268272','268296','269074','269145','269234','269239','269311','269344','269395','269429','269431','273524','273585','273887','273963','273988','274102','274275','274327','274351','274356','274426','274611','274630','274666','274667','274800','274830','274888','274889','275018','275096','275193','275209','275219','275339','275393','275483','275498','275556','275601','275624','275751','275766','275771','275788','275985','276042','276106','276111','276210','276241','276248','276255','276266','276390','276475','276562','276569','276585','276617','276762','276808','277000','277010','277078','277207','277311','277429','277493','277540','277541','277542','277543','277545','277546','277555','277556','277601','277602','277603','277649','277668','277718','277746','277773','277858','277897','277909','277940','277951','277958','278001','278005','278027','278056','278088','278100','278108','278144','278159','278192','278267','278321','278461','278613','278687','278747','278895','279005','279006','279048','279069','279098','279136','279148','279227','279253','279290','279293','279300','279307','279308','279309','279320','279344','279345','279346','279703','279710','279719','279769','279770','279771','279772','279773','279774','279775','279776','279777','279778','279779','279780','280364','280409','280514','280543','280571','280772','280848','280908','280934','280953','281017','281107','281115','281177','281222','281315','281416','281725','281786','282363','282364','282373','282400','282451','282533','282565','282692','282804','282837','282860','282900','283043','283051','283218','283560','283571','283578','283630','283654','283655','283688','284141','284220','284398','284466','284606','284626','284828','285009','285012','285026','285119','285197','285250','285294','285329','285394','285406','285554','285601','285605','285613','285617','285745','285750','285763','285867','285911','285961','285974','286086','286196','286198','286230','286366','286423','286445','286592','286593','286598','286658','286662','286857','286999','287000','287012','287138','287139','287190','287387','287979','288083','288091','288094','288241','288274','288373','288428','288695','289001','289090','289381','289438','289453','289488','291585','291600','291670','291707','291739','291740','291800','291829','291839','291879','291902','291910','291945','292046','292063','292064','292070','292085','292216','292281','292288','292289','292290','292296','292335','292338','292404','292410','292505','292574','292586','292767','292774','292783','293407','293485','293567','293568','293569','293570','293571','293572','293583','293617','293626','293627','293631','293632','293633','294037','294191','294198','294199','294236','294270','294355','294397','294430','294490','294520','294521','294522','294523','294524','294525','294526','294527','294528','294530','294531','294532','294533','294534','294535','294536','294537','294539','294577','294624','294629','294658','294729','294866','294905','294922','294958','294964','294965','294969','294971','294974','294979','295287','295321','295422','295448','295566','295567','295616','295636','295681','295698','295722','295784','295787','295816','295821','295843','295886','295887','295889','295890','295891','295892','295893','295894','295895','295896','295897','295898','295899','295900','295901','295902','295903','295904','295905','295906','295907','295908','295909','295910','295911','295912','295913','295914','295915','295916','295922','295923','295996','296186','296191','296217','296224','296230','297185','297189','297240','297248','297251','297422','297581','297698','297797','297871','297872','297890','297893','297907','298000','298006','298093','298122','298124','298125','298188','298199','298202','298227','298320','298446','298462','298479','298482','298495','298510','298553','298561','299052','299056','299113','299136','299156','299205','299243','299270','299427','299451','299457','299469','299567','299582','299658','299760','299841','299964','300007','300046','300182','300320','300350','300353','300354','300437','300544','300701','300941','301031','301057','301789','301850','301867','301868','301869','301870','301871','301883','301896','301955','301973','302000','302135','302138','302230','302241','302366','303841','303852','303880','303890','303910','303943') GROUP BY `manuf` ORDER BY `manuf` ASC