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 ('141445','141595','141755','141756','141944','141945','142016','142173','142174','142846','143056','143299','143347','143349','143787','146627','146636','146676','146747','148033','148047','148846','149684','149685','149686','150239','150249','150250','150251','150252','150253','150257','150258','150259','150260','150262','150264','150267','150270','150271','150272','151001','151278','151801','153798','153799','153800','153820','153931','154515','154793','154794','154795','154797','155105','155281','155282','155283','155284','155648','155867','156258','156261','156267','156326','156328','156335','156336','156337','156338','156363','156364','156388','156390','156392','156393','156394','156396','156397','156398','156399','156400','156401','156402','156403','156404','156406','156407','156409','156410','156411','156412','156414','156415','157711','159177','159464','159465','159570','160534','160754','161047','161593','162347','162348','162492','162494','162565','164066','164897','166884','166885','167125','167175','168129','169312','242858','251638','251925','266317','266420','266421','267022','267023','267029','267607','267822','268320','268711','268756','269013','269624','273610','274693','274901','275094','275218','275739','275780','275813','276549','276550','276610','276611','276694','277263','277288','277354','277520','277948','278169','278379','279151','279152','279179','279207','279579','280323','280855','281091','281309','281310','282764','283490','284137','284824','285147','285253','285262','285622','285680','286206','286214','286657','287788','288704','288705','289020','289021','289022','289023','289024','289025','289026','289027','289028','289029','289030','289031','289032','289093','289094','289096','289097','289098','289101','289102','289103','289104','289105','289107','289111','289112','289113','289114','289115','289116','289121','289122','289123','289124','289125','289126','289127','289128','289129','289130','289131','289208','289385','292411','292484','292727','292851','293489','294241','294300','294562','294583','294596','294597','294928','295413','297099','297134','297230','297802','298034','298038','299140','299142','299172','299654','299751','301037','301886','304034','304070','304111','304150','304248','304693') 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 ('141445','141595','141755','141756','141944','141945','142016','142173','142174','142846','143056','143299','143347','143349','143787','146627','146636','146676','146747','148033','148047','148846','149684','149685','149686','150239','150249','150250','150251','150252','150253','150257','150258','150259','150260','150262','150264','150267','150270','150271','150272','151001','151278','151801','153798','153799','153800','153820','153931','154515','154793','154794','154795','154797','155105','155281','155282','155283','155284','155648','155867','156258','156261','156267','156326','156328','156335','156336','156337','156338','156363','156364','156388','156390','156392','156393','156394','156396','156397','156398','156399','156400','156401','156402','156403','156404','156406','156407','156409','156410','156411','156412','156414','156415','157711','159177','159464','159465','159570','160534','160754','161047','161593','162347','162348','162492','162494','162565','164066','164897','166884','166885','167125','167175','168129','169312','242858','251638','251925','266317','266420','266421','267022','267023','267029','267607','267822','268320','268711','268756','269013','269624','273610','274693','274901','275094','275218','275739','275780','275813','276549','276550','276610','276611','276694','277263','277288','277354','277520','277948','278169','278379','279151','279152','279179','279207','279579','280323','280855','281091','281309','281310','282764','283490','284137','284824','285147','285253','285262','285622','285680','286206','286214','286657','287788','288704','288705','289020','289021','289022','289023','289024','289025','289026','289027','289028','289029','289030','289031','289032','289093','289094','289096','289097','289098','289101','289102','289103','289104','289105','289107','289111','289112','289113','289114','289115','289116','289121','289122','289123','289124','289125','289126','289127','289128','289129','289130','289131','289208','289385','292411','292484','292727','292851','293489','294241','294300','294562','294583','294596','294597','294928','295413','297099','297134','297230','297802','298034','298038','299140','299142','299172','299654','299751','301037','301886') GROUP BY `manuf` ORDER BY `manuf` ASC