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 ('153216','153217','153218','159399','161110','161486','161518','161519','166395','166396','166397','214482','214539','232475','232501','240055','240149','240587','240782','240783','240784','241277','242090','242319','242459','242464','242465','242466','242467','242645','242700','242738','242739','242740','242741','242742','242743','242744','242745','242826','242827','242828','242837','243080','243221','243315','243324','245084','245990','247810','249509','249510','249511','250351','250851','250852','251000','251001','251097','251122','251123','251124','251253','251702','251822','251823','251855','251856','251978','254779','255519','261933','262622','262660','263569','264673','264674','264677','266789','268108','268121','268419','268420','268435','268436','268437','268438','268439','268440','268441','268442','268443','268444','268445','268727','268841','273559','275403','275733','276056','277944','277945','278115','278374','278376','278400','278604','279137','279169','279201','279275','279558','279566','279572','279573','279574','279575','279678','280596','280597','280897','280898','280899','281625','282531','283233','283513','283514','283515','283561','284463','284464','284536','284633','284634','284740','284741','285306','285587','286145','286146','286282','286363','286368','286992','287003','287044','288362','288466','288892','288996','288997','289386','289387','289411','289423','291587','291696','292069','292267','292391','292392','292393','292394','292538','292764','292765','293385','293454','294150','294151','294352','294920','297094','297133','297222','297741','297742','297743','297744','297745','297746','297747','297781','297782','297827','297828','297830','297832','297938','297939','297940','298013','298328','299194','299474','299531','299560','299873','299874','299875','300003','300051','302232') 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 ('153216','153217','153218','159399','161110','161486','161518','161519','166395','166396','166397','214482','214539','232475','232501','240055','240149','240587','240782','240783','240784','241277','242090','242319','242459','242464','242465','242466','242467','242645','242700','242738','242739','242740','242741','242742','242743','242744','242745','242826','242827','242828','242837','243080','243221','243315','243324','245084','245990','247810','249509','249510','249511','250351','250851','250852','251000','251001','251097','251122','251123','251124','251253','251702','251822','251823','251855','251856','251978','254779','255519','261933','262622','262660','263569','264673','264674','264677','266789','268108','268121','268419','268420','268435','268436','268437','268438','268439','268440','268441','268442','268443','268444','268445','268727','268841','273559','275403','275733','276056','277944','277945','278115','278374','278376','278400','278604','279137','279169','279201','279275','279558','279566','279572','279573','279574','279575','279678','280596','280597','280897','280898','280899','281625','282531','283233','283513','283514','283515','283561','284463','284464','284536','284633','284634','284740','284741','285306','285587','286145','286146','286282','286363','286368','286992','287003','287044','288362','288466','288892','288996','288997','289386','289387','289411','289423','291587','291696','292069','292267','292391','292392','292393','292394','292538','292764','292765','293385','293454','294150','294151','294352','294920','297094','297133','297222','297741','297742','297743','297744','297745','297746','297747','297781','297782','297827','297828','297830','297832','297938','297939','297940','298013','298328','299194','299474','299531','299560','299873','299874','299875','300003','300051','302232') GROUP BY `manuf` ORDER BY `manuf` ASC
