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 ('141733','141734','143182','143307','145453','147890','148374','149895','149896','149897','149898','149899','149900','150703','151022','151649','151703','151711','151985','153108','153131','153756','154318','154877','155182','155556','157625','157886','157909','158130','158275','158611','158827','159186','159261','159558','159578','159947','159975','160004','160142','160203','160326','160398','160457','160544','160546','160547','160548','160647','160869','160874','160953','161055','161095','161201','161298','161484','161636','161643','161717','161718','161898','161978','162577','162636','162779','162933','163162','163177','163755','163767','163823','163951','164181','164513','164659','164722','164826','164878','164902','165166','165666','165738','165869','166018','166320','166525','166725','166730','166861','167637','167860','168363','168380','169745','170622','202753','210966','210967','210968','210969','210971','210972','210973','210974','210975','210976','210977','210978','210979','210980','210981','215253','215488','215939','215940','216070','216085','219548','219760','238935','239006','239483','239666','239767','239857','239862','240018','240449','241066','241069','241070','241073','241580','241823','241949','241960','242284','242386','242449','242507','242510','242511','242581','243107','243121','243123','243144','243288','243387','243388','243876','243910','243938','243980','243986','244024','244025','244055','244105','244535','244544','244607','245147','245188','245189','245190','245191','245310','245311','245312','245480','245577','245658','246013','246097','246137','246680','246702','246754','246968','247054','247534','247615','247616','247632','247671','247758','247766','247803','247816','247966','248220','248617','248860','248862','248863','248864','249008','249094','249147','249238','249297','249526','249734','249921','249936','250057','250603','250848','251109','251145','251356','251873','252149','252150','252208','253125','253420','253495','253567','253576','253774','254397','254801','254862','255108','255114','255353','255497','255600','255643','255655','255749','256107','256109','256113','256175','256238','256432','256677','256735','256921','256965','261795','262257','262399','262419','262420','262421','262422','262426','262439','262533','262551','262588','262609','263069','263160','264370','264584','264588','264934','264947','265121','265207','265208','265209','265210','265598','265761','265767','266012','266281','266332','266445','266446','266506','266507','266515','266721','266966','267455','267456','267483','267633','267676','268129','268447','268565','268618','268632','268758','268882','269087','269201','269439','269453','273328','273966','274032','274092','274264','274289','274482','274590','274743','274753','274787','274807','274873','274996','275090','275264','275373','275752','276064','276082','276146','276447','276589','276590','276607','277251','277302','277963','278000','278151','278160','278226','278311','278334','278365','278467','278491','278534','278535','278536','278537','278538','278539','278541','278544','278545','278553','279157','279338','279425','279599','279783','280609','280623','280625','280626','280879','280971','281084','281240','281586','281593','281689','281762','282340','282348','282399','283389','283665','283675','283698','283699','283794','284453','284560','285003','285110','285312','285319','285320','285321','285322','285323','285356','285357','285358','285359','285538','285543','285563','285569','285574','285865','285934','286222','286262','286635','286666','286940','286941','286942','287537','287563','287763','287989','287994','288001','288002','288014','288031','288168','288169','288186','288237','288294','288353','288432','288576','288723','288724','288899','289303','289304','289305','289306','289307','289308','289309','289310','289311','289312','289313','289314','289315','289316','289317','289318','289319','289320','289416','289422','291602','291936','291960','291961','291962','291963','291964','291965','291966','291967','291968','291969','291970','291971','291972','291984','292578','292580','292625','292660','293474','293511','293588','293933','294015','294171','294339','294386','294408','294662','294809','294830','294902','295385','295473','295559','295628','295715','295803','297127','297137','297232','297233','297366','297367','297560','297692','298073','298079','298167','298351','298470','298520','299568','299575','299576','299577','299578','299579','299744','299767','299774','299879','299994','300052','300405','300415','300495','301878','301894','301921','302121','302176','302266','302311','302364') 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 ('141733','141734','143182','143307','145453','147890','148374','149895','149896','149897','149898','149899','149900','150703','151022','151649','151703','151711','151985','153108','153131','153756','154318','154877','155182','155556','157625','157886','157909','158130','158275','158611','158827','159186','159261','159558','159578','159947','159975','160004','160142','160203','160326','160398','160457','160544','160546','160547','160548','160647','160869','160874','160953','161055','161095','161201','161298','161484','161636','161643','161717','161718','161898','161978','162577','162636','162779','162933','163162','163177','163755','163767','163823','163951','164181','164513','164659','164722','164826','164878','164902','165166','165666','165738','165869','166018','166320','166525','166725','166730','166861','167637','167860','168363','168380','169745','170622','202753','210966','210967','210968','210969','210971','210972','210973','210974','210975','210976','210977','210978','210979','210980','210981','215253','215488','215939','215940','216070','216085','219548','219760','238935','239006','239483','239666','239767','239857','239862','240018','240449','241066','241069','241070','241073','241580','241823','241949','241960','242284','242386','242449','242507','242510','242511','242581','243107','243121','243123','243144','243288','243387','243388','243876','243910','243938','243980','243986','244024','244025','244055','244105','244535','244544','244607','245147','245188','245189','245190','245191','245310','245311','245312','245480','245577','245658','246013','246097','246137','246680','246702','246754','246968','247054','247534','247615','247616','247632','247671','247758','247766','247803','247816','247966','248220','248617','248860','248862','248863','248864','249008','249094','249147','249238','249297','249526','249734','249921','249936','250057','250603','250848','251109','251145','251356','251873','252149','252150','252208','253125','253420','253495','253567','253576','253774','254397','254801','254862','255108','255114','255353','255497','255600','255643','255655','255749','256107','256109','256113','256175','256238','256432','256677','256735','256921','256965','261795','262257','262399','262419','262420','262421','262422','262426','262439','262533','262551','262588','262609','263069','263160','264370','264584','264588','264934','264947','265121','265207','265208','265209','265210','265598','265761','265767','266012','266281','266332','266445','266446','266506','266507','266515','266721','266966','267455','267456','267483','267633','267676','268129','268447','268565','268618','268632','268758','268882','269087','269201','269439','269453','273328','273966','274032','274092','274264','274289','274482','274590','274743','274753','274787','274807','274873','274996','275090','275264','275373','275752','276064','276082','276146','276447','276589','276590','276607','277251','277302','277963','278000','278151','278160','278226','278311','278334','278365','278467','278491','278534','278535','278536','278537','278538','278539','278541','278544','278545','278553','279157','279338','279425','279599','279783','280609','280623','280625','280626','280879','280971','281084','281240','281586','281593','281689','281762','282340','282348','282399','283389','283665','283675','283698','283699','283794','284453','284560','285003','285110','285312','285319','285320','285321','285322','285323','285356','285357','285358','285359','285538','285543','285563','285569','285574','285865','285934','286222','286262','286635','286666','286940','286941','286942','287537','287563','287763','287989','288001','288002','288014','288031','288168','288186','288237','288294','288353','288432','288576','288723','288724','288899','289303','289304','289305','289306','289307','289308','289309','289310','289311','289312','289313','289314','289315','289316','289317','289318','289319','289320','289416','289422','291602','291936','291960','291961','291962','291963','291964','291965','291966','291967','291968','291969','291970','291971','291972','291984','292578','292580','292625','292660','293474','293511','293588','293933','294015','294171','294339','294386','294662','294809','294830','294902','295385','295473','295559','295628','295715','295803','297127','297137','297232','297233','297366','297367','297560','297692','298073','298079','298167','298351','298470','298520','299568','299575','299576','299577','299578','299579','299744','299767','299774','299879','299994','300052','300405','300415','300495','301878','301894','301921','302121','302176','302266','302311','302364') GROUP BY `manuf` ORDER BY `manuf` ASC