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 ('143174','143512','143569','143705','143706','143707','143708','149674','149675','149678','149698','150355','150356','150357','150358','150359','150360','150361','150362','150363','150364','152640','152642','152644','158915','158916','158944','159103','159270','159271','160327','162950','163404','163914','164317','165951','165952','165953','165954','165955','165956','166111','168206','169917','169918','170066','170067','170073','170075','170356','170600','170601','170602','170682','201152','213396','213397','213398','213399','213400','213401','213402','213403','213404','213405','213406','213407','213408','213409','213410','213411','213412','213413','213414','213415','213416','213417','213418','213419','213420','213421','213422','213423','213424','213425','213426','213427','213428','213429','213430','213431','213432','213433','213434','213435','213436','213437','213438','213439','213440','213441','213442','213443','213444','213445','213446','213447','213448','213449','213450','213451','213452','213453','213454','213455','232449','238496','238816','240035','240059','240060','240061','240062','240152','240154','240498','240557','240558','240559','240560','240561','240562','240971','243373','244474','244475','244476','244477','244478','244479','244480','244481','244482','244483','244484','244485','244486','244487','244488','244489','244490','244491','244492','244493','244494','244495','244496','244497','244498','244499','244500','244501','244502','244503','244857','245127','245128','245129','245968','246652','248027','248967','249155','249751','250181','250265','250289','250347','251161','251597','251598','251599','251600','253592','253684','253727','255078','255079','255080','255081','255434','255435','256526','265890','266372','266552','266553','266705','266766','267781','267782','267783','267784','267785','267786','267787','267788','267789','267790','267791','267792','267793','267794','267795','267796','267797','267798','267799','267800','267801','267802','267803','268513','274397','274398','274399','274400','274592','274657','274658','274795','274832','276388','277173','277439','277440','277441','277442','277443','277444','277445','278658','278659','278660','278661','278662','278663','278664','278665','278894','280380','280381','280382','281437','282416','282871','284642','285422','285772','285938','286084','286449','288378','288553','288554','288555','289230','289463','292566','294340','294341','294343','294344','295410','295443','295760','296273','300262','300615') 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 ('143174','143512','143569','143705','143706','143707','143708','149674','149675','149678','149698','150355','150356','150357','150358','150359','150360','150361','150362','150363','150364','152640','152642','152644','158915','158916','158944','159103','159270','159271','160327','162950','163404','163914','164317','165951','165952','165953','165954','165955','165956','166111','168206','169917','169918','170066','170067','170073','170075','170356','170600','170601','170602','170682','201152','213396','213397','213398','213399','213400','213401','213402','213403','213404','213405','213406','213407','213408','213409','213410','213411','213412','213413','213414','213415','213416','213417','213418','213419','213420','213421','213422','213423','213424','213425','213426','213427','213428','213429','213430','213431','213432','213433','213434','213435','213436','213437','213438','213439','213440','213441','213442','213443','213444','213445','213446','213447','213448','213449','213450','213451','213452','213453','213454','213455','232449','238496','238816','240035','240059','240060','240061','240062','240152','240154','240498','240557','240558','240559','240560','240561','240562','240971','243373','244474','244475','244476','244477','244478','244479','244480','244481','244482','244483','244484','244485','244486','244487','244488','244489','244490','244491','244492','244493','244494','244495','244496','244497','244498','244499','244500','244501','244502','244503','244857','245127','245128','245129','245968','246652','248027','248967','249155','249751','250181','250265','250289','250347','251161','251597','251598','251599','251600','253592','253684','253727','255078','255079','255080','255081','255434','255435','256526','265890','266372','266552','266553','266705','266766','267781','267782','267783','267784','267785','267786','267787','267788','267789','267790','267791','267792','267793','267794','267795','267796','267797','267798','267799','267800','267801','267802','267803','268513','274397','274398','274399','274400','274592','274657','274658','274795','274832','276388','277173','277439','277440','277441','277442','277443','277444','277445','278658','278659','278660','278661','278662','278663','278664','278665','278894','280380','280381','280382','281437','282416','282871','284642','285422','285772','285938','286084','286449','288378','288553','288554','288555','289230','289463','292566','294340','294341','294343','294344','295410','295443','295760','296273','300262','300615') GROUP BY `manuf` ORDER BY `manuf` ASC
