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 ('141328','141329','141355','141356','141357','141371','141372','141373','141374','141375','141794','141890','141933','142043','142056','142064','142704','142705','142838','143594','146696','148667','148668','148670','149278','149280','149286','149287','149288','149293','149294','149298','149305','149306','149307','149311','149312','149313','149314','149315','149317','150591','151112','151465','151574','154628','154629','155765','156339','156379','156381','156383','156450','156451','156515','156516','156517','156518','156520','156521','156522','159460','159461','160504','160505','160557','162103','162570','164065','164467','164989','165140','165555','166438','166905','166906','167100','167451','168051','208091','208172','215384','249771','251907','251908','253231','253242','255757','255787','255818','256174','256202','256210','256593','257068','261936','263469','265179','266365','266395','267016','268086','268309','268352','268523','268705','268754','269447','273606','273665','273844','274309','274446','274604','274690','275566','275692','276597','277586','277784','277785','277786','278566','278666','279093','279095','279096','279166','280415','280428','280584','280856','281195','281257','281274','281770','283139','283187','284599','285742','286015','286349','286986','287017','287049','288218','288559','288674','288675','288680','288681','288684','288685','288686','288687','288688','288689','288690','288786','288787','288788','288789','288791','288792','288793','288794','288795','288796','288797','288798','288799','288800','288801','288802','288803','288804','288805','288806','288807','288808','288809','288810','288811','288812','288813','288814','288815','288816','288817','288818','288819','288820','288821','288822','288972','288973','288974','288975','288976','288977','288978','288979','288980','288981','291940','292328','292329','294283','294311','295611','297088','297568','299116','299502','300324','301930','301939') 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 ('141328','141329','141355','141356','141357','141371','141372','141373','141374','141375','141794','141890','141933','142043','142056','142064','142704','142705','142838','143594','146696','148667','148668','148670','149278','149280','149286','149287','149288','149293','149294','149298','149305','149306','149307','149311','149312','149313','149314','149315','149317','150591','151112','151465','151574','154629','155765','156339','156379','156381','156383','156451','156515','156516','156517','156518','156520','156521','156522','159460','159461','160504','160505','160557','162103','162570','164065','164467','164989','165140','165555','166438','166905','166906','167100','167451','168051','208091','208172','215384','249771','251907','251908','253231','253242','255757','255787','255818','256174','256202','256210','256593','257068','261936','263469','265179','266365','266395','267016','268086','268309','268352','268523','268705','268754','269447','273606','273665','273844','274309','274446','274604','274690','275566','275692','276597','277586','277784','277785','277786','278566','278666','279093','279095','279096','279166','280415','280428','280584','280856','281195','281257','281274','281770','283139','283187','284599','285742','286015','286349','286986','287017','287049','288218','288559','288674','288675','288680','288681','288684','288685','288686','288687','288688','288689','288690','288786','288787','288788','288789','288791','288792','288793','288794','288795','288796','288797','288798','288799','288800','288801','288802','288803','288804','288805','288806','288807','288808','288809','288810','288811','288812','288813','288814','288815','288816','288817','288818','288819','288820','288821','288822','288972','288973','288974','288975','288976','288977','288978','288979','288980','288981','291940','292328','292329','294283','294311','295611','297088','297568','299116','299502','300324','301930','301939') GROUP BY `manuf` ORDER BY `manuf` ASC
