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 ('153133','154412','154432','158473','159845','161692','161742','163775','163972','164024','164130','165194','166491','166851','167025','238215','239908','241130','241306','243506','243787','244342','244864','245459','246386','246609','247402','247441','247590','248130','248200','248588','249123','249347','251149','252085','252226','252236','253438','254612','256084','256221','262194','263705','265552','265576','265809','267113','267179','267371','267520','267643','268041','268490','268491','268493','273752','274020','274124','274305','275079','275392','275814','275815','275816','275965','276156','277218','277964','278007','278463','278979','279012','279720','280397','280725','280888','281005','281006','282062','282082','282449','283232','284161','284858','285130','285164','285535','285721','286044','286131','286446','286448','286639','286835','286880','287180','288551','289402','289437','291714','291715','291716','291717','291718','291719','291720','292318','292822','293546','294186','295355','296272','297346','297438','297791','297894','297895','299119','299120','299197','299251','299360','299506','299820','299938','300702','301016','303848') 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 ('153133','154412','154432','158473','159845','161692','161742','163775','163972','164024','164130','165194','166491','166851','167025','238215','239908','241130','241306','243506','243787','244342','244864','245459','246386','246609','247402','247441','247590','248130','248200','248588','249123','249347','251149','252085','252226','252236','253438','254612','256084','256221','262194','263705','265552','265576','265809','267113','267179','267371','267520','267643','268041','268490','268491','268493','273752','274020','274124','274305','275079','275392','275814','275815','275816','275965','276156','277218','277964','278007','278463','278979','279012','279720','280397','280725','280888','281005','281006','282062','282082','282449','283232','284161','284858','285130','285164','285535','285721','286044','286131','286446','286448','286639','286835','286880','287180','288551','289402','289437','291714','291715','291716','291717','291718','291719','291720','292318','292822','293546','294186','295355','296272','297346','297438','297791','297894','297895','299119','299120','299197','299251','299360','299506','299820','299938','300702','301016','303848') GROUP BY `manuf` ORDER BY `manuf` ASC
