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 ('162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') 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 ('162155','162921','164401','165631','165632','166917','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','288154','294980','294983','294984','295805','302296','302305') GROUP BY `manuf` ORDER BY `manuf` ASC
