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 ('141531','141532','143930','144045','144046','149693','151644','151843','151975','153825','154411','154413','154475','154709','154840','154841','154842','156537','156538','156539','157527','158001','158078','159094','167030','168029','238425','239003','240108','240761','241794','242624','243118','243978','247362','251489','262947','263036','266339','266376','266586','266615','267176','273741','274262','275224','278933','279286','281078','282487','284601','284602','285580','285581','285582','285583','285665','285901','288028','291862','292084','294719','294993','295157','295356','297103','297686') 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 ('141531','143930','149693','151644','151843','153825','154411','154413','154475','154709','154840','154841','154842','157527','158001','158078','159094','239003','240108','240761','241794','242624','243118','243978','247362','251489','263036','266339','266586','266615','267176','273741','274262','275224','278933','279286','284601','284602','285583','285665','285901','288028','291862','292084','294719','294993','295157','295356','297103','297686') GROUP BY `manuf` ORDER BY `manuf` ASC