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 ('153046','153100','154564','154633','154876','157501','157502','158231','158408','158495','158946','160370','161027','163913','166054','166405','166412','166715','167456','167958','168291','232684','238253','238609','240401','240503','242306','242604','242714','243434','244086','244142','244295','244504','245598','245617','245959','246749','246830','248002','248065','248499','248888','248993','249341','249626','252022','252166','252167','253045','253269','253661','253701','253772','254452','254766','256106','256207','262304','263006','263007','263116','263674','264751','265024','265078','265400','265636','266104','267568','268453','269094','274149','274513','274750','275134','275804','276012','276055','276074','276384','276431','276492','276671','276673','277305','277680','277835','277836','277837','277838','277839','277840','277841','277842','277843','277844','277845','277846','277847','277848','277849','277850','277851','277852','277853','277854','279223','279291','279413','279520','280345','282085','282281','282844','283101','284301','286164','286276','286331','286588','287178','287213','293227','293403','294319','295727','298026','298082','298099','299796','300630','301902','303797') 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 ('153046','153100','154564','154633','154876','157501','157502','158231','158408','158495','158946','160370','161027','163913','166054','166405','166412','166715','167456','167958','168291','232684','238253','238609','240401','240503','242306','242604','242714','243434','244086','244142','244295','244504','245598','245617','245959','246749','246830','248002','248065','248499','248888','248993','249341','249626','252022','252166','252167','253045','253269','253661','253701','253772','254452','254766','256106','256207','262304','263006','263007','263116','263674','264751','265024','265078','265400','265636','266104','267568','268453','269094','274149','274513','274750','275134','275804','276012','276055','276074','276384','276431','276492','276671','276673','277305','277680','277835','277836','277837','277838','277839','277840','277841','277842','277843','277844','277845','277846','277847','277848','277849','277850','277851','277852','277853','277854','279223','279291','279413','279520','280345','282085','282281','282844','283101','284301','286164','286276','286331','286588','287178','287213','293227','293403','294319','295727','298026','298082','298099','299796','300630','301902','303797') GROUP BY `manuf` ORDER BY `manuf` ASC
