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 ('150189','150190','150191','158501','159258','160684','161820','161948','162396','162952','162953','162954','162955','162956','162957','162958','162959','162960','162961','162962','162963','162964','163400','163401','164823','164976','166091','166595','167509','170746','212236','212237','212238','212239','212240','214752','214753','214754','214755','214756','214757','214758','214759','214760','214761','214762','214763','214764','214765','214766','214767','214768','214769','214770','214771','214772','214773','214774','214775','214776','214777','214778','214779','214780','214781','214782','214783','214784','214785','214786','214787','214788','214789','214790','214791','214792','214793','214794','214795','214796','214797','214798','214799','214800','214801','214802','214803','214804','214805','214806','214807','214808','214809','214810','214811','214812','214813','214814','214815','214816','214817','214818','214819','214820','214821','214822','214823','214824','214825','214826','214827','214828','214829','214830','214831','214832','214833','214834','214835','214836','214837','214838','214839','214840','214841','214842','214843','214844','214845','214846','214847','214848','214849','214850','214851','214852','214853','214854','214855','214856','214857','214858','214859','214860','214861','214862','214863','214864','214865','214866','214867','214868','214869','214870','214871','214872','214873','214874','214875','214876','214877','214878','214879','214880','214881','214882','214883','214884','214885','214886','214887','214888','214889','214890','214891','214892','214893','214894','214895','214896','214897','214898','214899','214900','214901','214902','214903','214904','214905','214906','214907','214908','214909','214910','214911','214912','214913','214914','214915','214916','214917','214918','214919','214920','214921','214922','214923','214924','214925','214926','214927','214928','214929','214930','214931','214932','214933','214934','214935','214936','214937','214938','214939','214940','214941','214942','214943','214944','214945','214946','214947','214948','214949','214950','214951','214952','214953','214954','214955','214956','214957','214958','214959','214960','214961','214962','214963','214964','214965','214966','214967','239250','239946','240026','241012','242014','242836','243554','244169','245072','245851','246156','246240','246241','246242','247686','247836','247837','247838','247839','247840','247841','247842','248522','248523','249765','249855','250216','250591','250592','251336','252170','255012','256108','256206','256794','263638','263656','264433','265007','265075','265163','265463','265464','265577','265578','265579','265694','266439','266735','266954','266997','267231','267232','267233','267534','267535','267717','267755','267930','268168','268328','268421','268422','268423','268424','268425','268426','268427','268428','268429','268430','268431','268432','268433','268434','268897','273331','273599','273726','273980','274033','274450','274601','275632','277208','278083','278373','278911','278913','278914','278915','278916','278917','278918','278919','278920','278921','278922','278923','278924','278925','278986','279203','279485','279486','279487','279488','279489','280303','280305','281164','282248','282249','282272','283492','283672','284285','285000','285006','285017','285020','285784','285820','285821','286424','287159','287160','288291','288489','288540','288541','289008','289298','289393','289394','291828','292226','292232','292752','293419','293420','294168','294547','294621','294622','295300','295780','295872','296249','297104','297224','297249','297319','297479','297480','297481','297482','297483','297484','297485','297486','297487','297488','297489','297490','297491','297492','297493','297494','297495','297496','297497','297498','297499','297500','297501','297502','297503','297504','297505','297506','297507','297778','297958','298126','298127','298128','299630','300048','300206','300207','300609','301928','302055','302105','302162','302169','302170','303884') 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 ('150189','150190','150191','158501','159258','160684','161820','161948','162396','162952','162953','162954','162955','162956','162957','162958','162959','162960','162961','162962','162963','162964','163400','163401','164823','164976','166091','166595','167509','170746','212236','212237','212238','212239','212240','214752','214753','214754','214755','214756','214757','214758','214759','214760','214761','214762','214763','214764','214765','214766','214767','214768','214769','214770','214771','214772','214773','214774','214775','214776','214777','214778','214779','214780','214781','214782','214783','214784','214785','214786','214787','214788','214789','214790','214791','214792','214793','214794','214795','214796','214797','214798','214799','214800','214801','214802','214803','214804','214805','214806','214807','214808','214809','214810','214811','214812','214813','214814','214815','214816','214817','214818','214819','214820','214821','214822','214823','214824','214825','214826','214827','214828','214829','214830','214831','214832','214833','214834','214835','214836','214837','214838','214839','214840','214841','214842','214843','214844','214845','214846','214847','214848','214849','214850','214851','214852','214853','214854','214855','214856','214857','214858','214859','214860','214861','214862','214863','214864','214865','214866','214867','214868','214869','214870','214871','214872','214873','214874','214875','214876','214877','214878','214879','214880','214881','214882','214883','214884','214885','214886','214887','214888','214889','214890','214891','214892','214893','214894','214895','214896','214897','214898','214899','214900','214901','214902','214903','214904','214905','214906','214907','214908','214909','214910','214911','214912','214913','214914','214915','214916','214917','214918','214919','214920','214921','214922','214923','214924','214925','214926','214927','214928','214929','214930','214931','214932','214933','214934','214935','214936','214937','214938','214939','214940','214941','214942','214943','214944','214945','214946','214947','214948','214949','214950','214951','214952','214953','214954','214955','214956','214957','214958','214959','214960','214961','214962','214963','214964','214965','214966','214967','239250','239946','240026','241012','242014','242836','243554','244169','245072','245851','246156','246240','246241','246242','247686','247836','247837','247838','247839','247840','247841','247842','248522','248523','249765','249855','250216','250591','250592','251336','252170','255012','256108','256206','256794','263638','263656','264433','265007','265075','265163','265463','265464','265577','265578','265579','265694','266439','266735','266954','266997','267231','267232','267233','267534','267535','267717','267755','267930','268168','268328','268421','268422','268423','268424','268425','268426','268427','268428','268429','268430','268431','268432','268433','268434','268897','273331','273599','273726','273980','274033','274450','274601','275632','277208','278083','278373','278911','278913','278914','278915','278916','278917','278918','278919','278920','278921','278922','278923','278924','278925','278986','279203','279485','279486','279487','279488','279489','280303','280305','281164','282248','282249','282272','283492','283672','284285','285000','285006','285017','285020','285784','285820','285821','286424','287159','287160','288291','288489','288540','288541','289008','289298','289393','289394','291828','292226','292232','292752','293419','293420','294168','294547','294621','294622','295300','295780','295872','296249','297104','297224','297249','297319','297479','297480','297481','297482','297483','297484','297485','297486','297487','297488','297489','297490','297491','297492','297493','297494','297495','297496','297497','297498','297499','297500','297501','297502','297503','297504','297505','297506','297507','297778','297958','298126','298127','298128','299630','300048','300206','300207','300609','301928','302055','302105','302162','302169','302170','303884') GROUP BY `manuf` ORDER BY `manuf` ASC