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 ('143312','153890','154979','157671','159796','159813','160284','160440','160566','160626','160896','161361','161515','162401','162984','163402','164364','164699','164828','164968','166601','166602','166603','166604','166605','167340','167396','167397','167398','167400','167401','167512','167918','169892','169899','170316','170552','215647','232691','238078','239898','240915','241694','241695','241700','241901','241992','241995','242228','242349','242350','242532','242967','243075','243320','243321','243322','243323','243874','243995','244094','244108','244138','244323','244691','244968','244969','244970','244971','245171','245328','245573','245590','246094','246095','246167','246348','246349','246488','246917','247467','247706','247723','248106','249216','249808','249809','250066','250507','250616','251044','251454','251739','251990','253024','253406','254515','255170','255592','255593','255594','255614','256701','261951','261982','262400','262435','262591','264371','264372','264535','265175','265199','265329','265592','265593','267026','267999','268005','268179','269605','273367','274503','275101','275255','275256','275426','275552','276083','276557','276565','277716','280472','282154','282214','282215','282216','282217','282218','282229','282241','282242','282243','282244','282877','283640','284615','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285340','285341','285453','285460','285461','285728','285801','285863','286253','287791','288837','288838','289066','293522','295712','299053','299532','299900','303930','303931','303932') 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 ('143312','153890','154979','157671','159796','159813','160284','160440','160566','160626','160896','161361','161515','162401','162984','163402','164364','164699','164828','164968','166601','166602','166603','166604','166605','167340','167396','167397','167398','167400','167401','167512','167918','169892','169899','170316','170552','215647','232691','238078','239898','240915','241694','241695','241700','241901','241992','241995','242228','242349','242350','242532','242967','243075','243320','243321','243322','243323','243874','243995','244094','244108','244138','244323','244691','244968','244969','244970','244971','245171','245328','245573','245590','246094','246095','246167','246348','246349','246488','246917','247467','247706','247723','248106','249216','249808','249809','250066','250507','250616','251044','251454','251739','251990','253024','253406','254515','255170','255592','255593','255594','255614','256701','261951','261982','262400','262435','262591','264371','264372','264535','265175','265199','265329','265592','265593','267026','267999','268005','268179','269605','273367','274503','275255','275256','275426','275552','276083','276557','276565','277716','280472','282154','282214','282215','282216','282217','282218','282229','282241','282242','282243','282244','282877','283640','284615','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285340','285341','285453','285460','285461','285801','285863','286253','287791','288837','288838','289066','293522','295712','299053','299532','299900','303930','303931','303932') GROUP BY `manuf` ORDER BY `manuf` ASC
