Кабели и аксессуары, стр. 4

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','321','158838','166648','166649','166650','166768','167893','201262','215770','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','149745','149746','149747','149748','149749','150910','158444','164984','166455','210596','210597','210598','210599','210600','210601','210602','210603','210604','210605','210606','210607','210608','210609','210610','210611','210612','210613','210614','210615','210616','210617','210618','210619','210620','210621','210622','210623','210624','210625','210626','210627','210628','210629','210630','210631','210632','210633','210634','210635','210636','210637','210638','210639','210640','210641','210642','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','264663','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','141912','141920','142923','143043','143240','143346','143500','144131','144197','144198','147797','148029','148757','148758','148759','148760','148761','148762','148763','148764','148765','148766','148767','150554','150836','151616','152512','152655','152660','153116','153139','154343','154736','154973','155286','155333','155653','155654','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','169919','169920','170122','170156','170229','202599','202600','202991','202992','202993','202994','202995','202996','202997','202998','202999','203000','203001','203002','203003','203004','203005','203006','203007','203008','203009','203010','203011','203012','203013','203014','203015','203016','203017','203018','203019','203020','203021','203022','203023','203024','203025','203026','203027','203028','203029','203030','203031','203032','203033','203034','203035','203036','203037','203038','203039','203040','203041','203042','203043','203044','203045','203046','203047','203048','203049','203050','203051','203052','203053','203054','203055','203056','203057','203058','203059','203060','203061','211477','211478','211479','211480','211481','211482','211483','211484','211485','211486','211487','211488','211489','211490','211491','211492','211493','211494','211495','211496','211497','211498','211499','211500','211501','211502','211503','211504','211505','211506','211507','211508','215420','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','288508','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','142973','148156','161012','163227','166784','167170','201307','202688','202689','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','142980','143101','150297','150298','150299','150300','150301','150302','150303','150304','150421','151470','151471','151472','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','170262','170263','170264','212966','212967','212968','212969','212970','212971','212972','212973','212974','212975','212976','212977','212978','212979','212980','212981','212982','212983','212984','212985','212986','212987','212988','212989','212990','212991','212992','212993','212994','212995','212996','212997','212998','212999','213000','213001','213002','213003','213004','213005','213006','213007','213008','213009','213010','213011','213012','213013','213014','213015','213016','213017','213018','213019','213020','213021','213022','213023','213024','213025','213026','213027','213028','215020','215021','215022','215023','215024','215025','215026','215860','238599','239442','239443','239444','240412','240955','240956','240960','241318','243229','243860','244216','247453','250528','250529','250530','250531','250532','253204','254459','255029','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','98','141924','142731','142732','142981','143172','143682','143683','143684','143685','143779','144044','144052','144053','147885','148411','148413','148603','149509','149510','149511','149512','149513','149514','149515','149516','149517','149518','149519','149520','149521','149522','149523','149524','149525','149526','149527','149528','149529','149530','149531','149532','149533','149534','149535','149536','149537','149538','149539','149540','149541','149542','149543','149544','149545','149546','149547','149548','149549','149550','149551','149552','149553','149554','149555','149556','149557','149558','149559','149560','149561','149562','149563','149564','149565','149566','149567','150602','150799','150800','151286','151287','151288','151289','151290','151291','151292','151841','151938','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','169873','169938','169940','169941','169942','169943','169944','169945','169947','170070','170071','170474','170475','170476','170477','170478','170480','170502','170515','170516','170517','170518','170520','170521','170524','201138','201139','201165','202762','209473','209474','209475','209476','209477','209478','209479','209480','209481','209482','209483','209484','209485','209486','209487','209488','209489','209490','209491','209492','209493','209494','209495','209496','209497','209498','209499','209500','209501','209502','209503','209504','209505','209506','209507','209508','209509','209510','209511','209512','209513','209514','209515','209516','209517','209518','209519','209520','209521','209522','209523','209524','209525','209526','209527','209528','209529','209530','209531','209532','209533','209534','209535','209536','209537','209538','209539','209540','209541','209542','209543','209544','209545','209546','209547','209548','209549','209550','209551','209552','209553','209554','209555','209556','209557','209558','209559','209560','209561','209562','209563','209564','209565','209566','209567','209568','209569','209570','209571','209572','209573','209574','209575','209576','209577','209578','209579','209580','209581','209582','209583','209584','209585','209586','209587','209588','209589','209590','209591','209592','209593','209594','209595','209596','209597','209598','209599','209600','209601','209602','209603','209604','209605','209606','209607','209608','209609','209610','209611','209612','209613','209614','209615','209616','209617','209618','209619','209620','209621','209622','209623','209624','209625','209626','209627','209628','209629','209630','209631','209632','209633','209634','209635','209636','209637','209638','209639','209640','209641','209642','209643','209644','209645','209646','209647','209648','209649','209650','209651','209652','209653','209654','209655','209656','209657','209658','209659','209660','209661','209662','209663','209664','209665','209666','209667','209668','209669','209670','209671','209672','209673','209674','209675','209676','209677','209678','209679','209680','209681','209682','209683','209684','209685','209686','209687','209688','209689','209690','209691','209692','209693','209694','209695','209696','209697','209698','209699','209700','209701','209702','209703','209704','209705','209706','209707','209708','209709','209710','209711','209712','209713','209714','209715','209716','209717','209718','209719','209720','209721','209722','209723','209724','209725','209726','209727','209728','209729','209730','209731','209732','209733','209734','209735','209736','209737','209738','209739','209740','209741','209742','209743','209744','209745','209746','209747','209748','209749','209750','209751','209752','209753','209754','209755','209756','209757','209758','209759','209760','209761','209762','209763','209764','209765','209766','209767','209768','209769','209770','209771','209772','209773','209774','209775','209776','209777','209778','209779','209780','209781','209782','209783','209784','209785','209786','209787','209788','209789','209790','209791','209792','209793','209794','209795','209796','209797','209798','209799','209800','209801','209802','209803','209804','209805','209806','209807','209808','209809','209810','209811','209812','209813','209814','209815','209816','209817','209818','209819','209820','209821','209822','209823','209824','209825','209826','209827','209828','209829','209830','209831','209832','209833','209834','209835','209836','209837','209838','209839','209840','209841','209842','209843','209844','209845','209846','209847','209848','209849','209850','209851','209852','209853','209854','209855','209856','209857','209858','209859','209860','209861','209862','209863','209864','209865','209866','209867','209868','215027','215028','215029','215030','215031','215032','215033','215034','215035','215036','215037','215038','215039','215040','215041','215042','215043','215044','215045','215046','215047','215048','215049','215050','215051','215052','215053','215054','215055','215056','215057','215058','215059','215060','215061','215062','215063','215064','215065','215066','215067','215068','215069','215070','215071','215072','215073','215074','215075','215076','215077','215078','215079','215080','215081','215082','215083','215084','215085','215086','215087','215088','215089','215090','215091','215092','215093','215094','215095','215096','215097','215098','215099','215100','215101','215102','215103','215104','215105','215106','215107','215108','215109','215110','215111','215112','215113','215114','215115','215116','215117','215118','215119','215120','215121','215122','215123','215124','215125','215126','215127','215128','215129','215130','215131','215132','215133','215134','215135','215136','215137','215138','215139','215140','215141','215142','215143','215144','215145','215146','215147','215148','215149','215150','215151','215152','215153','215154','215155','215156','215157','215158','215159','215160','215161','215162','215163','215164','215165','215166','215167','215168','215169','215170','215171','215233','215503','215619','215700','215701','215702','215703','215704','215705','215706','215707','215797','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','279','143671','143672','151113','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','169965','170134','170442','170443','170444','170465','170466','170467','170468','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278','212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','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','141560','141612','142526','142979','143331','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','151349','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157996','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','166981','167687','169164','169165','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','232506','232606','232744','238108','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256334','256335','256336','256337','256338','256798','262446','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','280826','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','13','33','111','182','263','308','309','143653','148058','148061','148848','148849','148850','148851','150283','150284','150285','150286','150287','150288','150289','150290','150291','150352','150354','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','169735','169775','170298','170299','170350','170370','170469','170470','170471','170472','170473','170523','202690','202691','202692','202693','202695','202696','202699','202818','202820','203770','203771','203772','203773','203774','203775','203776','203777','203778','203779','203780','203781','203782','203783','203784','203785','203786','203787','203788','203789','203790','203791','203792','203793','203794','203795','203796','203797','203798','203799','203800','203801','203802','203803','203804','203805','203806','203807','203808','203809','203810','203811','203812','203813','203814','203815','203816','203817','203818','203819','203820','203821','203822','203823','203824','203825','203826','203827','203828','203829','203830','203831','203832','203833','203834','203835','203836','203837','203838','203839','203840','203841','203842','203843','203844','203845','203846','203847','203848','203849','203850','203851','203852','203853','203854','203855','203856','203857','203858','203859','203860','203861','203862','203863','203864','203865','203866','203867','203868','203869','203870','203871','203872','203873','203874','203875','203876','203877','203878','203879','203880','203881','203882','203883','203884','210514','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212911','212912','212913','212914','212915','212916','212917','212918','212919','212920','212921','212922','212923','212924','212925','212926','212927','212928','212929','212930','212931','213356','213358','213359','213360','213361','213363','213364','213365','213366','213367','213368','213369','213370','213371','213372','213373','213374','213375','213376','213377','213378','213379','213380','213381','213382','213383','213384','213385','213386','213387','213388','213389','213390','213391','213392','213393','213394','213395','215172','215173','215174','215175','215176','215177','215178','215179','215180','215181','215182','215183','215184','215185','215186','215187','215188','215189','215190','215191','215192','215193','215194','215195','215196','215197','215198','215199','215355','215356','215357','215358','215359','215360','215361','215502','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','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 ('141560','141920','141924','142731','142732','142923','142973','142980','142981','143043','143101','143172','143240','143346','143500','143653','143671','143672','143682','143683','143684','143685','143779','144044','144052','144053','144131','144197','144198','147797','147885','148029','148058','148061','148156','148411','148413','148603','148757','148758','148759','148760','148761','148762','148763','148764','148765','148766','148767','148848','148849','148850','148851','149509','149510','149511','149512','149513','149514','149515','149516','149517','149518','149519','149520','149521','149522','149523','149524','149525','149526','149527','149528','149529','149530','149531','149532','149533','149534','149535','149536','149537','149538','149539','149540','149541','149542','149543','149544','149545','149546','149547','149548','149549','149550','149551','149552','149553','149554','149555','149556','149557','149558','149559','149560','149561','149562','149563','149564','149565','149566','149567','149745','149746','149747','149748','149749','150283','150284','150285','150286','150287','150288','150289','150290','150291','150297','150298','150299','150300','150301','150302','150303','150304','150343','150344','150345','150346','150347','150348','150349','150350','150352','150354','150421','150554','150602','150799','150800','150836','150846','150910','151113','151251','151286','151287','151288','151289','151290','151291','151292','151470','151471','151472','151616','151841','151938','152512','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','169164','169735','169775','169873','169919','169920','169938','169940','169941','169942','169943','169944','169945','169947','169965','170070','170071','170122','170134','170156','170229','170262','170263','170264','170298','170299','170350','170370','170442','170443','170444','170465','170466','170467','170468','170469','170470','170471','170472','170473','170474','170475','170476','170477','170478','170480','170502','170515','170516','170517','170518','170520','170521','170523','170524','201138','201139','201165','201262','201307','202599','202600','202688','202689','202690','202691','202692','202693','202695','202696','202699','202762','202818','202820','202991','202992','202993','202994','202995','202996','202997','202998','202999','203000','203001','203002','203003','203004','203005','203006','203007','203008','203009','203010','203011','203012','203013','203014','203015','203016','203017','203018','203019','203020','203021','203022','203023','203024','203025','203026','203027','203028','203029','203030','203031','203032','203033','203034','203035','203036','203037','203038','203039','203040','203041','203042','203043','203044','203045','203046','203047','203048','203049','203050','203051','203052','203053','203054','203055','203056','203057','203058','203059','203060','203061','203770','203771','203772','203773','203774','203775','203776','203777','203778','203779','203780','203781','203782','203783','203784','203785','203786','203787','203788','203789','203790','203791','203792','203793','203794','203795','203796','203797','203798','203799','203800','203801','203802','203803','203804','203805','203806','203807','203808','203809','203810','203811','203812','203813','203814','203815','203816','203817','203818','203819','203820','203821','203822','203823','203824','203825','203826','203827','203828','203829','203830','203831','203832','203833','203834','203835','203836','203837','203838','203839','203840','203841','203842','203843','203844','203845','203846','203847','203848','203849','203850','203851','203852','203853','203854','203855','203856','203857','203858','203859','203860','203861','203862','203863','203864','203865','203866','203867','203868','203869','203870','203871','203872','203873','203874','203875','203876','203877','203878','203879','203880','203881','203882','203883','203884','209473','209474','209475','209476','209477','209478','209479','209480','209481','209482','209483','209484','209485','209486','209487','209488','209489','209490','209491','209492','209493','209494','209495','209496','209497','209498','209499','209500','209501','209502','209503','209504','209505','209506','209507','209508','209509','209510','209511','209512','209513','209514','209515','209516','209517','209518','209519','209520','209521','209522','209523','209524','209525','209526','209527','209528','209529','209530','209531','209532','209533','209534','209535','209536','209537','209538','209539','209540','209541','209542','209543','209544','209545','209546','209547','209548','209549','209550','209551','209552','209553','209554','209555','209556','209557','209558','209559','209560','209561','209562','209563','209564','209565','209566','209567','209568','209569','209570','209571','209572','209573','209574','209575','209576','209577','209578','209579','209580','209581','209582','209583','209584','209585','209586','209587','209588','209589','209590','209591','209592','209593','209594','209595','209596','209597','209598','209599','209600','209601','209602','209603','209604','209605','209606','209607','209608','209609','209610','209611','209612','209613','209614','209615','209616','209617','209618','209619','209620','209621','209622','209623','209624','209625','209626','209627','209628','209629','209630','209631','209632','209633','209634','209635','209636','209637','209638','209639','209640','209641','209642','209643','209644','209645','209646','209647','209648','209649','209650','209651','209652','209653','209654','209655','209656','209657','209658','209659','209660','209661','209662','209663','209664','209665','209666','209667','209668','209669','209670','209671','209672','209673','209674','209675','209676','209677','209678','209679','209680','209681','209682','209683','209684','209685','209686','209687','209688','209689','209690','209691','209692','209693','209694','209695','209696','209697','209698','209699','209700','209701','209702','209703','209704','209705','209706','209707','209708','209709','209710','209711','209712','209713','209714','209715','209716','209717','209718','209719','209720','209721','209722','209723','209724','209725','209726','209727','209728','209729','209730','209731','209732','209733','209734','209735','209736','209737','209738','209739','209740','209741','209742','209743','209744','209745','209746','209747','209748','209749','209750','209751','209752','209753','209754','209755','209756','209757','209758','209759','209760','209761','209762','209763','209764','209765','209766','209767','209768','209769','209770','209771','209772','209773','209774','209775','209776','209777','209778','209779','209780','209781','209782','209783','209784','209785','209786','209787','209788','209789','209790','209791','209792','209793','209794','209795','209796','209797','209798','209799','209800','209801','209802','209803','209804','209805','209806','209807','209808','209809','209810','209811','209812','209813','209814','209815','209816','209817','209818','209819','209820','209821','209822','209823','209824','209825','209826','209827','209828','209829','209830','209831','209832','209833','209834','209835','209836','209837','209838','209839','209840','209841','209842','209843','209844','209845','209846','209847','209848','209849','209850','209851','209852','209853','209854','209855','209856','209857','209858','209859','209860','209861','209862','209863','209864','209865','209866','209867','209868','210514','210596','210597','210598','210599','210600','210601','210602','210603','210604','210605','210606','210607','210608','210609','210610','210611','210612','210613','210614','210615','210616','210617','210618','210619','210620','210621','210622','210623','210624','210625','210626','210627','210628','210629','210630','210631','210632','210633','210634','210635','210636','210637','210638','210639','210640','210641','210642','211477','211478','211479','211480','211481','211482','211483','211484','211485','211486','211487','211488','211489','211490','211491','211492','211493','211494','211495','211496','211497','211498','211499','211500','211501','211502','211503','211504','211505','211506','211507','211508','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278','212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','212911','212912','212913','212914','212915','212916','212917','212918','212919','212920','212921','212922','212923','212924','212925','212926','212927','212928','212929','212930','212931','212966','212967','212968','212969','212970','212971','212972','212973','212974','212975','212976','212977','212978','212979','212980','212981','212982','212983','212984','212985','212986','212987','212988','212989','212990','212991','212992','212993','212994','212995','212996','212997','212998','212999','213000','213001','213002','213003','213004','213005','213006','213007','213008','213009','213010','213011','213012','213013','213014','213015','213016','213017','213018','213019','213020','213021','213022','213023','213024','213025','213026','213027','213028','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','213356','213358','213359','213360','213361','213363','213364','213365','213366','213367','213368','213369','213370','213371','213372','213373','213374','213375','213376','213377','213378','213379','213380','213381','213382','213383','213384','213385','213386','213387','213388','213389','213390','213391','213392','213393','213394','213395','215020','215021','215022','215023','215024','215025','215026','215027','215028','215029','215030','215031','215032','215033','215034','215035','215036','215037','215038','215039','215040','215041','215042','215043','215044','215045','215046','215047','215048','215049','215050','215051','215052','215053','215054','215055','215056','215057','215058','215059','215060','215061','215062','215063','215064','215065','215066','215067','215068','215069','215070','215071','215072','215073','215074','215075','215076','215077','215078','215079','215080','215081','215082','215083','215084','215085','215086','215087','215088','215089','215090','215091','215092','215093','215094','215095','215096','215097','215098','215099','215100','215101','215102','215103','215104','215105','215106','215107','215108','215109','215110','215111','215112','215113','215114','215115','215116','215117','215118','215119','215120','215121','215122','215123','215124','215125','215126','215127','215128','215129','215130','215131','215132','215133','215134','215135','215136','215137','215138','215139','215140','215141','215142','215143','215144','215145','215146','215147','215148','215149','215150','215151','215152','215153','215154','215155','215156','215157','215158','215159','215160','215161','215162','215163','215164','215165','215166','215167','215168','215169','215170','215171','215172','215173','215174','215175','215176','215177','215178','215179','215180','215181','215182','215183','215184','215185','215186','215187','215188','215189','215190','215191','215192','215193','215194','215195','215196','215197','215198','215199','215208','215233','215355','215356','215357','215358','215359','215360','215361','215390','215420','215502','215503','215619','215700','215701','215702','215703','215704','215705','215706','215707','215770','215797','215860','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') 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','321','158838','166648','166649','166650','166768','167893','201262','215770','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','149745','149746','149747','149748','149749','150910','158444','164984','166455','210596','210597','210598','210599','210600','210601','210602','210603','210604','210605','210606','210607','210608','210609','210610','210611','210612','210613','210614','210615','210616','210617','210618','210619','210620','210621','210622','210623','210624','210625','210626','210627','210628','210629','210630','210631','210632','210633','210634','210635','210636','210637','210638','210639','210640','210641','210642','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','264663','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','141912','141920','142923','143043','143240','143346','143500','144131','144197','144198','147797','148029','148757','148758','148759','148760','148761','148762','148763','148764','148765','148766','148767','150554','150836','151616','152512','152655','152660','153116','153139','154343','154736','154973','155286','155333','155653','155654','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','169919','169920','170122','170156','170229','202599','202600','202991','202992','202993','202994','202995','202996','202997','202998','202999','203000','203001','203002','203003','203004','203005','203006','203007','203008','203009','203010','203011','203012','203013','203014','203015','203016','203017','203018','203019','203020','203021','203022','203023','203024','203025','203026','203027','203028','203029','203030','203031','203032','203033','203034','203035','203036','203037','203038','203039','203040','203041','203042','203043','203044','203045','203046','203047','203048','203049','203050','203051','203052','203053','203054','203055','203056','203057','203058','203059','203060','203061','211477','211478','211479','211480','211481','211482','211483','211484','211485','211486','211487','211488','211489','211490','211491','211492','211493','211494','211495','211496','211497','211498','211499','211500','211501','211502','211503','211504','211505','211506','211507','211508','215420','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','288508','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','142973','148156','161012','163227','166784','167170','201307','202688','202689','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','142980','143101','150297','150298','150299','150300','150301','150302','150303','150304','150421','151470','151471','151472','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','170262','170263','170264','212966','212967','212968','212969','212970','212971','212972','212973','212974','212975','212976','212977','212978','212979','212980','212981','212982','212983','212984','212985','212986','212987','212988','212989','212990','212991','212992','212993','212994','212995','212996','212997','212998','212999','213000','213001','213002','213003','213004','213005','213006','213007','213008','213009','213010','213011','213012','213013','213014','213015','213016','213017','213018','213019','213020','213021','213022','213023','213024','213025','213026','213027','213028','215020','215021','215022','215023','215024','215025','215026','215860','238599','239442','239443','239444','240412','240955','240956','240960','241318','243229','243860','244216','247453','250528','250529','250530','250531','250532','253204','254459','255029','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','98','141924','142731','142732','142981','143172','143682','143683','143684','143685','143779','144044','144052','144053','147885','148411','148413','148603','149509','149510','149511','149512','149513','149514','149515','149516','149517','149518','149519','149520','149521','149522','149523','149524','149525','149526','149527','149528','149529','149530','149531','149532','149533','149534','149535','149536','149537','149538','149539','149540','149541','149542','149543','149544','149545','149546','149547','149548','149549','149550','149551','149552','149553','149554','149555','149556','149557','149558','149559','149560','149561','149562','149563','149564','149565','149566','149567','150602','150799','150800','151286','151287','151288','151289','151290','151291','151292','151841','151938','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','169873','169938','169940','169941','169942','169943','169944','169945','169947','170070','170071','170474','170475','170476','170477','170478','170480','170502','170515','170516','170517','170518','170520','170521','170524','201138','201139','201165','202762','209473','209474','209475','209476','209477','209478','209479','209480','209481','209482','209483','209484','209485','209486','209487','209488','209489','209490','209491','209492','209493','209494','209495','209496','209497','209498','209499','209500','209501','209502','209503','209504','209505','209506','209507','209508','209509','209510','209511','209512','209513','209514','209515','209516','209517','209518','209519','209520','209521','209522','209523','209524','209525','209526','209527','209528','209529','209530','209531','209532','209533','209534','209535','209536','209537','209538','209539','209540','209541','209542','209543','209544','209545','209546','209547','209548','209549','209550','209551','209552','209553','209554','209555','209556','209557','209558','209559','209560','209561','209562','209563','209564','209565','209566','209567','209568','209569','209570','209571','209572','209573','209574','209575','209576','209577','209578','209579','209580','209581','209582','209583','209584','209585','209586','209587','209588','209589','209590','209591','209592','209593','209594','209595','209596','209597','209598','209599','209600','209601','209602','209603','209604','209605','209606','209607','209608','209609','209610','209611','209612','209613','209614','209615','209616','209617','209618','209619','209620','209621','209622','209623','209624','209625','209626','209627','209628','209629','209630','209631','209632','209633','209634','209635','209636','209637','209638','209639','209640','209641','209642','209643','209644','209645','209646','209647','209648','209649','209650','209651','209652','209653','209654','209655','209656','209657','209658','209659','209660','209661','209662','209663','209664','209665','209666','209667','209668','209669','209670','209671','209672','209673','209674','209675','209676','209677','209678','209679','209680','209681','209682','209683','209684','209685','209686','209687','209688','209689','209690','209691','209692','209693','209694','209695','209696','209697','209698','209699','209700','209701','209702','209703','209704','209705','209706','209707','209708','209709','209710','209711','209712','209713','209714','209715','209716','209717','209718','209719','209720','209721','209722','209723','209724','209725','209726','209727','209728','209729','209730','209731','209732','209733','209734','209735','209736','209737','209738','209739','209740','209741','209742','209743','209744','209745','209746','209747','209748','209749','209750','209751','209752','209753','209754','209755','209756','209757','209758','209759','209760','209761','209762','209763','209764','209765','209766','209767','209768','209769','209770','209771','209772','209773','209774','209775','209776','209777','209778','209779','209780','209781','209782','209783','209784','209785','209786','209787','209788','209789','209790','209791','209792','209793','209794','209795','209796','209797','209798','209799','209800','209801','209802','209803','209804','209805','209806','209807','209808','209809','209810','209811','209812','209813','209814','209815','209816','209817','209818','209819','209820','209821','209822','209823','209824','209825','209826','209827','209828','209829','209830','209831','209832','209833','209834','209835','209836','209837','209838','209839','209840','209841','209842','209843','209844','209845','209846','209847','209848','209849','209850','209851','209852','209853','209854','209855','209856','209857','209858','209859','209860','209861','209862','209863','209864','209865','209866','209867','209868','215027','215028','215029','215030','215031','215032','215033','215034','215035','215036','215037','215038','215039','215040','215041','215042','215043','215044','215045','215046','215047','215048','215049','215050','215051','215052','215053','215054','215055','215056','215057','215058','215059','215060','215061','215062','215063','215064','215065','215066','215067','215068','215069','215070','215071','215072','215073','215074','215075','215076','215077','215078','215079','215080','215081','215082','215083','215084','215085','215086','215087','215088','215089','215090','215091','215092','215093','215094','215095','215096','215097','215098','215099','215100','215101','215102','215103','215104','215105','215106','215107','215108','215109','215110','215111','215112','215113','215114','215115','215116','215117','215118','215119','215120','215121','215122','215123','215124','215125','215126','215127','215128','215129','215130','215131','215132','215133','215134','215135','215136','215137','215138','215139','215140','215141','215142','215143','215144','215145','215146','215147','215148','215149','215150','215151','215152','215153','215154','215155','215156','215157','215158','215159','215160','215161','215162','215163','215164','215165','215166','215167','215168','215169','215170','215171','215233','215503','215619','215700','215701','215702','215703','215704','215705','215706','215707','215797','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','279','143671','143672','151113','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','169965','170134','170442','170443','170444','170465','170466','170467','170468','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278','212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','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','141560','141612','142526','142979','143331','150343','150344','150345','150346','150347','150348','150349','150350','150846','151251','151349','157509','157510','157985','157989','157990','157991','157992','157993','157994','157995','157996','157997','157998','157999','158215','158248','158380','158613','158762','159003','160559','161728','162285','164548','166112','166524','166981','167687','169164','169165','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','215208','215390','232506','232606','232744','238108','238812','238813','238814','238815','238837','239085','239216','239231','239259','240068','240435','247446','250589','251359','253266','253874','253906','254544','254731','256006','256007','256334','256335','256336','256337','256338','256798','262446','262512','262513','262514','262515','263467','264440','265062','266621','266624','268357','268454','268625','273933','273955','274082','274307','274749','275067','277938','278342','280826','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','13','33','111','182','263','308','309','143653','148058','148061','148848','148849','148850','148851','150283','150284','150285','150286','150287','150288','150289','150290','150291','150352','150354','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','169735','169775','170298','170299','170350','170370','170469','170470','170471','170472','170473','170523','202690','202691','202692','202693','202695','202696','202699','202818','202820','203770','203771','203772','203773','203774','203775','203776','203777','203778','203779','203780','203781','203782','203783','203784','203785','203786','203787','203788','203789','203790','203791','203792','203793','203794','203795','203796','203797','203798','203799','203800','203801','203802','203803','203804','203805','203806','203807','203808','203809','203810','203811','203812','203813','203814','203815','203816','203817','203818','203819','203820','203821','203822','203823','203824','203825','203826','203827','203828','203829','203830','203831','203832','203833','203834','203835','203836','203837','203838','203839','203840','203841','203842','203843','203844','203845','203846','203847','203848','203849','203850','203851','203852','203853','203854','203855','203856','203857','203858','203859','203860','203861','203862','203863','203864','203865','203866','203867','203868','203869','203870','203871','203872','203873','203874','203875','203876','203877','203878','203879','203880','203881','203882','203883','203884','210514','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212911','212912','212913','212914','212915','212916','212917','212918','212919','212920','212921','212922','212923','212924','212925','212926','212927','212928','212929','212930','212931','213356','213358','213359','213360','213361','213363','213364','213365','213366','213367','213368','213369','213370','213371','213372','213373','213374','213375','213376','213377','213378','213379','213380','213381','213382','213383','213384','213385','213386','213387','213388','213389','213390','213391','213392','213393','213394','213395','215172','215173','215174','215175','215176','215177','215178','215179','215180','215181','215182','215183','215184','215185','215186','215187','215188','215189','215190','215191','215192','215193','215194','215195','215196','215197','215198','215199','215355','215356','215357','215358','215359','215360','215361','215502','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','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 ('141560','141920','141924','142731','142732','142923','142973','142980','142981','143043','143101','143172','143240','143346','143500','143653','143671','143672','143682','143683','143684','143685','143779','144044','144052','144053','144131','144197','144198','147797','147885','148029','148058','148061','148156','148411','148413','148603','148757','148758','148759','148760','148761','148762','148763','148764','148765','148766','148767','148848','148849','148850','148851','149509','149510','149511','149512','149513','149514','149515','149516','149517','149518','149519','149520','149521','149522','149523','149524','149525','149526','149527','149528','149529','149530','149531','149532','149533','149534','149535','149536','149537','149538','149539','149540','149541','149542','149543','149544','149545','149546','149547','149548','149549','149550','149551','149552','149553','149554','149555','149556','149557','149558','149559','149560','149561','149562','149563','149564','149565','149566','149567','149745','149746','149747','149748','149749','150283','150284','150285','150286','150287','150288','150289','150290','150291','150297','150298','150299','150300','150301','150302','150303','150304','150343','150344','150345','150346','150347','150348','150349','150350','150352','150354','150421','150554','150602','150799','150800','150836','150846','150910','151113','151251','151286','151287','151288','151289','151290','151291','151292','151470','151471','151472','151616','151841','151938','152512','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','169164','169735','169775','169873','169919','169920','169938','169940','169941','169942','169943','169944','169945','169947','169965','170070','170071','170122','170134','170156','170229','170262','170263','170264','170298','170299','170350','170370','170442','170443','170444','170465','170466','170467','170468','170469','170470','170471','170472','170473','170474','170475','170476','170477','170478','170480','170502','170515','170516','170517','170518','170520','170521','170523','170524','201138','201139','201165','201262','201307','202599','202600','202688','202689','202690','202691','202692','202693','202695','202696','202699','202762','202818','202820','202991','202992','202993','202994','202995','202996','202997','202998','202999','203000','203001','203002','203003','203004','203005','203006','203007','203008','203009','203010','203011','203012','203013','203014','203015','203016','203017','203018','203019','203020','203021','203022','203023','203024','203025','203026','203027','203028','203029','203030','203031','203032','203033','203034','203035','203036','203037','203038','203039','203040','203041','203042','203043','203044','203045','203046','203047','203048','203049','203050','203051','203052','203053','203054','203055','203056','203057','203058','203059','203060','203061','203770','203771','203772','203773','203774','203775','203776','203777','203778','203779','203780','203781','203782','203783','203784','203785','203786','203787','203788','203789','203790','203791','203792','203793','203794','203795','203796','203797','203798','203799','203800','203801','203802','203803','203804','203805','203806','203807','203808','203809','203810','203811','203812','203813','203814','203815','203816','203817','203818','203819','203820','203821','203822','203823','203824','203825','203826','203827','203828','203829','203830','203831','203832','203833','203834','203835','203836','203837','203838','203839','203840','203841','203842','203843','203844','203845','203846','203847','203848','203849','203850','203851','203852','203853','203854','203855','203856','203857','203858','203859','203860','203861','203862','203863','203864','203865','203866','203867','203868','203869','203870','203871','203872','203873','203874','203875','203876','203877','203878','203879','203880','203881','203882','203883','203884','209473','209474','209475','209476','209477','209478','209479','209480','209481','209482','209483','209484','209485','209486','209487','209488','209489','209490','209491','209492','209493','209494','209495','209496','209497','209498','209499','209500','209501','209502','209503','209504','209505','209506','209507','209508','209509','209510','209511','209512','209513','209514','209515','209516','209517','209518','209519','209520','209521','209522','209523','209524','209525','209526','209527','209528','209529','209530','209531','209532','209533','209534','209535','209536','209537','209538','209539','209540','209541','209542','209543','209544','209545','209546','209547','209548','209549','209550','209551','209552','209553','209554','209555','209556','209557','209558','209559','209560','209561','209562','209563','209564','209565','209566','209567','209568','209569','209570','209571','209572','209573','209574','209575','209576','209577','209578','209579','209580','209581','209582','209583','209584','209585','209586','209587','209588','209589','209590','209591','209592','209593','209594','209595','209596','209597','209598','209599','209600','209601','209602','209603','209604','209605','209606','209607','209608','209609','209610','209611','209612','209613','209614','209615','209616','209617','209618','209619','209620','209621','209622','209623','209624','209625','209626','209627','209628','209629','209630','209631','209632','209633','209634','209635','209636','209637','209638','209639','209640','209641','209642','209643','209644','209645','209646','209647','209648','209649','209650','209651','209652','209653','209654','209655','209656','209657','209658','209659','209660','209661','209662','209663','209664','209665','209666','209667','209668','209669','209670','209671','209672','209673','209674','209675','209676','209677','209678','209679','209680','209681','209682','209683','209684','209685','209686','209687','209688','209689','209690','209691','209692','209693','209694','209695','209696','209697','209698','209699','209700','209701','209702','209703','209704','209705','209706','209707','209708','209709','209710','209711','209712','209713','209714','209715','209716','209717','209718','209719','209720','209721','209722','209723','209724','209725','209726','209727','209728','209729','209730','209731','209732','209733','209734','209735','209736','209737','209738','209739','209740','209741','209742','209743','209744','209745','209746','209747','209748','209749','209750','209751','209752','209753','209754','209755','209756','209757','209758','209759','209760','209761','209762','209763','209764','209765','209766','209767','209768','209769','209770','209771','209772','209773','209774','209775','209776','209777','209778','209779','209780','209781','209782','209783','209784','209785','209786','209787','209788','209789','209790','209791','209792','209793','209794','209795','209796','209797','209798','209799','209800','209801','209802','209803','209804','209805','209806','209807','209808','209809','209810','209811','209812','209813','209814','209815','209816','209817','209818','209819','209820','209821','209822','209823','209824','209825','209826','209827','209828','209829','209830','209831','209832','209833','209834','209835','209836','209837','209838','209839','209840','209841','209842','209843','209844','209845','209846','209847','209848','209849','209850','209851','209852','209853','209854','209855','209856','209857','209858','209859','209860','209861','209862','209863','209864','209865','209866','209867','209868','210514','210596','210597','210598','210599','210600','210601','210602','210603','210604','210605','210606','210607','210608','210609','210610','210611','210612','210613','210614','210615','210616','210617','210618','210619','210620','210621','210622','210623','210624','210625','210626','210627','210628','210629','210630','210631','210632','210633','210634','210635','210636','210637','210638','210639','210640','210641','210642','211477','211478','211479','211480','211481','211482','211483','211484','211485','211486','211487','211488','211489','211490','211491','211492','211493','211494','211495','211496','211497','211498','211499','211500','211501','211502','211503','211504','211505','211506','211507','211508','212199','212200','212201','212202','212203','212204','212205','212206','212207','212208','212209','212210','212211','212212','212241','212242','212243','212244','212245','212246','212247','212248','212249','212250','212251','212252','212253','212254','212255','212256','212257','212258','212259','212260','212261','212262','212263','212264','212265','212266','212267','212268','212269','212270','212271','212272','212273','212274','212275','212276','212277','212278','212279','212280','212281','212282','212283','212284','212285','212286','212287','212288','212289','212911','212912','212913','212914','212915','212916','212917','212918','212919','212920','212921','212922','212923','212924','212925','212926','212927','212928','212929','212930','212931','212966','212967','212968','212969','212970','212971','212972','212973','212974','212975','212976','212977','212978','212979','212980','212981','212982','212983','212984','212985','212986','212987','212988','212989','212990','212991','212992','212993','212994','212995','212996','212997','212998','212999','213000','213001','213002','213003','213004','213005','213006','213007','213008','213009','213010','213011','213012','213013','213014','213015','213016','213017','213018','213019','213020','213021','213022','213023','213024','213025','213026','213027','213028','213278','213279','213280','213281','213282','213283','213284','213285','213286','213287','213288','213289','213290','213291','213292','213293','213294','213295','213296','213297','213298','213299','213300','213301','213302','213303','213304','213305','213306','213307','213308','213309','213310','213311','213312','213313','213314','213315','213316','213317','213318','213319','213320','213321','213322','213323','213324','213325','213326','213327','213328','213329','213330','213331','213332','213333','213334','213335','213336','213337','213338','213339','213340','213341','213342','213343','213344','213345','213346','213347','213348','213349','213350','213351','213352','213353','213354','213355','213356','213358','213359','213360','213361','213363','213364','213365','213366','213367','213368','213369','213370','213371','213372','213373','213374','213375','213376','213377','213378','213379','213380','213381','213382','213383','213384','213385','213386','213387','213388','213389','213390','213391','213392','213393','213394','213395','215020','215021','215022','215023','215024','215025','215026','215027','215028','215029','215030','215031','215032','215033','215034','215035','215036','215037','215038','215039','215040','215041','215042','215043','215044','215045','215046','215047','215048','215049','215050','215051','215052','215053','215054','215055','215056','215057','215058','215059','215060','215061','215062','215063','215064','215065','215066','215067','215068','215069','215070','215071','215072','215073','215074','215075','215076','215077','215078','215079','215080','215081','215082','215083','215084','215085','215086','215087','215088','215089','215090','215091','215092','215093','215094','215095','215096','215097','215098','215099','215100','215101','215102','215103','215104','215105','215106','215107','215108','215109','215110','215111','215112','215113','215114','215115','215116','215117','215118','215119','215120','215121','215122','215123','215124','215125','215126','215127','215128','215129','215130','215131','215132','215133','215134','215135','215136','215137','215138','215139','215140','215141','215142','215143','215144','215145','215146','215147','215148','215149','215150','215151','215152','215153','215154','215155','215156','215157','215158','215159','215160','215161','215162','215163','215164','215165','215166','215167','215168','215169','215170','215171','215172','215173','215174','215175','215176','215177','215178','215179','215180','215181','215182','215183','215184','215185','215186','215187','215188','215189','215190','215191','215192','215193','215194','215195','215196','215197','215198','215199','215208','215233','215355','215356','215357','215358','215359','215360','215361','215390','215420','215502','215503','215619','215700','215701','215702','215703','215704','215705','215706','215707','215770','215797','215860','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') GROUP BY `manuf` ORDER BY `manuf` ASC