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 ('141331','141334','141444','141509','141513','141594','141692','141765','141781','141826','141827','141828','141829','141830','141831','141878','141879','141880','141933','142042','142150','142524','142706','142743','142839','142840','142841','142842','142843','142844','142904','142926','143264','143265','143557','144039','144175','145019','147022','147062','147182','148671','148729','148845','149228','149230','149233','149234','149235','149237','149238','149240','149244','149249','149250','149251','149256','149257','149258','149259','149269','149271','149272','149274','149275','149276','149277','149301','149302','149303','149602','149603','149604','149605','149606','149607','149608','149609','149610','149611','149612','149620','149901','150221','150223','150224','150225','150227','150229','150230','150236','150237','150238','150445','150522','150588','151573','151839','151865','151986','153587','153880','154582','154834','154835','154836','154838','154883','154932','154938','155233','155288','155450','156315','156316','156319','156357','156359','156360','156361','156362','156385','156419','156420','156421','156422','156465','156466','156467','156468','156469','156470','156471','156472','156473','156474','156490','156491','156493','156494','156495','156496','156497','156499','156511','156512','156513','156514','158400','158673','158971','159225','159395','159462','159463','159706','160049','160318','160364','160437','160650','160651','160821','160852','160932','161028','161428','161545','161554','161912','162235','162365','162470','162530','162833','163037','163779','163780','163781','163782','163802','164009','164131','164159','164405','164805','164876','165244','165552','165859','165917','166014','166589','166674','166721','166722','166723','166724','167001','167077','167114','167183','167186','167210','167326','167365','167406','167483','167648','167871','168005','168272','168293','168329','208014','208015','208016','210324','210325','210326','210327','210328','210329','210330','210331','210332','210333','210334','210335','210336','210337','210338','210339','210340','210341','210342','210343','210344','210345','210346','210347','210348','210349','210350','210351','210352','210353','210354','210355','210356','210357','210358','210359','210360','210361','210362','210363','210364','210365','210366','210367','210368','210369','210370','210371','210372','210373','210374','210375','210376','210377','210378','210379','210380','210381','210382','210383','210384','210385','210386','210387','210388','210389','210390','210391','210392','210393','210394','210395','210396','210397','210398','210399','210400','210401','210402','210403','210404','210405','210406','210407','210408','210409','210410','210411','210412','210413','210414','210415','210416','210417','210418','210419','210420','210421','210422','210423','210424','210425','210426','210427','210428','210429','210430','210431','210432','210433','210434','210435','210436','210437','210438','210439','210440','210441','210442','210443','210444','210445','210446','210447','210448','210449','210450','210451','210452','210453','210454','210455','210456','210457','210458','210459','210460','210461','210462','210463','210464','210465','210466','210467','210468','210469','210470','210471','210472','210473','210474','210475','210476','210984','210985','210986','210987','210988','210989','210990','210991','210992','210993','210994','210995','210996','210997','210998','210999','211000','211001','211002','211003','211004','211005','211006','211007','212662','212663','212664','212680','215710','215919','232607','238107','238716','240338','240655','240706','240977','241517','241707','241956','242452','243153','243154','243155','243156','243157','243158','244214','244215','244292','244293','244468','244791','245193','245426','245787','245796','246112','246351','246661','246662','246750','247376','247780','249128','249129','250101','250192','250330','250695','250697','251222','251602','251603','251605','251607','251695','251794','251795','251917','251918','251919','251922','251923','251934','251935','252146','253205','253206','253765','254250','254396','254521','254522','255000','255109','255344','255384','255477','255510','255518','255819','255820','255821','255822','255824','255825','255826','255827','255828','255849','255895','255896','255897','255898','255899','255900','255901','255902','255903','255904','255905','255906','255907','255910','255911','255912','255913','255914','255915','255916','255917','255918','255919','255920','255921','255922','255923','255924','255925','255926','255927','255928','255929','256103','256277','256278','256280','256282','256283','256284','256285','256317','256686','256904','256905','257015','257016','257017','257018','257025','257026','257182','257193','257194','257197','257202','257203','257204','257205','257206','257208','257209','257210','261975','262032','262281','262557','262881','262896','262935','263483','263636','263754','264486','264548','264549','264861','265429','265437','265442','265675','265944','266148','266161','266197','266230','266254','266307','266321','266908','266956','266989','266990','267065','267240','267249','267358','267419','267420','267502','267519','267722','267723','267724','267725','267976','268205','268249','268372','268780','268781','268788','268873','269015','269043','269249','269250','269251','269252','269393','269482','269488','273337','273338','273382','273418','273419','273541','273946','273960','273974','274285','274286','274419','274441','274507','274615','274616','274627','274628','274682','274763','274828','274845','274905','275026','275064','275421','275484','275501','275662','275663','275952','276092','276093','276339','276496','276497','277006','277035','277070','277313','277460','277509','277676','277717','278011','278290','278291','278490','278774','278900','278901','279000','279100','279134','279283','279689','279691','280535','280817','280979','281077','281079','281117','281687','281706','281933','282069','282106','282160','282368','282521','282572','282868','282879','283380','283385','283542','283601','283634','283635','283717','284275','284831','284836','284962','285083','285148','285150','285151','285234','285255','285494','285523','285524','285540','285614','285660','285677','285704','285733','285734','285789','285804','286043','286070','286141','286265','286350','286905','286920','286921','286988','287046','287050','287051','287056','287057','287218','287220','287543','287557','288025','288026','288351','288357','288358','288474','288676','288677','288682','288683','288767','288768','288769','288770','288771','288772','288774','288776','288777','288778','288779','288780','288781','288782','288783','288784','288785','288823','288970','288971','289459','291736','291864','291941','292091','292327','292339','292340','292341','292342','292343','292344','292623','292654','292662','292673','292748','292790','293257','293264','293458','293575','293593','293596','294016','294031','294187','294548','294560','294584','294690','294727','294738','295304','295420','295482','295524','295788','295989','295990','296006','296007','296008','296009','296010','296011','296262','297097','297102','297291','297555','297556','297601','297654','297683','297684','297687','297688','297765','297829','297882','298394','299090','299138','299481','299484','299547','299776','299829','300019','300204','300246','300407','300531','301018','301056','302051','302067','302086','302316','302338','303801','304275','304698') 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 ('141331','141334','141444','141509','141513','141594','141692','141765','141781','141826','141827','141828','141829','141830','141831','141878','141879','141880','141933','142042','142150','142524','142706','142743','142839','142840','142841','142842','142843','142844','142904','142926','143264','143265','143557','144039','144175','145019','147022','147062','147182','148671','148729','148845','149228','149230','149233','149234','149235','149237','149238','149240','149244','149249','149250','149251','149256','149257','149258','149259','149269','149271','149272','149274','149275','149276','149277','149301','149302','149303','149602','149603','149604','149605','149606','149607','149608','149609','149610','149611','149612','149620','149901','150221','150223','150224','150225','150227','150229','150230','150236','150237','150238','150445','150522','150588','151573','151839','151865','151986','153587','153880','154582','154834','154835','154836','154838','154883','154932','154938','155233','155288','155450','156315','156316','156319','156357','156359','156360','156361','156362','156385','156419','156420','156421','156422','156465','156466','156467','156468','156469','156470','156471','156472','156473','156474','156490','156491','156493','156494','156495','156496','156497','156499','156511','156512','156513','156514','158400','158673','158971','159225','159395','159462','159463','159706','160049','160318','160364','160437','160650','160651','160821','160852','160932','161028','161428','161545','161554','161912','162235','162365','162470','162530','162833','163037','163779','163780','163781','163782','163802','164009','164131','164159','164405','164805','164876','165244','165552','165859','165917','166014','166589','166674','166721','166722','166723','166724','167001','167077','167114','167183','167186','167210','167326','167365','167406','167483','167648','167871','168005','168272','168293','168329','208014','208015','208016','210324','210325','210326','210327','210328','210329','210330','210331','210332','210333','210334','210335','210336','210337','210338','210339','210340','210341','210342','210343','210344','210345','210346','210347','210348','210349','210350','210351','210352','210353','210354','210355','210356','210357','210358','210359','210360','210361','210362','210363','210364','210365','210366','210367','210368','210369','210370','210371','210372','210373','210374','210375','210376','210377','210378','210379','210380','210381','210382','210383','210384','210385','210386','210387','210388','210389','210390','210391','210392','210393','210394','210395','210396','210397','210398','210399','210400','210401','210402','210403','210404','210405','210406','210407','210408','210409','210410','210411','210412','210413','210414','210415','210416','210417','210418','210419','210420','210421','210422','210423','210424','210425','210426','210427','210428','210429','210430','210431','210432','210433','210434','210435','210436','210437','210438','210439','210440','210441','210442','210443','210444','210445','210446','210447','210448','210449','210450','210451','210452','210453','210454','210455','210456','210457','210458','210459','210460','210461','210462','210463','210464','210465','210466','210467','210468','210469','210470','210471','210472','210473','210474','210475','210476','210984','210985','210986','210987','210988','210989','210990','210991','210992','210993','210994','210995','210996','210997','210998','210999','211000','211001','211002','211003','211004','211005','211006','211007','212662','212663','212664','212680','215710','215919','232607','238107','238716','240338','240655','240706','240977','241517','241707','241956','242452','243153','243154','243155','243156','243157','243158','244214','244215','244292','244293','244468','244791','245193','245426','245787','245796','246112','246351','246661','246662','246750','247376','247780','249128','249129','250101','250192','250330','250695','250697','251222','251602','251603','251605','251607','251695','251794','251795','251917','251918','251919','251922','251923','251934','251935','252146','253205','253206','253765','254250','254396','254521','254522','255000','255109','255344','255384','255477','255510','255518','255819','255820','255821','255822','255824','255825','255826','255827','255828','255849','255895','255896','255897','255898','255899','255900','255901','255902','255903','255904','255905','255906','255907','255910','255911','255912','255913','255914','255915','255916','255917','255918','255919','255920','255921','255922','255923','255924','255925','255926','255927','255928','255929','256103','256277','256278','256280','256282','256283','256284','256285','256317','256686','256904','256905','257015','257016','257017','257018','257025','257026','257182','257193','257194','257197','257202','257203','257204','257205','257206','257208','257209','257210','261975','262032','262281','262557','262881','262896','262935','263483','263636','263754','264486','264548','264549','264861','265429','265437','265442','265675','265944','266148','266161','266197','266230','266254','266307','266321','266908','266956','266989','266990','267065','267240','267249','267358','267419','267420','267502','267519','267722','267723','267724','267725','267976','268205','268249','268372','268780','268781','268788','268873','269015','269043','269249','269250','269251','269252','269393','269482','269488','273337','273338','273382','273418','273419','273541','273946','273960','273974','274285','274286','274419','274441','274507','274615','274616','274627','274628','274682','274763','274828','274845','274905','275026','275064','275421','275484','275501','275662','275663','275952','276092','276093','276339','276496','276497','277006','277035','277070','277313','277460','277509','277676','277717','278011','278290','278291','278490','278774','278900','278901','279000','279100','279134','279283','279689','279691','280535','280817','280979','281077','281079','281117','281687','281706','281933','282069','282106','282160','282368','282521','282572','282868','282879','283380','283385','283542','283601','283634','283635','283717','284275','284831','284836','284962','285083','285148','285150','285151','285234','285255','285494','285523','285524','285540','285614','285660','285677','285704','285733','285734','285789','285804','286043','286070','286141','286265','286350','286905','286920','286921','286988','287046','287050','287051','287056','287057','287218','287220','287543','287557','288025','288026','288351','288357','288358','288474','288676','288677','288682','288683','288767','288768','288769','288770','288771','288772','288774','288776','288777','288778','288779','288780','288781','288782','288783','288784','288785','288823','288970','288971','289459','291736','291864','291941','292091','292327','292339','292340','292341','292342','292343','292344','292623','292654','292662','292673','292748','292790','293257','293264','293458','293575','293593','293596','294016','294031','294187','294548','294560','294584','294690','294727','294738','295304','295420','295482','295524','295788','295989','295990','296006','296007','296008','296009','296010','296011','296262','297097','297102','297291','297555','297556','297601','297654','297683','297684','297687','297688','297765','297829','297882','298394','299090','299138','299481','299484','299547','299776','299829','300019','300204','300246','300407','300531','301018','301056','302051','302067','302086','302316','302338','303801') GROUP BY `manuf` ORDER BY `manuf` ASC