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 ('146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763') 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 ('146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','201148','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','299762','299763') GROUP BY `manuf` ORDER BY `manuf` ASC
