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 ('141579','141684','143084','144210','148680','149581','149584','149585','149586','149587','149588','149589','149590','149591','149592','149593','149594','149595','149596','150337','150338','150339','150340','150341','150342','151233','151791','153046','153100','154564','154633','154876','157501','157502','158231','158408','158495','158946','160370','161027','163913','166054','166405','166412','166715','167456','167958','168291','170261','170459','170605','170606','170732','201327','210139','210140','210141','210142','210143','210144','210145','210148','210149','210150','210151','210152','210153','210154','210155','210156','210157','210158','210159','210160','210161','210162','210163','210164','210165','210166','210167','210168','210169','210170','210171','210172','210173','210174','210175','210176','210177','210178','210179','210180','210181','210182','210183','210184','210185','210186','210187','210188','210189','210190','210191','210192','210193','210194','210195','210196','210197','210198','210199','210200','210201','210202','210203','210204','210205','210206','210207','210208','210209','210210','210211','210212','210213','210214','210215','210216','213194','213195','213196','213197','213198','213199','213200','213201','213202','213203','213204','213205','213206','213207','213208','213209','213210','213211','213212','213213','213214','213215','213216','213217','213218','213219','213220','213221','213222','213223','213224','213225','213226','213227','213228','213229','213230','213231','213232','213233','213234','213235','213236','213237','213238','213239','213240','213241','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','294476','294477','294478','295727','298026','298082','298099','299796','300630','301902') 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 ('141579','141684','143084','144210','148680','149581','149584','149585','149586','149587','149588','149589','149590','149591','149592','149593','149594','149595','149596','150337','150338','150339','150340','150341','150342','151233','151791','153046','153100','154564','154633','154876','157501','157502','158231','158408','158495','158946','160370','161027','163913','166054','166405','166412','166715','167456','167958','168291','170261','170459','170605','170606','170732','201327','210139','210140','210141','210142','210143','210144','210145','210148','210149','210150','210151','210152','210153','210154','210155','210156','210157','210158','210159','210160','210161','210162','210163','210164','210165','210166','210167','210168','210169','210170','210171','210172','210173','210174','210175','210176','210177','210178','210179','210180','210181','210182','210183','210184','210185','210186','210187','210188','210189','210190','210191','210192','210193','210194','210195','210196','210197','210198','210199','210200','210201','210202','210203','210204','210205','210206','210207','210208','210209','210210','210211','210212','210213','210214','210215','210216','213194','213195','213196','213197','213198','213199','213200','213201','213202','213203','213204','213205','213206','213207','213208','213209','213210','213211','213212','213213','213214','213215','213216','213217','213218','213219','213220','213221','213222','213223','213224','213225','213226','213227','213228','213229','213230','213231','213232','213233','213234','213235','213236','213237','213238','213240','213241','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') GROUP BY `manuf` ORDER BY `manuf` ASC