Кабели и аксессуары

SELECT `parent`,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 `parent` !='' AND `modx_site_content`.`id` IN ('25','190','306','307','158838','166648','166649','166650','166768','167893','240722','241398','242325','242374','246470','247426','249636','249881','249991','250563','251576','251643','252243','252244','261770','261771','262125','262626','264349','264385','264659','264996','286361','92','149','275','283','158444','164984','166455','238872','239025','239887','240803','242258','245601','245974','246654','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','255131','256903','257020','257027','257035','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262992','266470','268197','268198','268199','268200','268741','269041','269576','273957','275854','275945','278560','279276','280613','280614','280628','280783','281781','281782','283343','283575','283576','285833','285946','285949','285951','285952','286344','286374','289091','289299','291706','291872','293279','294568','294778','294781','294898','294907','295177','295298','295307','295619','295655','296182','297199','299651','299943','300395','300396','302111','302273','152655','152660','153116','153139','154343','154736','154973','155286','155333','155653','155655','155656','155708','155709','157270','157271','157504','157844','158361','158792','159511','159534','160367','160580','160933','161034','161630','161631','163053','163636','163703','164230','164556','164557','165091','166552','167989','168006','168009','168083','168121','168211','219753','238135','241302','241509','241870','241871','242152','242221','242222','242490','242680','243349','244783','244784','245194','245721','247452','249007','249250','249311','249391','250682','250746','250747','250865','251172','251195','251255','251586','251595','251846','251857','253026','253187','253273','254944','254949','256343','256364','256742','262248','263021','263139','263640','263763','264479','264490','264492','264662','264687','264689','264768','264887','264888','265275','265401','265736','265794','266505','266680','266681','266682','266790','266980','266981','267551','267809','267977','268141','268358','268500','268883','269022','269187','269470','269578','273594','273883','273962','274017','274058','274060','274150','274310','274326','274329','274603','274729','274746','274880','275313','275314','275315','275505','275509','275613','275660','275748','276022','276253','276370','276448','276576','276591','276592','276812','277253','277326','277349','277664','277679','277732','278193','278445','278564','278565','278622','279419','280351','280389','280714','280741','280763','280764','280779','280822','281221','281720','281721','281736','282911','283348','284157','284295','284412','285266','285436','285481','285652','286062','286231','286260','286355','287995','288214','288246','288313','288314','288368','288498','289132','289281','289390','289505','292349','292492','292493','292494','292504','292692','292776','292816','292877','293230','293280','293592','294288','294390','294419','294420','294730','294862','294865','294896','294897','295154','295155','295279','295316','297194','297543','297599','297786','297977','298017','298018','299679','300253','300254','300505','300506','300580','302223','302256','303940','161012','163227','166784','167170','247042','249214','262973','262982','262983','262984','262985','262986','262989','262990','262991','263671','263726','263733','263734','263735','263736','263737','264425','266854','267827','267828','268330','269182','279816','282767','286185','286195','286259','288230','288566','288628','291689','297359','297360','153413','155451','155475','155476','157467','158942','160034','160381','160421','161383','162487','163312','163327','163328','163616','163617','163618','163620','163637','164161','164254','164255','165078','165997','167931','168394','238599','239442','239443','239444','240412','240955','240956','240960','241318','243229','243860','244216','247453','250528','250529','250530','250531','250532','253204','254459','262956','262957','262958','262959','262960','262961','262962','262963','262964','265467','266318','267435','267436','267437','267438','268103','268467','269073','274751','275292','275302','275596','276112','280889','283651','285242','285944','285945','288494','289004','289005','289006','289239','293365','294354','152651','153389','153390','153391','154245','154790','154906','154907','155338','155339','155540','155541','155658','155659','155660','157225','157226','157227','157228','157229','157230','157231','158242','158423','158424','158479','158565','159125','159785','159803','160310','160731','161670','162063','162714','162739','163467','164140','164141','164142','164422','165102','166907','166908','166909','167169','167293','167437','167921','167922','232518','232519','238580','238613','238614','238615','238619','239262','239263','239264','239265','239266','239553','240096','240478','240479','240480','240566','240746','240811','240906','241219','241752','241809','241810','241846','242070','242220','242243','242244','242245','242246','242412','242414','242422','242443','242451','242493','243294','243907','243908','244146','244272','244273','244274','244275','244276','244277','244278','244279','244280','244281','244282','244283','244310','244650','245853','248879','248945','248946','249126','249191','249192','249533','249534','249536','249874','249901','250061','250062','250154','250156','250157','250864','251641','251668','254239','254349','254749','254750','254751','254752','254753','254754','254755','254756','254757','254924','255375','255454','255873','255874','256351','256461','256596','256745','256746','256747','257038','257039','257040','257041','262613','262993','264777','265180','265181','265182','265183','265184','265185','265316','265405','265406','265407','265416','265491','265496','265499','265566','265748','265878','265956','266282','266297','266326','266327','266330','266335','266577','266959','267354','267448','267713','267714','267715','268580','268589','268590','268592','269146','269147','269148','269160','269227','269467','269468','273551','273659','273895','274062','274063','274065','274067','274135','274136','277301','277747','277975','278186','278265','278769','279167','279189','279190','279365','279369','279370','279372','279535','279706','281280','281822','281823','282392','283808','284525','284737','285936','285937','286343','286585','286656','287990','288229','288231','288348','288582','292743','292853','293322','293323','293324','293325','293326','293327','293328','293329','293330','293331','293332','293333','293334','293335','293336','293337','293338','293339','293340','293341','293342','293343','293344','293345','293346','293347','293348','293349','293350','293351','293352','293353','293354','293355','293356','293357','293358','293359','293360','293361','293362','293363','293364','293366','293367','293368','294988','295444','295656','295657','297657','298285','298286','298294','298295','298296','298297','298298','298299','298300','298304','298305','298306','298307','299279','299935','300256','300263','300264','300393','301804','301997','302145','303858','155516','157458','157459','158635','158636','158861','159281','159986','159987','160501','163726','164366','164630','164926','165197','165642','165684','165799','165927','166149','167707','167936','167937','167999','168094','232717','238097','238098','238396','238499','238500','238884','240267','240268','240506','242767','242973','242974','243161','243162','243163','243164','243966','244160','244668','244744','244745','244746','244928','245070','245141','245227','245815','245902','245930','246195','246196','247588','247864','247865','249604','249605','249606','249607','249608','249609','249610','249637','249890','251033','251140','251141','251442','255144','255145','255146','255159','255165','255654','255768','256761','256967','257281','262402','262855','263680','264669','264868','264940','265462','265472','265473','266131','266132','266133','266134','268795','269226','269383','273999','274061','274274','275405','275502','275503','275563','275980','276367','276432','276582','276583','277271','277368','277969','277970','277971','277972','278049','278069','278070','278071','278315','278410','278473','278709','278710','279174','279464','279577','279753','280539','280891','280892','281009','281180','282117','284357','285107','285337','285381','285798','286204','286205','286275','286367','287223','287510','288487','288607','289214','289392','291703','291704','292351','292368','292469','292516','292648','292653','292684','294504','295375','297215','297216','297217','297218','297478','298582','299212','299435','299487','299746','299787','299822','299823','299852','299854','299855','299881','299893','300619','300668','302341','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801','152650','153580','155030','157730','157933','159521','159584','159629','159630','159637','160409','160444','160526','161433','161641','161706','161854','162052','163048','164425','165071','165072','165073','165074','165075','165076','165303','165501','166644','166980','167033','167190','167477','167507','167573','167708','167996','168049','219748','219756','219770','219771','238306','239026','239027','239808','239809','239810','239811','239812','239873','240381','240382','241505','242834','242835','242987','243698','243962','244231','244242','244302','244467','245006','245007','246058','246381','246837','247102','247153','247589','247831','248051','248063','248111','248326','248650','248651','248799','249334','249885','249886','249887','249888','249889','250063','250072','250223','250332','250533','250534','250546','250547','250548','250549','250550','250551','250552','250553','250554','250557','250558','250559','250560','250561','250562','250574','250575','250576','250577','250663','250739','253503','255063','255278','255556','255557','255558','255559','255560','255582','255618','255645','256211','256212','256744','262056','262057','262058','262059','262060','262061','262083','262404','262556','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','263037','263038','263039','265010','265246','265247','265475','266174','266466','266471','266554','266634','266744','266894','266992','267107','267266','267267','267268','267269','267270','267271','267272','267273','267274','267275','267276','267277','267278','267279','267280','267281','267532','267716','268042','268311','268528','268581','268615','268724','268725','268726','269033','269034','269039','269040','269494','269574','273348','273372','273507','273509','273564','273578','273722','273769','273770','273771','273772','273773','273774','273784','273785','273786','273839','273840','273908','274015','274021','274022','274023','274027','274029','274030','274279','274339','274380','274491','274596','274923','274994','275031','275130','275132','275133','275540','275787','278041','278042','278043','278044','278045','278046','278047','278072','278348','278349','278350','278351','278352','278353','278354','278967','278968','278969','278971','278972','278973','278974','278975','278976','278977','278981','278982','278983','278984','278987','278988','278989','278992','279168','279186','279187','279188','279665','279715','280348','280448','280479','280482','280484','280485','280486','280641','280729','281674','281937','282535','282982','283327','283566','283631','283638','284373','284374','284404','284468','284739','285180','285181','285304','285668','285816','285822','286120','286256','286385','286386','286393','286627','286840','286843','287101','287103','287112','287984','288564','288960','291621','291628','291673','292350','292501','293281','293282','293562','294264','294309','294384','294385','294497','294585','294589','294605','294687','294950','295280','295466','295475','295509','295581','295651','295813','297520','297898','298441','299204','299772','299789','299891','299961','299962','300071','300202','300433','300525','300611','300678','300679','300680','301863','302070','302185','302192','302193','303899','285948','286996','286997','286998','291589') GROUP BY `parent` ORDER BY `parent` ASC

SELECT `parent`,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 `parent` !='' AND `modx_site_content`.`id` IN ('152650','152651','152655','152660','153116','153139','153389','153390','153391','153413','153580','154245','154343','154736','154790','154906','154907','154973','155030','155286','155333','155338','155339','155451','155475','155476','155516','155540','155541','155653','155655','155656','155658','155659','155660','155708','155709','157225','157226','157227','157228','157229','157230','157231','157270','157271','157458','157459','157467','157504','157509','157510','157730','157844','157933','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158242','158248','158361','158380','158423','158424','158444','158479','158565','158613','158635','158636','158762','158792','158838','158861','158942','159003','159125','159281','159511','159521','159534','159584','159629','159630','159637','159785','159803','159986','159987','160034','160310','160367','160381','160409','160421','160444','160501','160526','160559','160580','160731','160933','161012','161034','161383','161433','161630','161631','161641','161670','161706','161728','161854','162052','162063','162285','162487','162714','162739','163048','163053','163227','163312','163327','163328','163467','163616','163617','163618','163620','163636','163637','163703','163726','164140','164141','164142','164161','164230','164254','164255','164366','164422','164425','164548','164556','164557','164630','164926','164984','165071','165072','165073','165074','165075','165076','165078','165091','165102','165197','165303','165501','165642','165684','165799','165927','165997','166112','166149','166455','166524','166552','166644','166648','166649','166650','166768','166784','166907','166908','166909','166980','167033','167169','167170','167190','167293','167437','167477','167507','167573','167687','167707','167708','167893','167921','167922','167931','167936','167937','167989','167996','167999','168006','168009','168049','168083','168094','168121','168211','168394','219748','219753','219756','219770','219771','232518','232519','232606','232717','232744','238097','238098','238135','238306','238396','238499','238500','238580','238599','238613','238614','238615','238619','238812','238813','238814','238815','238837','238872','238884','239025','239026','239027','239085','239216','239231','239259','239262','239263','239264','239265','239266','239442','239443','239444','239553','239808','239809','239810','239811','239812','239873','239887','240068','240096','240267','240268','240381','240382','240412','240435','240478','240479','240480','240506','240566','240722','240746','240803','240811','240906','240955','240956','240960','241219','241302','241318','241398','241505','241509','241752','241809','241810','241846','241870','241871','242070','242152','242220','242221','242222','242243','242244','242245','242246','242258','242325','242374','242412','242414','242422','242443','242451','242490','242493','242680','242767','242834','242835','242973','242974','242987','243161','243162','243163','243164','243229','243294','243349','243698','243860','243907','243908','243962','243966','244146','244160','244216','244231','244242','244272','244273','244274','244275','244276','244277','244278','244279','244280','244281','244282','244283','244302','244310','244467','244650','244668','244744','244745','244746','244783','244784','244928','245006','245007','245070','245141','245194','245227','245601','245721','245815','245853','245902','245930','245974','246058','246195','246196','246381','246470','246654','246837','247042','247102','247153','247426','247446','247452','247453','247588','247589','247831','247864','247865','248051','248063','248111','248326','248650','248651','248799','248879','248945','248946','249007','249126','249191','249192','249214','249250','249311','249334','249391','249533','249534','249536','249604','249605','249606','249607','249608','249609','249610','249636','249637','249874','249881','249885','249886','249887','249888','249889','249890','249901','249991','250061','250062','250063','250072','250154','250156','250157','250223','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250332','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','250528','250529','250530','250531','250532','250533','250534','250546','250547','250548','250549','250550','250551','250552','250553','250554','250557','250558','250559','250560','250561','250562','250563','250574','250575','250576','250577','250589','250663','250682','250739','250746','250747','250864','250865','251033','251140','251141','251172','251195','251255','251359','251442','251576','251586','251595','251641','251643','251668','251846','251857','252243','252244','253026','253187','253204','253266','253273','253503','253874','253906','254239','254349','254459','254544','254731','254749','254750','254751','254752','254753','254754','254755','254756','254757','254924','254944','254949','255063','255131','255144','255145','255146','255159','255165','255278','255375','255454','255556','255557','255558','255559','255560','255582','255618','255645','255654','255768','255873','255874','256006','256007','256211','256212','256343','256351','256364','256461','256596','256742','256744','256745','256746','256747','256761','256798','256903','256967','257020','257027','257035','257038','257039','257040','257041','257281','261770','261771','262056','262057','262058','262059','262060','262061','262083','262125','262248','262402','262404','262512','262513','262514','262515','262556','262613','262626','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','262855','262956','262957','262958','262959','262960','262961','262962','262963','262964','262973','262982','262983','262984','262985','262986','262989','262990','262991','262992','262993','263021','263037','263038','263039','263139','263467','263640','263671','263680','263726','263733','263734','263735','263736','263737','263763','264349','264385','264425','264440','264479','264490','264492','264659','264662','264669','264687','264689','264768','264777','264868','264887','264888','264940','264996','265010','265062','265180','265181','265182','265183','265184','265185','265246','265247','265275','265316','265401','265405','265406','265407','265416','265462','265467','265472','265473','265475','265491','265496','265499','265566','265736','265748','265794','265878','265956','266131','266132','266133','266134','266174','266282','266297','266318','266326','266327','266330','266335','266466','266470','266471','266505','266554','266577','266621','266624','266634','266680','266681','266682','266744','266790','266854','266894','266959','266980','266981','266992','267107','267266','267267','267268','267269','267270','267271','267272','267273','267274','267275','267276','267277','267278','267279','267280','267281','267354','267435','267436','267437','267438','267448','267532','267551','267713','267714','267715','267716','267809','267827','267828','267977','268042','268103','268141','268197','268198','268199','268200','268311','268330','268357','268358','268454','268467','268500','268528','268580','268581','268589','268590','268592','268615','268625','268724','268725','268726','268741','268795','268883','269022','269033','269034','269039','269040','269041','269073','269146','269147','269148','269160','269182','269187','269226','269227','269383','269467','269468','269470','269494','269574','269576','269578','273348','273372','273507','273509','273551','273564','273578','273594','273659','273722','273769','273770','273771','273772','273773','273774','273784','273785','273786','273839','273840','273883','273895','273908','273933','273955','273957','273962','273999','274015','274017','274021','274022','274023','274027','274029','274030','274058','274060','274061','274062','274063','274065','274067','274082','274135','274136','274150','274274','274279','274307','274310','274326','274329','274339','274380','274491','274596','274603','274729','274746','274749','274751','274880','274923','274994','275031','275067','275130','275132','275133','275292','275302','275313','275314','275315','275405','275502','275503','275505','275509','275540','275563','275596','275613','275660','275748','275787','275854','275945','275980','276022','276112','276253','276367','276370','276432','276448','276576','276582','276583','276591','276592','276812','277253','277271','277301','277326','277349','277368','277664','277679','277732','277747','277938','277969','277970','277971','277972','277975','278041','278042','278043','278044','278045','278046','278047','278049','278069','278070','278071','278072','278186','278193','278265','278315','278342','278348','278349','278350','278351','278352','278353','278354','278410','278445','278473','278560','278564','278565','278622','278709','278710','278769','278967','278968','278969','278971','278972','278973','278974','278975','278976','278977','278981','278982','278983','278984','278987','278988','278989','278992','279167','279168','279174','279186','279187','279188','279189','279190','279276','279365','279369','279370','279372','279419','279464','279535','279577','279665','279706','279715','279753','279816','280348','280351','280389','280448','280479','280482','280484','280485','280486','280539','280613','280614','280628','280641','280714','280729','280741','280763','280764','280779','280783','280822','280889','280891','280892','281009','281023','281025','281180','281221','281280','281674','281720','281721','281736','281781','281782','281822','281823','281937','282117','282392','282535','282767','282880','282911','282982','283047','283048','283050','283327','283343','283348','283566','283575','283576','283631','283638','283651','283808','284157','284295','284312','284313','284357','284373','284374','284404','284412','284468','284525','284737','284739','285107','285180','285181','285242','285248','285249','285266','285304','285337','285381','285436','285481','285652','285668','285798','285816','285822','285833','285936','285937','285944','285945','285946','285948','285949','285951','285952','286056','286062','286120','286185','286195','286204','286205','286231','286256','286259','286260','286275','286343','286344','286355','286367','286374','286385','286386','286393','286400','286585','286627','286656','286840','286843','286850','286852','286996','286997','286998','287101','287103','287112','287223','287510','287777','287984','287990','287995','288214','288229','288230','288231','288246','288313','288314','288348','288368','288487','288494','288498','288564','288566','288582','288607','288609','288628','288960','289004','289005','289006','289091','289132','289214','289239','289281','289299','289390','289392','289505','291589','291621','291628','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','291673','291689','291703','291704','291706','291872','292349','292350','292351','292368','292469','292492','292493','292494','292501','292504','292516','292648','292653','292684','292692','292743','292776','292816','292853','292877','293230','293279','293280','293281','293282','293322','293323','293324','293325','293326','293327','293328','293329','293330','293331','293332','293333','293334','293335','293336','293337','293338','293339','293340','293341','293342','293343','293344','293345','293346','293347','293348','293349','293350','293351','293352','293353','293354','293355','293356','293357','293358','293359','293360','293361','293362','293363','293364','293365','293366','293367','293368','293477','293562','293592','294152','294264','294288','294309','294354','294384','294385','294390','294419','294420','294497','294504','294568','294585','294589','294605','294687','294730','294778','294781','294862','294865','294896','294897','294898','294907','294950','294988','294992','295154','295155','295177','295279','295280','295298','295307','295316','295375','295444','295466','295475','295509','295581','295619','295651','295655','295656','295657','295813','296182','297083','297084','297085','297194','297199','297215','297216','297217','297218','297359','297360','297478','297520','297543','297599','297623','297657','297786','297898','297977','298017','298018','298285','298286','298294','298295','298296','298297','298298','298299','298300','298304','298305','298306','298307','298441','298582','299204','299212','299246','299279','299435','299487','299587','299588','299589','299590','299591','299592','299593','299651','299679','299746','299772','299787','299789','299822','299823','299852','299854','299855','299881','299891','299893','299935','299943','299961','299962','300071','300202','300253','300254','300256','300263','300264','300393','300395','300396','300433','300505','300506','300525','300580','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','300611','300619','300668','300678','300679','300680','301034','301801','301804','301863','301997','302070','302111','302145','302185','302192','302193','302223','302256','302273','302341','303858','303899','303940') GROUP BY `parent` ORDER BY `parent` ASC

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 ('25','190','306','307','158838','166648','166649','166650','166768','167893','240722','241398','242325','242374','246470','247426','249636','249881','249991','250563','251576','251643','252243','252244','261770','261771','262125','262626','264349','264385','264659','264996','286361','92','149','275','283','158444','164984','166455','238872','239025','239887','240803','242258','245601','245974','246654','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','255131','256903','257020','257027','257035','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262992','266470','268197','268198','268199','268200','268741','269041','269576','273957','275854','275945','278560','279276','280613','280614','280628','280783','281781','281782','283343','283575','283576','285833','285946','285949','285951','285952','286344','286374','289091','289299','291706','291872','293279','294568','294778','294781','294898','294907','295177','295298','295307','295619','295655','296182','297199','299651','299943','300395','300396','302111','302273','152655','152660','153116','153139','154343','154736','154973','155286','155333','155653','155655','155656','155708','155709','157270','157271','157504','157844','158361','158792','159511','159534','160367','160580','160933','161034','161630','161631','163053','163636','163703','164230','164556','164557','165091','166552','167989','168006','168009','168083','168121','168211','219753','238135','241302','241509','241870','241871','242152','242221','242222','242490','242680','243349','244783','244784','245194','245721','247452','249007','249250','249311','249391','250682','250746','250747','250865','251172','251195','251255','251586','251595','251846','251857','253026','253187','253273','254944','254949','256343','256364','256742','262248','263021','263139','263640','263763','264479','264490','264492','264662','264687','264689','264768','264887','264888','265275','265401','265736','265794','266505','266680','266681','266682','266790','266980','266981','267551','267809','267977','268141','268358','268500','268883','269022','269187','269470','269578','273594','273883','273962','274017','274058','274060','274150','274310','274326','274329','274603','274729','274746','274880','275313','275314','275315','275505','275509','275613','275660','275748','276022','276253','276370','276448','276576','276591','276592','276812','277253','277326','277349','277664','277679','277732','278193','278445','278564','278565','278622','279419','280351','280389','280714','280741','280763','280764','280779','280822','281221','281720','281721','281736','282911','283348','284157','284295','284412','285266','285436','285481','285652','286062','286231','286260','286355','287995','288214','288246','288313','288314','288368','288498','289132','289281','289390','289505','292349','292492','292493','292494','292504','292692','292776','292816','292877','293230','293280','293592','294288','294390','294419','294420','294730','294862','294865','294896','294897','295154','295155','295279','295316','297194','297543','297599','297786','297977','298017','298018','299679','300253','300254','300505','300506','300580','302223','302256','303940','161012','163227','166784','167170','247042','249214','262973','262982','262983','262984','262985','262986','262989','262990','262991','263671','263726','263733','263734','263735','263736','263737','264425','266854','267827','267828','268330','269182','279816','282767','286185','286195','286259','288230','288566','288628','291689','297359','297360','153413','155451','155475','155476','157467','158942','160034','160381','160421','161383','162487','163312','163327','163328','163616','163617','163618','163620','163637','164161','164254','164255','165078','165997','167931','168394','238599','239442','239443','239444','240412','240955','240956','240960','241318','243229','243860','244216','247453','250528','250529','250530','250531','250532','253204','254459','262956','262957','262958','262959','262960','262961','262962','262963','262964','265467','266318','267435','267436','267437','267438','268103','268467','269073','274751','275292','275302','275596','276112','280889','283651','285242','285944','285945','288494','289004','289005','289006','289239','293365','294354','152651','153389','153390','153391','154245','154790','154906','154907','155338','155339','155540','155541','155658','155659','155660','157225','157226','157227','157228','157229','157230','157231','158242','158423','158424','158479','158565','159125','159785','159803','160310','160731','161670','162063','162714','162739','163467','164140','164141','164142','164422','165102','166907','166908','166909','167169','167293','167437','167921','167922','232518','232519','238580','238613','238614','238615','238619','239262','239263','239264','239265','239266','239553','240096','240478','240479','240480','240566','240746','240811','240906','241219','241752','241809','241810','241846','242070','242220','242243','242244','242245','242246','242412','242414','242422','242443','242451','242493','243294','243907','243908','244146','244272','244273','244274','244275','244276','244277','244278','244279','244280','244281','244282','244283','244310','244650','245853','248879','248945','248946','249126','249191','249192','249533','249534','249536','249874','249901','250061','250062','250154','250156','250157','250864','251641','251668','254239','254349','254749','254750','254751','254752','254753','254754','254755','254756','254757','254924','255375','255454','255873','255874','256351','256461','256596','256745','256746','256747','257038','257039','257040','257041','262613','262993','264777','265180','265181','265182','265183','265184','265185','265316','265405','265406','265407','265416','265491','265496','265499','265566','265748','265878','265956','266282','266297','266326','266327','266330','266335','266577','266959','267354','267448','267713','267714','267715','268580','268589','268590','268592','269146','269147','269148','269160','269227','269467','269468','273551','273659','273895','274062','274063','274065','274067','274135','274136','277301','277747','277975','278186','278265','278769','279167','279189','279190','279365','279369','279370','279372','279535','279706','281280','281822','281823','282392','283808','284525','284737','285936','285937','286343','286585','286656','287990','288229','288231','288348','288582','292743','292853','293322','293323','293324','293325','293326','293327','293328','293329','293330','293331','293332','293333','293334','293335','293336','293337','293338','293339','293340','293341','293342','293343','293344','293345','293346','293347','293348','293349','293350','293351','293352','293353','293354','293355','293356','293357','293358','293359','293360','293361','293362','293363','293364','293366','293367','293368','294988','295444','295656','295657','297657','298285','298286','298294','298295','298296','298297','298298','298299','298300','298304','298305','298306','298307','299279','299935','300256','300263','300264','300393','301804','301997','302145','303858','155516','157458','157459','158635','158636','158861','159281','159986','159987','160501','163726','164366','164630','164926','165197','165642','165684','165799','165927','166149','167707','167936','167937','167999','168094','232717','238097','238098','238396','238499','238500','238884','240267','240268','240506','242767','242973','242974','243161','243162','243163','243164','243966','244160','244668','244744','244745','244746','244928','245070','245141','245227','245815','245902','245930','246195','246196','247588','247864','247865','249604','249605','249606','249607','249608','249609','249610','249637','249890','251033','251140','251141','251442','255144','255145','255146','255159','255165','255654','255768','256761','256967','257281','262402','262855','263680','264669','264868','264940','265462','265472','265473','266131','266132','266133','266134','268795','269226','269383','273999','274061','274274','275405','275502','275503','275563','275980','276367','276432','276582','276583','277271','277368','277969','277970','277971','277972','278049','278069','278070','278071','278315','278410','278473','278709','278710','279174','279464','279577','279753','280539','280891','280892','281009','281180','282117','284357','285107','285337','285381','285798','286204','286205','286275','286367','287223','287510','288487','288607','289214','289392','291703','291704','292351','292368','292469','292516','292648','292653','292684','294504','295375','297215','297216','297217','297218','297478','298582','299212','299435','299487','299746','299787','299822','299823','299852','299854','299855','299881','299893','300619','300668','302341','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','167687','232606','232744','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256798','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','281023','281025','282880','283047','283048','283050','284312','284313','285248','285249','286056','286400','286850','286852','287777','288609','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','293477','294152','294992','297083','297084','297085','297623','299246','299587','299588','299589','299590','299591','299592','299593','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','301034','301801','152650','153580','155030','157730','157933','159521','159584','159629','159630','159637','160409','160444','160526','161433','161641','161706','161854','162052','163048','164425','165071','165072','165073','165074','165075','165076','165303','165501','166644','166980','167033','167190','167477','167507','167573','167708','167996','168049','219748','219756','219770','219771','238306','239026','239027','239808','239809','239810','239811','239812','239873','240381','240382','241505','242834','242835','242987','243698','243962','244231','244242','244302','244467','245006','245007','246058','246381','246837','247102','247153','247589','247831','248051','248063','248111','248326','248650','248651','248799','249334','249885','249886','249887','249888','249889','250063','250072','250223','250332','250533','250534','250546','250547','250548','250549','250550','250551','250552','250553','250554','250557','250558','250559','250560','250561','250562','250574','250575','250576','250577','250663','250739','253503','255063','255278','255556','255557','255558','255559','255560','255582','255618','255645','256211','256212','256744','262056','262057','262058','262059','262060','262061','262083','262404','262556','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','263037','263038','263039','265010','265246','265247','265475','266174','266466','266471','266554','266634','266744','266894','266992','267107','267266','267267','267268','267269','267270','267271','267272','267273','267274','267275','267276','267277','267278','267279','267280','267281','267532','267716','268042','268311','268528','268581','268615','268724','268725','268726','269033','269034','269039','269040','269494','269574','273348','273372','273507','273509','273564','273578','273722','273769','273770','273771','273772','273773','273774','273784','273785','273786','273839','273840','273908','274015','274021','274022','274023','274027','274029','274030','274279','274339','274380','274491','274596','274923','274994','275031','275130','275132','275133','275540','275787','278041','278042','278043','278044','278045','278046','278047','278072','278348','278349','278350','278351','278352','278353','278354','278967','278968','278969','278971','278972','278973','278974','278975','278976','278977','278981','278982','278983','278984','278987','278988','278989','278992','279168','279186','279187','279188','279665','279715','280348','280448','280479','280482','280484','280485','280486','280641','280729','281674','281937','282535','282982','283327','283566','283631','283638','284373','284374','284404','284468','284739','285180','285181','285304','285668','285816','285822','286120','286256','286385','286386','286393','286627','286840','286843','287101','287103','287112','287984','288564','288960','291621','291628','291673','292350','292501','293281','293282','293562','294264','294309','294384','294385','294497','294585','294589','294605','294687','294950','295280','295466','295475','295509','295581','295651','295813','297520','297898','298441','299204','299772','299789','299891','299961','299962','300071','300202','300433','300525','300611','300678','300679','300680','301863','302070','302185','302192','302193','303899','285948','286996','286997','286998','291589') GROUP BY `manuf` ORDER BY `manuf` ASC

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 ('152650','152651','152655','152660','153116','153139','153389','153390','153391','153413','153580','154245','154343','154736','154790','154906','154907','154973','155030','155286','155333','155338','155339','155451','155475','155476','155516','155540','155541','155653','155655','155656','155658','155659','155660','155708','155709','157225','157226','157227','157228','157229','157230','157231','157270','157271','157458','157459','157467','157504','157509','157510','157730','157844','157933','157985','157989','157990','157991','157992','157993','157994','157995','157997','157998','157999','158215','158242','158248','158361','158380','158423','158424','158444','158479','158565','158613','158635','158636','158762','158792','158838','158861','158942','159003','159125','159281','159511','159521','159534','159584','159629','159630','159637','159785','159803','159986','159987','160034','160310','160367','160381','160409','160421','160444','160501','160526','160559','160580','160731','160933','161012','161034','161383','161433','161630','161631','161641','161670','161706','161728','161854','162052','162063','162285','162487','162714','162739','163048','163053','163227','163312','163327','163328','163467','163616','163617','163618','163620','163636','163637','163703','163726','164140','164141','164142','164161','164230','164254','164255','164366','164422','164425','164548','164556','164557','164630','164926','164984','165071','165072','165073','165074','165075','165076','165078','165091','165102','165197','165303','165501','165642','165684','165799','165927','165997','166112','166149','166455','166524','166552','166644','166648','166649','166650','166768','166784','166907','166908','166909','166980','167033','167169','167170','167190','167293','167437','167477','167507','167573','167687','167707','167708','167893','167921','167922','167931','167936','167937','167989','167996','167999','168006','168009','168049','168083','168094','168121','168211','168394','219748','219753','219756','219770','219771','232518','232519','232606','232717','232744','238097','238098','238135','238306','238396','238499','238500','238580','238599','238613','238614','238615','238619','238812','238813','238814','238815','238837','238872','238884','239025','239026','239027','239085','239216','239231','239259','239262','239263','239264','239265','239266','239442','239443','239444','239553','239808','239809','239810','239811','239812','239873','239887','240068','240096','240267','240268','240381','240382','240412','240435','240478','240479','240480','240506','240566','240722','240746','240803','240811','240906','240955','240956','240960','241219','241302','241318','241398','241505','241509','241752','241809','241810','241846','241870','241871','242070','242152','242220','242221','242222','242243','242244','242245','242246','242258','242325','242374','242412','242414','242422','242443','242451','242490','242493','242680','242767','242834','242835','242973','242974','242987','243161','243162','243163','243164','243229','243294','243349','243698','243860','243907','243908','243962','243966','244146','244160','244216','244231','244242','244272','244273','244274','244275','244276','244277','244278','244279','244280','244281','244282','244283','244302','244310','244467','244650','244668','244744','244745','244746','244783','244784','244928','245006','245007','245070','245141','245194','245227','245601','245721','245815','245853','245902','245930','245974','246058','246195','246196','246381','246470','246654','246837','247042','247102','247153','247426','247446','247452','247453','247588','247589','247831','247864','247865','248051','248063','248111','248326','248650','248651','248799','248879','248945','248946','249007','249126','249191','249192','249214','249250','249311','249334','249391','249533','249534','249536','249604','249605','249606','249607','249608','249609','249610','249636','249637','249874','249881','249885','249886','249887','249888','249889','249890','249901','249991','250061','250062','250063','250072','250154','250156','250157','250223','250302','250303','250304','250305','250306','250307','250308','250309','250310','250311','250312','250313','250314','250315','250316','250317','250318','250319','250320','250321','250322','250332','250355','250356','250357','250358','250359','250360','250361','250362','250363','250364','250365','250366','250367','250368','250369','250370','250371','250372','250373','250374','250375','250376','250377','250378','250379','250380','250381','250382','250383','250384','250385','250386','250387','250388','250389','250390','250391','250392','250393','250394','250395','250396','250397','250398','250399','250400','250401','250402','250403','250404','250405','250406','250407','250408','250409','250410','250411','250412','250413','250414','250415','250416','250417','250418','250419','250420','250421','250422','250423','250424','250425','250426','250427','250428','250429','250430','250431','250432','250433','250434','250435','250436','250437','250438','250439','250440','250441','250442','250443','250444','250445','250446','250447','250528','250529','250530','250531','250532','250533','250534','250546','250547','250548','250549','250550','250551','250552','250553','250554','250557','250558','250559','250560','250561','250562','250563','250574','250575','250576','250577','250589','250663','250682','250739','250746','250747','250864','250865','251033','251140','251141','251172','251195','251255','251359','251442','251576','251586','251595','251641','251643','251668','251846','251857','252243','252244','253026','253187','253204','253266','253273','253503','253874','253906','254239','254349','254459','254544','254731','254749','254750','254751','254752','254753','254754','254755','254756','254757','254924','254944','254949','255063','255131','255144','255145','255146','255159','255165','255278','255375','255454','255556','255557','255558','255559','255560','255582','255618','255645','255654','255768','255873','255874','256006','256007','256211','256212','256343','256351','256364','256461','256596','256742','256744','256745','256746','256747','256761','256798','256903','256967','257020','257027','257035','257038','257039','257040','257041','257281','261770','261771','262056','262057','262058','262059','262060','262061','262083','262125','262248','262402','262404','262512','262513','262514','262515','262556','262613','262626','262628','262629','262630','262631','262632','262633','262634','262635','262636','262637','262740','262741','262742','262743','262744','262745','262746','262747','262748','262749','262750','262751','262855','262956','262957','262958','262959','262960','262961','262962','262963','262964','262973','262982','262983','262984','262985','262986','262989','262990','262991','262992','262993','263021','263037','263038','263039','263139','263467','263640','263671','263680','263726','263733','263734','263735','263736','263737','263763','264349','264385','264425','264440','264479','264490','264492','264659','264662','264669','264687','264689','264768','264777','264868','264887','264888','264940','264996','265010','265062','265180','265181','265182','265183','265184','265185','265246','265247','265275','265316','265401','265405','265406','265407','265416','265462','265467','265472','265473','265475','265491','265496','265499','265566','265736','265748','265794','265878','265956','266131','266132','266133','266134','266174','266282','266297','266318','266326','266327','266330','266335','266466','266470','266471','266505','266554','266577','266621','266624','266634','266680','266681','266682','266744','266790','266854','266894','266959','266980','266981','266992','267107','267266','267267','267268','267269','267270','267271','267272','267273','267274','267275','267276','267277','267278','267279','267280','267281','267354','267435','267436','267437','267438','267448','267532','267551','267713','267714','267715','267716','267809','267827','267828','267977','268042','268103','268141','268197','268198','268199','268200','268311','268330','268357','268358','268454','268467','268500','268528','268580','268581','268589','268590','268592','268615','268625','268724','268725','268726','268741','268795','268883','269022','269033','269034','269039','269040','269041','269073','269146','269147','269148','269160','269182','269187','269226','269227','269383','269467','269468','269470','269494','269574','269576','269578','273348','273372','273507','273509','273551','273564','273578','273594','273659','273722','273769','273770','273771','273772','273773','273774','273784','273785','273786','273839','273840','273883','273895','273908','273933','273955','273957','273962','273999','274015','274017','274021','274022','274023','274027','274029','274030','274058','274060','274061','274062','274063','274065','274067','274082','274135','274136','274150','274274','274279','274307','274310','274326','274329','274339','274380','274491','274596','274603','274729','274746','274749','274751','274880','274923','274994','275031','275067','275130','275132','275133','275292','275302','275313','275314','275315','275405','275502','275503','275505','275509','275540','275563','275596','275613','275660','275748','275787','275854','275945','275980','276022','276112','276253','276367','276370','276432','276448','276576','276582','276583','276591','276592','276812','277253','277271','277301','277326','277349','277368','277664','277679','277732','277747','277938','277969','277970','277971','277972','277975','278041','278042','278043','278044','278045','278046','278047','278049','278069','278070','278071','278072','278186','278193','278265','278315','278342','278348','278349','278350','278351','278352','278353','278354','278410','278445','278473','278560','278564','278565','278622','278709','278710','278769','278967','278968','278969','278971','278972','278973','278974','278975','278976','278977','278981','278982','278983','278984','278987','278988','278989','278992','279167','279168','279174','279186','279187','279188','279189','279190','279276','279365','279369','279370','279372','279419','279464','279535','279577','279665','279706','279715','279753','279816','280348','280351','280389','280448','280479','280482','280484','280485','280486','280539','280613','280614','280628','280641','280714','280729','280741','280763','280764','280779','280783','280822','280889','280891','280892','281009','281023','281025','281180','281221','281280','281674','281720','281721','281736','281781','281782','281822','281823','281937','282117','282392','282535','282767','282880','282911','282982','283047','283048','283050','283327','283343','283348','283566','283575','283576','283631','283638','283651','283808','284157','284295','284312','284313','284357','284373','284374','284404','284412','284468','284525','284737','284739','285107','285180','285181','285242','285248','285249','285266','285304','285337','285381','285436','285481','285652','285668','285798','285816','285822','285833','285936','285937','285944','285945','285946','285948','285949','285951','285952','286056','286062','286120','286185','286195','286204','286205','286231','286256','286259','286260','286275','286343','286344','286355','286367','286374','286385','286386','286393','286400','286585','286627','286656','286840','286843','286850','286852','286996','286997','286998','287101','287103','287112','287223','287510','287777','287984','287990','287995','288214','288229','288230','288231','288246','288313','288314','288348','288368','288487','288494','288498','288564','288566','288582','288607','288609','288628','288960','289004','289005','289006','289091','289132','289214','289239','289281','289299','289390','289392','289505','291589','291621','291628','291650','291651','291652','291653','291654','291655','291656','291657','291658','291659','291660','291661','291662','291663','291664','291665','291666','291667','291668','291673','291689','291703','291704','291706','291872','292349','292350','292351','292368','292469','292492','292493','292494','292501','292504','292516','292648','292653','292684','292692','292743','292776','292816','292853','292877','293230','293279','293280','293281','293282','293322','293323','293324','293325','293326','293327','293328','293329','293330','293331','293332','293333','293334','293335','293336','293337','293338','293339','293340','293341','293342','293343','293344','293345','293346','293347','293348','293349','293350','293351','293352','293353','293354','293355','293356','293357','293358','293359','293360','293361','293362','293363','293364','293365','293366','293367','293368','293477','293562','293592','294152','294264','294288','294309','294354','294384','294385','294390','294419','294420','294497','294504','294568','294585','294589','294605','294687','294730','294778','294781','294862','294865','294896','294897','294898','294907','294950','294988','294992','295154','295155','295177','295279','295280','295298','295307','295316','295375','295444','295466','295475','295509','295581','295619','295651','295655','295656','295657','295813','296182','297083','297084','297085','297194','297199','297215','297216','297217','297218','297359','297360','297478','297520','297543','297599','297623','297657','297786','297898','297977','298017','298018','298285','298286','298294','298295','298296','298297','298298','298299','298300','298304','298305','298306','298307','298441','298582','299204','299212','299246','299279','299435','299487','299587','299588','299589','299590','299591','299592','299593','299651','299679','299746','299772','299787','299789','299822','299823','299852','299854','299855','299881','299891','299893','299935','299943','299961','299962','300071','300202','300253','300254','300256','300263','300264','300393','300395','300396','300433','300505','300506','300525','300580','300584','300585','300586','300587','300588','300589','300593','300594','300595','300596','300597','300599','300600','300601','300602','300603','300604','300605','300606','300607','300611','300619','300668','300678','300679','300680','301034','301801','301804','301863','301997','302070','302111','302145','302185','302192','302193','302223','302256','302273','302341','303858','303899','303940') GROUP BY `manuf` ORDER BY `manuf` ASC