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 ('143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254') 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 ('143923','153783','153936','157739','160830','160860','161962','162647','167511','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','291623','292473','294701','295409','295598','297254') GROUP BY `manuf` ORDER BY `manuf` ASC