childsstroke: parent
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 ('31','38','58','147','165','170','175','192','244','265','274','291','323','324','157503','158217','158629','159527','159528','159529','159912','160304','161107','163831','163929','164113','165080','165914','166938','168398','170597','215273','238445','239106','240137','240244','240465','240504','240507','240947','241061','241538','241692','242071','242813','242814','243679','243680','244352','245103','246170','246729','246759','247186','248022','248140','248784','248849','248850','248851','248852','249116','249259','250611','250849','251950','254883','254896','254897','254898','254899','263681','265064','265523','266038','266040','266041','266757','267227','267353','267412','269038','269586','273361','274451','274452','274453','274454','274455','274456','274510','274511','275353','276564','277291','277980','277981','277982','277983','277984','277985','278815','279267','279268','281768','282174','282366','282839','283065','283110','283341','283345','283549','284843','285054','285141','285223','286281','286603','287197','287198','289276','292215','292386','295338','297196','299428','299877','300031','300926','300927','304266','143239','147976','150670','151638','158186','158497','158829','158830','158831','159009','159010','159296','159481','159632','160839','161102','161103','161421','161768','161897','162257','163544','163718','163815','164684','164818','165218','165529','167273','167274','167433','167434','167445','167699','168267','168268','215542','216001','216002','232648','232694','238140','238267','240004','240573','240574','240575','241395','243013','243419','243601','244473','244548','244750','244862','245792','246395','246668','246669','246670','246671','246672','246673','246674','246681','246715','246947','247245','247565','247753','248295','248327','248403','248404','248405','248406','248652','248659','250044','250796','250918','251510','251717','253855','255277','262313','264351','264649','264882','265080','265081','265335','265413','265414','265658','265837','265838','265845','265850','265851','265867','266078','266178','266354','266396','266566','267528','268052','268127','268501','268503','269483','273503','273890','273915','273949','274515','274649','274650','274814','274861','274862','275485','275762','276598','276810','277068','277265','277266','277304','277463','278191','278734','278743','278928','279073','279262','279296','279690','280709','282170','283606','283733','285914','286113','286127','287799','287800','287801','287802','287803','287804','287805','287806','287807','287808','287809','287810','287811','287812','287813','287814','287815','287816','287817','287818','287819','287820','287821','287822','287823','287824','287825','287826','287827','287828','287829','287830','287831','287832','287833','287834','287835','287836','287837','287838','287839','287840','287841','287842','287843','287844','287845','287846','287847','287848','287849','287850','287851','287852','287853','287854','287855','287856','287857','287858','287859','287860','287861','287862','287863','287864','287865','287866','287867','287868','287869','287870','287871','287872','287873','287874','287875','287876','287877','287878','287879','287880','287881','287882','287883','287884','287885','287886','287887','287888','287889','287890','287891','287892','287893','287894','287895','287896','287897','287898','287899','287900','287901','287902','287903','287904','287905','287906','287907','287908','287909','287910','287911','287912','287913','287914','287915','287916','287917','287918','287919','287920','287921','287922','287923','287924','287925','287926','287927','287928','287929','287930','287931','287932','287933','287934','287935','287936','287937','287938','287939','287940','287941','287942','287943','287944','287945','287946','287947','287948','287949','287950','287951','287952','287953','287954','287955','287956','287957','287958','287959','287960','287961','287962','287963','287964','287965','287966','287967','288293','288355','289261','291885','292735','292736','292737','292738','292739','294267','297590','298242','298334','298453','299906','300610','302107','302350','302352','303804','141891','142851','143274','143931','147224','148164','148165','148611','149762','149763','149764','149765','149766','149767','149768','149769','149770','149771','149772','149773','149774','149775','149776','149777','149778','149779','151036','151639','153107','153891','154322','154425','154772','154789','155060','155061','155265','155266','155267','155268','155269','155270','156284','156285','156286','157265','158771','159424','159450','159705','159833','159834','159838','159839','159840','159841','160851','160894','160895','161042','161162','161438','161797','162149','163103','163108','163109','163110','163111','163112','163113','163661','163725','164263','165005','165448','166510','167128','167884','167926','168064','168116','168340','170285','210775','210776','210777','210778','210779','210780','210781','210782','210783','210784','210785','210786','210787','210788','210789','210790','210791','210792','210793','210794','210795','210796','210797','210798','210799','210800','210801','210802','210803','210804','210805','210806','210807','210808','210809','210810','210811','210812','210813','210814','210815','210816','210817','210818','210819','210820','210821','210822','210823','210824','210825','210826','210827','210828','210829','210830','210831','210832','210833','210834','210835','210836','210837','210838','210839','210840','210841','210842','210843','210844','210845','210846','232561','238556','238662','238715','239207','239971','240963','240968','241279','241724','242508','243145','243463','245307','246198','246701','247000','250149','250620','250684','252077','253768','254454','255003','262188','263611','263612','264455','265709','265874','266268','268696','269149','269152','269153','269346','269459','274829','275399','275758','276434','276697','279194','279733','280283','281194','281400','281402','281403','281408','281628','282545','284149','286444','286626','287173','288232','288259','288480','288625','291869','292846','295995','297591','297957','298171','298373','300578','301806','301895','302271','303904','142230','150464','150772','150841','151637','151642','158445','160180','161886','163793','163895','164733','166561','167106','167833','215795','215896','216091','232421','239222','240395','240563','240943','240944','241516','241672','242159','242160','242161','242162','242163','242515','243426','244049','244050','245228','246567','246731','246732','246824','248360','248718','248768','252047','252110','253483','266118','266429','266460','267108','267757','273787','273937','274492','275614','277808','278475','278506','278834','279377','279694','280531','281396','282908','285984','286939','287202','288101','288109','291877','294228','296223','298528','299192','302291','143691','143692','144287','149707','149708','150150','150151','151042','151043','151456','151635','151850','151972','151993','153640','153644','155477','155822','156823','156824','156825','156826','156827','156828','156829','156830','156831','157709','158015','158016','158340','158377','158657','158660','158759','159014','159095','159698','159750','159869','160036','160117','160236','160237','160820','161321','161387','161885','162366','162448','162766','162904','162905','163042','163047','163086','163324','163619','163621','163751','163800','163803','164153','164154','164176','164177','164591','164981','165029','165188','165189','165198','165199','165200','165201','165202','165203','165204','165205','165538','165815','165849','166319','166322','166445','166546','166597','166921','167359','167531','167627','167842','167991','168218','170024','170077','170078','170205','170413','170414','170415','170530','170531','170532','170533','170534','170535','170536','170537','170538','170539','170540','170541','170542','170543','185916','210493','210496','210497','210498','210499','210500','210501','210502','210503','210970','210982','210983','211008','211820','211821','211822','211823','211824','211825','211826','211827','211828','211829','211830','211831','211832','211833','211834','211835','211836','211837','211838','211839','211840','211841','211842','211843','211844','211845','211846','211847','211848','211849','211850','211851','211852','211853','211854','211855','211856','211857','211858','211859','211860','211861','211862','211863','211864','211865','211866','211867','211868','211869','211870','211871','211872','211873','211874','211875','211876','215216','215250','215415','215720','216046','216093','219761','232595','232641','232780','238590','239156','239248','239316','239317','240097','240098','240282','240285','240288','240313','240348','240349','240354','240356','240433','240445','240453','240521','240815','240816','240817','240819','240830','240833','240835','240837','240838','241310','241338','241339','241468','241469','241529','241722','241764','241978','242230','242382','242429','242516','242726','242785','242820','243287','243539','243835','243836','244210','244288','244291','245203','245384','245489','245847','246021','246257','246467','246725','246726','246727','246728','246914','246969','247358','247587','247913','248090','248210','248331','248441','248485','248620','248736','248791','248866','249149','249196','249344','249390','249537','249666','249714','249822','249850','249895','250509','250890','250903','251080','251154','251267','251498','251553','251931','251979','252153','252240','253633','253739','253852','253853','254213','254380','254382','254436','254439','254616','254646','254821','254945','254970','255106','255117','255118','255181','255361','255471','255504','255596','255942','255943','255944','255945','255946','255947','256097','256098','256104','256196','256616','256658','256724','256876','257060','257061','257177','261710','261711','261756','261773','262108','262345','262346','262939','263585','264350','264359','264363','264491','264910','264951','264962','264964','265060','265099','265227','265366','265404','265540','265695','265784','265970','266003','266090','266278','266415','266612','266825','266903','266974','266982','267054','267459','267480','267868','268011','268012','268013','268014','268015','268016','268017','268018','268019','268020','268021','268022','268023','268024','268025','268026','268027','268029','268030','268031','268032','268033','268034','268035','268036','268081','268112','268223','268347','268502','268506','268783','268784','268859','268861','269017','269032','269242','269347','269371','269462','269463','269464','269465','269466','273306','273307','273403','273404','273560','273673','273676','273677','273798','273961','274387','274388','274389','274390','274391','274392','274393','274394','274395','274437','274438','274444','274445','274783','275003','275135','275396','275625','275735','276135','276136','276138','276139','276140','276141','276246','276499','276529','276594','276668','276669','276763','276769','277338','277339','277342','277422','277511','277720','277721','277722','277723','277724','277725','277726','277727','277729','277730','277731','277798','277967','278223','278369','278370','278464','278519','278615','278693','278760','278768','278771','279455','279484','279666','279724','279725','279732','279814','280350','280366','280367','280442','280443','280589','280765','280766','280767','280768','280819','280862','280881','280990','281072','281178','281223','281388','281584','281627','282030','282112','282177','282444','282481','282768','282811','283604','284134','284184','284280','284283','284441','284579','284907','285073','285076','285121','285140','285183','285185','285333','285375','285376','285386','285431','285531','285725','285829','285830','285898','285968','286124','286373','286647','287504','287505','287993','288004','288097','288099','288127','288205','288307','288493','288869','288983','291825','291989','291990','291991','291992','291995','291999','292001','292003','292004','292006','292224','292498','292503','292716','292803','293201','293387','293525','293544','294072','294221','294237','294261','294282','294289','294494','294496','294601','294606','294801','295433','295457','295494','295512','295514','295517','295622','295751','295836','296237','296242','297454','297455','297602','297630','297794','297979','298029','298057','298137','298138','298139','298158','298522','298579','298590','298595','298601','299176','299373','299403','299448','299919','300072','300209','300328','300639','301048','301067','301881','301986','302146','302224','302292','302293','302295','303926','303927','303945','146701','148060','150159','150160','201181','201182','201183','201184','201185','201190','201191','201192','202694','211974','211975','211976','211977','211978','211979','211980','211981','211982','211983','211984','211985','232404','269049','144205','151059','151060','153923','157408','160730','167148','167149','167150','167151','167152','167212','170598','201141','201144','202769','202841','215847','239992','244263','246022','246374','247259','247451','249234','249762','250501','250502','250503','250504','250505','262857','265095','266036','266096','273852','275137','276066','276653','277293','280378','283480','284162','284625','286947','291701','297551','299680','299682','301047','144975','144976','144977','144992','146695','148991','148992','148993','148994','148995','148996','148997','148998','148999','149000','149001','155858','155859','157908','158148','158149','158603','158958','158960','159121','159227','160605','160849','167072','167672','169268','170002','170072','170374','206109','206110','206111','206112','206113','206114','206115','206116','206117','206118','206119','206120','206121','206122','206123','206124','206125','206126','206127','206128','206129','206130','206131','206132','206133','206134','206135','206136','206137','206138','206139','206140','206141','206142','206143','206144','206145','206146','206147','206148','206149','206150','206151','206152','206153','206154','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201','206202','206203','206204','206205','206206','206207','206208','206209','206210','206211','206212','206213','206214','206215','206216','206217','206218','206219','206220','206221','206222','206223','206224','206225','206226','206227','206228','206229','206230','206231','206232','206233','206234','206235','206236','206237','206238','206239','206240','206241','206242','206243','206244','206245','206246','206247','206248','206249','206250','206251','206252','206253','206254','206255','206256','206257','206258','206259','206260','206261','206262','206263','206264','206265','206266','206267','206268','206269','206270','206271','206272','206273','206274','206275','206276','206277','206278','206279','206280','206281','206282','206283','206284','206285','206286','206287','206288','206289','206290','206291','206292','206293','206294','206295','206296','206297','206298','206299','206300','206301','206302','206303','206304','206305','206306','206307','206308','206309','206310','206311','206312','206313','206314','206315','206316','206317','206318','206319','206320','206321','206322','206323','206324','206325','206326','206327','206328','206329','206330','206331','206332','206333','206334','206335','206336','206337','206338','206339','206340','206341','206342','206343','206344','206345','206346','206347','206348','206349','206350','206351','206352','206353','206354','206355','206356','206357','206358','215465','215466','216104','219754','232461','232462','232598','232620','239875','239951','240195','240196','240419','240656','240717','240744','240776','240898','243113','244026','244300','245308','245770','247292','247295','247911','249587','253263','254768','254985','254986','256441','256481','256842','263187','263508','265097','273308','273575','274324','274777','276660','277687','280920','281028','283774','284564','285597','285739','286945','297558','297646','297906','298085','298282','299048','302171','302285','302301','158118','158606','158785','159831','161192','161759','162176','164174','164175','165287','165595','240292','240466','241731','242392','244729','245255','245856','246110','246197','247975','249584','250065','251798','262519','268568','276021','276129','277801','278691','281969','283649','287126','293200','294310','299937','302065','143381','143555','149695','150273','150274','150275','150276','150277','150278','150279','150280','155456','155731','158959','159836','159837','160333','161669','163705','164267','164283','164284','164285','166031','170550','201143','202725','202823','212783','212784','212785','212786','212787','212788','212789','212790','212791','212792','212793','212794','212795','212796','212797','212798','212799','212800','212801','212802','212803','212804','212805','212806','212807','212808','212809','212810','212811','212812','212813','212814','212815','212816','212817','212818','212819','212820','212821','212822','212823','212824','212825','212826','212827','212828','212829','212830','212831','212832','212833','212834','212835','212836','212837','212838','212839','212840','212841','212842','212843','212844','212845','212846','212847','212848','212849','240065','240159','240160','240161','240162','240163','240164','240448','241396','243030','244240','244787','244904','246259','247439','248618','249062','250176','250915','262099','262724','265304','266830','268466','268562','268794','273826','281253','281425','288495','293275','294792','295470','296193','164812','170635','202720','212932','212933','212934','212935','212936','212937','212938','212939','212940','212941','212942','212943','212944','212945','212946','212947','212948','212949','212950','212951','212952','212953','239677','242387','242388','242674','242886','252015','266778','266779','266780','266781','275806','275807','275808','278703','278704','278705','278706','278707','278708','279800','282401','287797','287798','295363','141798','142896','142897','142898','142899','143161','143369','143669','147758','147875','148133','148135','149488','149489','149491','149492','149493','149494','149495','149496','149497','149498','149499','149500','149501','149502','149503','149504','149505','149506','149507','149508','149713','150790','150848','151220','151223','151435','151436','151697','151795','151816','152003','152511','152515','152516','152527','153093','153101','153106','153332','153410','153411','153575','153576','153597','154456','156631','156847','157460','157461','157462','157463','157464','157465','157466','157505','157506','157724','157725','157729','157731','157733','157734','157735','158270','158409','158491','158526','158769','158905','158913','159029','159030','159061','159377','159423','159474','159475','159476','160021','160116','160159','160198','160335','160458','160513','161085','161261','161644','161686','161798','161956','162196','162199','162230','162340','162341','162342','162343','162344','162345','162346','162409','162417','162449','162495','162658','162659','162772','162852','162858','162894','162935','162936','163049','163329','163332','163680','163987','163988','164078','164601','164739','164796','165012','165497','165605','165645','165939','165959','165983','166095','166127','166444','166673','166871','166918','166924','166926','167038','167042','167062','167092','167117','167184','167409','167427','167574','167780','169114','169159','170050','170691','201292','202578','209372','209373','209374','209375','209376','209377','209378','209379','209380','209381','209382','209383','209384','209385','209386','209387','209388','209389','209390','209391','209392','209393','209394','209395','209396','209397','209398','209399','209400','209401','209402','209403','209404','209405','209406','209407','209408','209409','209410','209411','209412','209413','209414','209415','209416','209417','209418','209419','209420','209421','209422','209423','209424','209425','209426','209427','209428','209429','209430','209431','209432','209433','209434','209435','209436','209437','209438','209439','209440','209441','209442','209443','209444','209445','209446','209447','209448','209449','209450','209451','209452','209453','209454','209455','209456','209457','209458','209459','209460','209461','209462','209463','209464','209465','209466','209467','209468','209469','209470','209471','209472','210505','210506','215348','215467','215871','216103','219717','219721','219722','219747','232441','232442','232443','232685','238111','238494','238725','239107','239157','239458','239459','239652','239750','239813','239947','240346','240451','240548','240767','241218','241477','241478','241479','241849','242098','242099','242155','242239','242241','242248','242249','242250','242252','242253','242270','242298','242366','242583','242888','242889','242890','242906','242971','243012','243026','243063','243099','243100','243101','243138','243165','243235','243448','243489','243772','243773','243774','243974','244139','244202','244264','244339','244817','244856','244950','245034','245144','245145','245209','245239','245240','245258','245332','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245488','245747','245919','245980','246928','246929','247034','247045','247075','247143','247187','247196','247197','247322','247767','247807','247811','247878','248216','248217','248230','248243','248272','248273','248274','248275','248341','248573','248574','248599','248654','249093','249251','249273','249294','249306','249393','249411','249446','249616','249659','249704','249705','249787','249876','249902','250104','250126','250128','250137','250685','250686','250740','250775','250776','250803','250812','250906','250925','251006','251063','251064','251137','251224','251252','251257','251275','251276','251286','251321','251493','251733','251933','252021','252089','253131','253808','253877','254209','254531','254748','255013','255014','255157','255163','255176','255377','255378','255569','255571','255686','255865','256136','256137','256260','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256515','256543','257117','257118','257168','257169','257219','261955','261956','262123','262480','262653','262928','263454','263534','263616','263617','263658','264410','264820','264850','264851','264966','265063','265151','266129','266162','266186','266501','266502','266503','266504','266508','266761','266762','266765','266941','267243','267473','267752','267936','268159','268259','268260','268316','268409','268533','268603','268909','269031','269377','273544','273861','274040','274159','274676','274677','274704','274752','274778','274990','275059','275267','275268','275322','275333','275522','275611','275791','275792','276409','276410','276411','276412','276413','276414','276462','277223','277278','277384','277430','277474','277584','277749','277750','277762','277809','277949','277950','278009','278259','278446','278470','278576','278694','278821','278936','279013','279669','279676','279705','279745','280386','280547','280805','280943','280944','280945','280962','281148','281224','281230','282164','282165','282199','282200','282893','282894','283479','283602','283603','283659','283791','283793','284136','284279','284321','284322','284323','284508','284550','284578','284729','284730','284823','284860','284902','284913','284948','284955','285336','285379','285555','285557','285558','285575','285672','286014','286362','286661','286814','286912','287770','287771','287985','288574','289228','289229','289231','289232','289233','289234','289235','289236','289238','289246','289247','289248','289249','289250','289251','289252','289253','289427','289428','289429','289430','289431','289432','289433','289434','289466','291625','291994','292034','292530','293210','293392','293484','294250','294273','294670','294718','294732','294733','294734','294735','294737','294746','294750','294805','294811','294847','295376','295572','295595','297120','297153','297191','297467','297758','297859','298015','298169','298244','298411','298572','299107','299122','299211','299454','299504','299549','299722','299794','299798','299799','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299995','300061','300304','300305','300306','301049','301807','301808','301809','301810','301811','301812','301855','301864','301951','302003','302004','302005','302006','302007','302008','302009','302010','302011','302012','302013','302014','302015','302016','302017','302018','302019','302020','302021','302022','302023','302024','302025','302026','302027','302028','302029','302030','302031','302032','302033','302034','302035','302036','302037','302038','302039','302040','302041','302042','302043','302044','302045','302046','302047','302048','302061','302063','303906','303908','303934','304024','151731','170662','215938','245839','249186','151114','159659','160107','160882','161330','163719','167131','167132','167133','167134','167135','167752','215561','239892','240457','240458','240459','240460','240462','240463','240464','241332','241739','242218','242681','243484','244004','244005','244006','244007','244008','244009','244010','244011','244012','244013','244014','244015','244016','244017','244018','244019','244020','244021','244022','245066','245067','245068','245352','245661','245925','246422','246628','247257','247323','247595','247617','247618','248056','248088','249011','249504','249789','249840','250212','250797','251437','251438','251806','253864','253871','254343','254350','254351','254759','254987','255570','255894','256671','256672','256673','257063','262516','262518','263088','263089','263090','263490','263715','265245','266804','267653','268319','269303','273512','273685','273717','273718','276651','277643','277986','277987','277988','277989','277990','277991','277992','277993','277994','278454','279126','279127','279128','279129','279767','279768','280371','280372','280735','283143','284519','284832','285919','286261','286394','286396','286660','287384','288271','288315','288843','291985','292511','293213','294222','297416','297545','297546','297837','298033','299102','299419','299561','299734','299769','300359','300581','300945','302337','303977','154279','158954','161563','163181','164316','238738','242167','242168','242169','242170','242171','242172','244962','245795','248941','249025','249505','250863','251691','256922','256923','267416','268736','268771','269012','273766','273853','275068','275099','275100','277695','277696','277697','278085','278086','281590','281598','281654','281655','281656','282558','282798','282799','282800','282801','283339','283340','283351','283674','284142','285137','285138','285139','285378','286046','287136','287137','288417','288441','288556','291982','292305','292319','292320','292730','292731','292751','294351','296254','297214','297644','299930','299931','300257','300258','300310','300376','300944','151015','157632','162529','242952','245711','245712','245713','249913','249914','250096','266841','266958','268847','275028','275029','276418','277034','277036','277044','280509','281904','288605','292037','294291','298388','300946','300947','288659','292014','299086','291883','299349') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke1: parent
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 ('141798','141891','142230','142851','142896','142897','142898','142899','143161','143239','143274','143369','143381','143555','143669','143691','143692','143931','144205','144287','144975','144976','144977','144992','146695','146701','147224','147758','147875','147976','148060','148133','148135','148164','148165','148611','148991','148992','148993','148994','148995','148996','148997','148998','148999','149000','149001','149488','149489','149491','149492','149493','149494','149495','149496','149497','149498','149499','149500','149501','149502','149503','149504','149505','149506','149507','149508','149695','149707','149708','149713','149762','149763','149764','149765','149766','149767','149768','149769','149770','149771','149772','149773','149774','149775','149776','149777','149778','149779','150150','150151','150159','150160','150273','150274','150275','150276','150277','150278','150279','150280','150464','150670','150772','150790','150841','150848','151015','151036','151042','151043','151059','151060','151114','151220','151223','151435','151436','151456','151635','151637','151638','151639','151642','151697','151731','151795','151816','151850','151972','151993','152003','152511','152515','152516','152527','153093','153101','153106','153107','153332','153410','153411','153575','153576','153597','153640','153644','153891','153923','154279','154322','154425','154456','154772','154789','155060','155061','155265','155266','155267','155268','155269','155270','155456','155477','155731','155822','155858','155859','156284','156285','156286','156631','156823','156824','156825','156826','156827','156828','156829','156830','156831','156847','157265','157408','157460','157461','157462','157463','157464','157465','157466','157503','157505','157506','157632','157709','157724','157725','157729','157731','157733','157734','157735','157908','158015','158016','158118','158148','158149','158186','158217','158270','158340','158377','158409','158445','158491','158497','158526','158603','158606','158629','158657','158660','158759','158769','158771','158785','158829','158830','158831','158905','158913','158954','158958','158959','158960','159009','159010','159014','159029','159030','159061','159095','159121','159227','159296','159377','159423','159424','159450','159474','159475','159476','159481','159527','159528','159529','159632','159659','159698','159705','159750','159831','159833','159834','159836','159837','159838','159839','159840','159841','159869','159912','160021','160036','160107','160116','160117','160159','160180','160198','160236','160237','160304','160333','160335','160458','160513','160605','160730','160820','160839','160849','160851','160882','160894','160895','161042','161085','161102','161103','161107','161162','161192','161261','161321','161330','161387','161421','161438','161563','161644','161669','161686','161759','161768','161797','161798','161885','161886','161897','161956','162149','162176','162196','162199','162230','162257','162340','162341','162342','162343','162344','162345','162346','162366','162409','162417','162448','162449','162495','162529','162658','162659','162766','162772','162852','162858','162894','162904','162905','162935','162936','163042','163047','163049','163086','163103','163108','163109','163110','163111','163112','163113','163181','163324','163329','163332','163544','163619','163621','163661','163680','163705','163718','163719','163725','163751','163793','163800','163803','163815','163831','163895','163929','163987','163988','164078','164113','164153','164154','164174','164175','164176','164177','164263','164267','164283','164284','164285','164316','164591','164601','164684','164733','164739','164796','164812','164818','164981','165005','165012','165029','165080','165188','165189','165198','165199','165200','165201','165202','165203','165204','165205','165218','165287','165448','165497','165529','165538','165595','165605','165645','165815','165849','165914','165939','165959','165983','166031','166095','166127','166319','166322','166444','166445','166510','166546','166561','166597','166673','166871','166918','166921','166924','166926','166938','167038','167042','167062','167072','167092','167106','167117','167128','167131','167132','167133','167134','167135','167148','167149','167150','167151','167152','167184','167212','167273','167274','167359','167409','167427','167433','167434','167445','167531','167574','167627','167672','167699','167752','167780','167833','167842','167884','167926','167991','168064','168116','168218','168267','168268','168340','168398','169114','169159','169268','170002','170024','170050','170072','170077','170078','170205','170285','170374','170413','170414','170415','170530','170531','170532','170533','170534','170535','170536','170537','170538','170539','170540','170541','170542','170543','170550','170597','170598','170635','170662','170691','185916','201141','201143','201144','201181','201182','201183','201184','201185','201190','201191','201192','201292','202578','202694','202720','202725','202769','202823','202841','206109','206110','206111','206112','206113','206114','206115','206116','206117','206118','206119','206120','206121','206122','206123','206124','206125','206126','206127','206128','206129','206130','206131','206132','206133','206134','206135','206136','206137','206138','206139','206140','206141','206142','206143','206144','206145','206146','206147','206148','206149','206150','206151','206152','206153','206154','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201','206202','206203','206204','206205','206206','206207','206208','206209','206210','206211','206212','206213','206214','206215','206216','206217','206218','206219','206220','206221','206222','206223','206224','206225','206226','206227','206228','206229','206230','206231','206232','206233','206234','206235','206236','206237','206238','206239','206240','206241','206242','206243','206244','206245','206246','206247','206248','206249','206250','206251','206252','206253','206254','206255','206256','206257','206258','206259','206260','206261','206262','206263','206264','206265','206266','206267','206268','206269','206270','206271','206272','206273','206274','206275','206276','206277','206278','206279','206280','206281','206282','206283','206284','206285','206286','206287','206288','206289','206290','206291','206292','206293','206294','206295','206296','206297','206298','206299','206300','206301','206302','206303','206304','206305','206306','206307','206308','206309','206310','206311','206312','206313','206314','206315','206316','206317','206318','206319','206320','206321','206322','206323','206324','206325','206326','206327','206328','206329','206330','206331','206332','206333','206334','206335','206336','206337','206338','206339','206340','206341','206342','206343','206344','206345','206346','206347','206348','206349','206350','206351','206352','206353','206354','206355','206356','206357','206358','209372','209373','209374','209375','209376','209377','209378','209379','209380','209381','209382','209383','209384','209385','209386','209387','209388','209389','209390','209391','209392','209393','209394','209395','209396','209397','209398','209399','209400','209401','209402','209403','209404','209405','209406','209407','209408','209409','209410','209411','209412','209413','209414','209415','209416','209417','209418','209419','209420','209421','209422','209423','209424','209425','209426','209427','209428','209429','209430','209431','209432','209433','209434','209435','209436','209437','209438','209439','209440','209441','209442','209443','209444','209445','209446','209447','209448','209449','209450','209451','209452','209453','209454','209455','209456','209457','209458','209459','209460','209461','209462','209463','209464','209465','209466','209467','209468','209469','209470','209471','209472','210493','210496','210497','210498','210499','210500','210501','210502','210503','210505','210506','210775','210776','210777','210778','210779','210780','210781','210782','210783','210784','210785','210786','210787','210788','210789','210790','210791','210792','210793','210794','210795','210796','210797','210798','210799','210800','210801','210802','210803','210804','210805','210806','210807','210808','210809','210810','210811','210812','210813','210814','210815','210816','210817','210818','210819','210820','210821','210822','210823','210824','210825','210826','210827','210828','210829','210830','210831','210832','210833','210834','210835','210836','210837','210838','210839','210840','210841','210842','210843','210844','210845','210846','210970','210982','210983','211008','211820','211821','211822','211823','211824','211825','211826','211827','211828','211829','211830','211831','211832','211833','211834','211835','211836','211837','211838','211839','211840','211841','211842','211843','211844','211845','211846','211847','211848','211849','211850','211851','211852','211853','211854','211855','211856','211857','211858','211859','211860','211861','211862','211863','211864','211865','211866','211867','211868','211869','211870','211871','211872','211873','211874','211875','211876','211974','211975','211976','211977','211978','211979','211980','211981','211982','211983','211984','211985','212783','212784','212785','212786','212787','212788','212789','212790','212791','212792','212793','212794','212795','212796','212797','212798','212799','212800','212801','212802','212803','212804','212805','212806','212807','212808','212809','212810','212811','212812','212813','212814','212815','212816','212817','212818','212819','212820','212821','212822','212823','212824','212825','212826','212827','212828','212829','212830','212831','212832','212833','212834','212835','212836','212837','212838','212839','212840','212841','212842','212843','212844','212845','212846','212847','212848','212849','212932','212933','212934','212935','212936','212937','212938','212939','212940','212941','212942','212943','212944','212945','212946','212947','212948','212949','212950','212951','212952','212953','215216','215250','215273','215348','215415','215465','215466','215467','215542','215561','215720','215795','215847','215871','215896','215938','216001','216002','216046','216091','216093','216103','216104','219717','219721','219722','219747','219754','219761','232404','232421','232441','232442','232443','232461','232462','232561','232595','232598','232620','232641','232648','232685','232694','232780','238111','238140','238267','238445','238494','238556','238590','238662','238715','238725','238738','239106','239107','239156','239157','239207','239222','239248','239316','239317','239458','239459','239652','239677','239750','239813','239875','239892','239947','239951','239971','239992','240004','240065','240097','240098','240137','240159','240160','240161','240162','240163','240164','240195','240196','240244','240282','240285','240288','240292','240313','240346','240348','240349','240354','240356','240395','240419','240433','240445','240448','240451','240453','240457','240458','240459','240460','240462','240463','240464','240465','240466','240504','240507','240521','240548','240563','240573','240574','240575','240656','240717','240744','240767','240776','240815','240816','240817','240819','240830','240833','240835','240837','240838','240898','240943','240944','240947','240963','240968','241061','241218','241279','241310','241332','241338','241339','241395','241396','241468','241469','241477','241478','241479','241516','241529','241538','241672','241692','241722','241724','241731','241739','241764','241849','241978','242071','242098','242099','242155','242159','242160','242161','242162','242163','242167','242168','242169','242170','242171','242172','242218','242230','242239','242241','242248','242249','242250','242252','242253','242270','242298','242366','242382','242387','242388','242392','242429','242508','242515','242516','242583','242674','242681','242726','242785','242813','242814','242820','242886','242888','242889','242890','242906','242952','242971','243012','243013','243026','243030','243063','243099','243100','243101','243113','243138','243145','243165','243235','243287','243419','243426','243448','243463','243484','243489','243539','243601','243679','243680','243772','243773','243774','243835','243836','243974','244004','244005','244006','244007','244008','244009','244010','244011','244012','244013','244014','244015','244016','244017','244018','244019','244020','244021','244022','244026','244049','244050','244139','244202','244210','244240','244263','244264','244288','244291','244300','244339','244352','244473','244548','244729','244750','244787','244817','244856','244862','244904','244950','244962','245034','245066','245067','245068','245103','245144','245145','245203','245209','245228','245239','245240','245255','245258','245307','245308','245332','245352','245384','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245488','245489','245661','245711','245712','245713','245747','245770','245792','245795','245839','245847','245856','245919','245925','245980','246021','246022','246110','246170','246197','246198','246257','246259','246374','246395','246422','246467','246567','246628','246668','246669','246670','246671','246672','246673','246674','246681','246701','246715','246725','246726','246727','246728','246729','246731','246732','246759','246824','246914','246928','246929','246947','246969','247000','247034','247045','247075','247143','247186','247187','247196','247197','247245','247257','247259','247292','247295','247322','247323','247358','247439','247451','247565','247587','247595','247617','247618','247753','247767','247807','247811','247878','247911','247913','247975','248022','248056','248088','248090','248140','248210','248216','248217','248230','248243','248272','248273','248274','248275','248295','248327','248331','248341','248360','248403','248404','248405','248406','248441','248485','248573','248574','248599','248618','248620','248652','248654','248659','248718','248736','248768','248784','248791','248849','248850','248851','248852','248866','248941','249011','249025','249062','249093','249116','249149','249186','249196','249234','249251','249259','249273','249294','249306','249344','249390','249393','249411','249446','249504','249505','249537','249584','249587','249616','249659','249666','249704','249705','249714','249762','249787','249789','249822','249840','249850','249876','249895','249902','249913','249914','250044','250065','250096','250104','250126','250128','250137','250149','250176','250212','250501','250502','250503','250504','250505','250509','250611','250620','250684','250685','250686','250740','250775','250776','250796','250797','250803','250812','250849','250863','250890','250903','250906','250915','250918','250925','251006','251063','251064','251080','251137','251154','251224','251252','251257','251267','251275','251276','251286','251321','251437','251438','251493','251498','251510','251553','251691','251717','251733','251798','251806','251931','251933','251950','251979','252015','252021','252047','252077','252089','252110','252153','252240','253131','253263','253483','253633','253739','253768','253808','253852','253853','253855','253864','253871','253877','254209','254213','254343','254350','254351','254380','254382','254436','254439','254454','254531','254616','254646','254748','254759','254768','254821','254883','254896','254897','254898','254899','254945','254970','254985','254986','254987','255003','255013','255014','255106','255117','255118','255157','255163','255176','255181','255277','255361','255377','255378','255471','255504','255569','255570','255571','255596','255686','255865','255894','255942','255943','255944','255945','255946','255947','256097','256098','256104','256136','256137','256196','256260','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256441','256481','256515','256543','256616','256658','256671','256672','256673','256724','256842','256876','256922','256923','257060','257061','257063','257117','257118','257168','257169','257177','257219','261710','261711','261756','261773','261955','261956','262099','262108','262123','262188','262313','262345','262346','262480','262516','262518','262519','262653','262724','262857','262928','262939','263088','263089','263090','263187','263454','263490','263508','263534','263585','263611','263612','263616','263617','263658','263681','263715','264350','264351','264359','264363','264410','264455','264491','264649','264820','264850','264851','264882','264910','264951','264962','264964','264966','265060','265063','265064','265080','265081','265095','265097','265099','265151','265227','265245','265304','265335','265366','265404','265413','265414','265523','265540','265658','265695','265709','265784','265837','265838','265845','265850','265851','265867','265874','265970','266003','266036','266038','266040','266041','266078','266090','266096','266118','266129','266162','266178','266186','266268','266278','266354','266396','266415','266429','266460','266501','266502','266503','266504','266508','266566','266612','266757','266761','266762','266765','266778','266779','266780','266781','266804','266825','266830','266841','266903','266941','266958','266974','266982','267054','267108','267227','267243','267353','267412','267416','267459','267473','267480','267528','267653','267752','267757','267868','267936','268011','268012','268013','268014','268015','268016','268017','268018','268019','268020','268021','268022','268023','268024','268025','268026','268027','268029','268030','268031','268032','268033','268034','268035','268036','268052','268081','268112','268127','268159','268223','268259','268260','268316','268319','268347','268409','268466','268501','268502','268503','268506','268533','268562','268568','268603','268696','268736','268771','268783','268784','268794','268847','268859','268861','268909','269012','269017','269031','269032','269038','269049','269149','269152','269153','269242','269303','269346','269347','269371','269377','269459','269462','269463','269464','269465','269466','269483','269586','273306','273307','273308','273361','273403','273404','273503','273512','273544','273560','273575','273673','273676','273677','273685','273717','273718','273766','273787','273798','273826','273852','273853','273861','273890','273915','273937','273949','273961','274040','274159','274324','274387','274388','274389','274390','274391','274392','274393','274394','274395','274437','274438','274444','274445','274451','274452','274453','274454','274455','274456','274492','274510','274511','274515','274649','274650','274676','274677','274704','274752','274777','274778','274783','274814','274829','274861','274862','274990','275003','275028','275029','275059','275068','275099','275100','275135','275137','275267','275268','275322','275333','275353','275396','275399','275485','275522','275611','275614','275625','275735','275758','275762','275791','275792','275806','275807','275808','276021','276066','276129','276135','276136','276138','276139','276140','276141','276246','276409','276410','276411','276412','276413','276414','276418','276434','276462','276499','276529','276564','276594','276598','276651','276653','276660','276668','276669','276697','276763','276769','276810','277034','277036','277044','277068','277223','277265','277266','277278','277291','277293','277304','277338','277339','277342','277384','277422','277430','277463','277474','277511','277584','277643','277687','277695','277696','277697','277720','277721','277722','277723','277724','277725','277726','277727','277729','277730','277731','277749','277750','277762','277798','277801','277808','277809','277949','277950','277967','277980','277981','277982','277983','277984','277985','277986','277987','277988','277989','277990','277991','277992','277993','277994','278009','278085','278086','278191','278223','278259','278369','278370','278446','278454','278464','278470','278475','278506','278519','278576','278615','278691','278693','278694','278703','278704','278705','278706','278707','278708','278734','278743','278760','278768','278771','278815','278821','278834','278928','278936','279013','279073','279126','279127','279128','279129','279194','279262','279267','279268','279296','279377','279455','279484','279666','279669','279676','279690','279694','279705','279724','279725','279732','279733','279745','279767','279768','279800','279814','280283','280350','280366','280367','280371','280372','280378','280386','280442','280443','280509','280531','280547','280589','280709','280735','280765','280766','280767','280768','280805','280819','280862','280881','280920','280943','280944','280945','280962','280990','281028','281072','281148','281178','281194','281223','281224','281230','281253','281388','281396','281400','281402','281403','281408','281425','281584','281590','281598','281627','281628','281654','281655','281656','281768','281904','281969','282030','282112','282164','282165','282170','282174','282177','282199','282200','282366','282401','282444','282481','282545','282558','282768','282798','282799','282800','282801','282811','282839','282893','282894','282908','283065','283110','283143','283339','283340','283341','283345','283351','283479','283480','283602','283603','283604','283606','283649','283659','283674','283733','283774','283791','283793','284134','284136','284142','284149','284162','284184','284279','284280','284283','284321','284322','284323','284441','284508','284519','284550','284564','284578','284579','284625','284729','284730','284823','284832','284843','284860','284902','284907','284913','284948','284955','285054','285073','285076','285121','285137','285138','285139','285140','285141','285183','285185','285223','285333','285336','285375','285376','285378','285379','285386','285431','285531','285555','285557','285558','285575','285597','285672','285725','285739','285829','285830','285898','285914','285919','285968','285984','286014','286046','286113','286124','286127','286261','286281','286362','286373','286394','286396','286444','286603','286626','286647','286660','286661','286814','286912','286939','286945','286947','287126','287136','287137','287173','287197','287198','287202','287384','287504','287505','287770','287771','287797','287798','287799','287800','287801','287802','287803','287804','287805','287806','287807','287808','287809','287810','287811','287812','287813','287814','287815','287816','287817','287818','287819','287820','287821','287822','287823','287824','287825','287826','287827','287828','287829','287830','287831','287832','287833','287834','287835','287836','287837','287838','287839','287840','287841','287842','287843','287844','287845','287846','287847','287848','287849','287850','287851','287852','287853','287854','287855','287856','287857','287858','287859','287860','287861','287862','287863','287864','287865','287866','287867','287868','287869','287870','287871','287872','287873','287874','287875','287876','287877','287878','287879','287880','287881','287882','287883','287884','287885','287886','287887','287888','287889','287890','287891','287892','287893','287894','287895','287896','287897','287898','287899','287900','287901','287902','287903','287904','287905','287906','287907','287908','287909','287910','287911','287912','287913','287914','287915','287916','287917','287918','287919','287920','287921','287922','287923','287924','287925','287926','287927','287928','287929','287930','287931','287932','287933','287934','287935','287936','287937','287938','287939','287940','287941','287942','287943','287944','287945','287946','287947','287948','287949','287950','287951','287952','287953','287954','287955','287956','287957','287958','287959','287960','287961','287962','287963','287964','287965','287966','287967','287985','287993','288004','288097','288099','288101','288109','288127','288205','288232','288259','288271','288293','288307','288315','288355','288417','288441','288480','288493','288495','288556','288574','288605','288625','288659','288843','288869','288983','289228','289229','289231','289232','289233','289234','289235','289236','289238','289246','289247','289248','289249','289250','289251','289252','289253','289261','289427','289428','289429','289430','289431','289432','289433','289434','289466','291625','291701','291825','291869','291877','291883','291885','291982','291985','291989','291990','291991','291992','291994','291995','291999','292001','292003','292004','292006','292014','292034','292037','292224','292305','292319','292320','292386','292498','292503','292511','292530','292716','292730','292731','292735','292736','292737','292738','292739','292751','292803','292846','293200','293201','293210','293213','293275','293387','293392','293484','293525','293544','294072','294221','294222','294228','294237','294250','294261','294267','294273','294282','294289','294291','294310','294351','294494','294496','294601','294606','294670','294718','294732','294733','294734','294735','294737','294746','294750','294792','294801','294805','294811','294847','295338','295363','295376','295433','295457','295470','295494','295512','295514','295517','295572','295595','295622','295751','295836','295995','296193','296223','296237','296242','296254','297120','297153','297191','297196','297214','297416','297454','297455','297467','297545','297546','297551','297558','297590','297591','297602','297630','297644','297646','297758','297794','297837','297859','297906','297957','297979','298015','298029','298033','298057','298085','298137','298138','298139','298158','298169','298171','298242','298244','298282','298334','298373','298388','298411','298453','298522','298528','298572','298579','298590','298595','298601','299048','299086','299102','299107','299122','299176','299192','299211','299349','299373','299403','299419','299448','299454','299504','299549','299561','299680','299682','299722','299734','299769','299794','299798','299799','299877','299906','299919','299930','299931','299937','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299995','300031','300061','300072','300209','300257','300258','300304','300305','300306','300310','300328','300359','300376','300578','300581','300610','300639','300926','300927','300944','300945','300946','300947','301047','301048','301049','301067','301806','301807','301808','301809','301810','301811','301812','301855','301864','301881','301895','301951','301986','302003','302004','302005','302006','302007','302008','302009','302010','302011','302012','302013','302014','302015','302016','302017','302018','302019','302020','302021','302022','302023','302024','302025','302026','302027','302028','302029','302030','302031','302032','302033','302034','302035','302036','302037','302038','302039','302040','302041','302042','302043','302044','302045','302046','302047','302048','302061','302063','302065','302107','302146','302171','302224','302271','302285','302291','302292','302293','302295','302301','302337','302350','302352','303804','303904','303906','303908','303926','303927','303934','303945','303977','304024') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('31','38','58','147','165','170','175','192','244','265','274','291','323','324','157503','158217','158629','159527','159528','159529','159912','160304','161107','163831','163929','164113','165080','165914','166938','168398','170597','215273','238445','239106','240137','240244','240465','240504','240507','240947','241061','241538','241692','242071','242813','242814','243679','243680','244352','245103','246170','246729','246759','247186','248022','248140','248784','248849','248850','248851','248852','249116','249259','250611','250849','251950','254883','254896','254897','254898','254899','263681','265064','265523','266038','266040','266041','266757','267227','267353','267412','269038','269586','273361','274451','274452','274453','274454','274455','274456','274510','274511','275353','276564','277291','277980','277981','277982','277983','277984','277985','278815','279267','279268','281768','282174','282366','282839','283065','283110','283341','283345','283549','284843','285054','285141','285223','286281','286603','287197','287198','289276','292215','292386','295338','297196','299428','299877','300031','300926','300927','304266','143239','147976','150670','151638','158186','158497','158829','158830','158831','159009','159010','159296','159481','159632','160839','161102','161103','161421','161768','161897','162257','163544','163718','163815','164684','164818','165218','165529','167273','167274','167433','167434','167445','167699','168267','168268','215542','216001','216002','232648','232694','238140','238267','240004','240573','240574','240575','241395','243013','243419','243601','244473','244548','244750','244862','245792','246395','246668','246669','246670','246671','246672','246673','246674','246681','246715','246947','247245','247565','247753','248295','248327','248403','248404','248405','248406','248652','248659','250044','250796','250918','251510','251717','253855','255277','262313','264351','264649','264882','265080','265081','265335','265413','265414','265658','265837','265838','265845','265850','265851','265867','266078','266178','266354','266396','266566','267528','268052','268127','268501','268503','269483','273503','273890','273915','273949','274515','274649','274650','274814','274861','274862','275485','275762','276598','276810','277068','277265','277266','277304','277463','278191','278734','278743','278928','279073','279262','279296','279690','280709','282170','283606','283733','285914','286113','286127','287799','287800','287801','287802','287803','287804','287805','287806','287807','287808','287809','287810','287811','287812','287813','287814','287815','287816','287817','287818','287819','287820','287821','287822','287823','287824','287825','287826','287827','287828','287829','287830','287831','287832','287833','287834','287835','287836','287837','287838','287839','287840','287841','287842','287843','287844','287845','287846','287847','287848','287849','287850','287851','287852','287853','287854','287855','287856','287857','287858','287859','287860','287861','287862','287863','287864','287865','287866','287867','287868','287869','287870','287871','287872','287873','287874','287875','287876','287877','287878','287879','287880','287881','287882','287883','287884','287885','287886','287887','287888','287889','287890','287891','287892','287893','287894','287895','287896','287897','287898','287899','287900','287901','287902','287903','287904','287905','287906','287907','287908','287909','287910','287911','287912','287913','287914','287915','287916','287917','287918','287919','287920','287921','287922','287923','287924','287925','287926','287927','287928','287929','287930','287931','287932','287933','287934','287935','287936','287937','287938','287939','287940','287941','287942','287943','287944','287945','287946','287947','287948','287949','287950','287951','287952','287953','287954','287955','287956','287957','287958','287959','287960','287961','287962','287963','287964','287965','287966','287967','288293','288355','289261','291885','292735','292736','292737','292738','292739','294267','297590','298242','298334','298453','299906','300610','302107','302350','302352','303804','141891','142851','143274','143931','147224','148164','148165','148611','149762','149763','149764','149765','149766','149767','149768','149769','149770','149771','149772','149773','149774','149775','149776','149777','149778','149779','151036','151639','153107','153891','154322','154425','154772','154789','155060','155061','155265','155266','155267','155268','155269','155270','156284','156285','156286','157265','158771','159424','159450','159705','159833','159834','159838','159839','159840','159841','160851','160894','160895','161042','161162','161438','161797','162149','163103','163108','163109','163110','163111','163112','163113','163661','163725','164263','165005','165448','166510','167128','167884','167926','168064','168116','168340','170285','210775','210776','210777','210778','210779','210780','210781','210782','210783','210784','210785','210786','210787','210788','210789','210790','210791','210792','210793','210794','210795','210796','210797','210798','210799','210800','210801','210802','210803','210804','210805','210806','210807','210808','210809','210810','210811','210812','210813','210814','210815','210816','210817','210818','210819','210820','210821','210822','210823','210824','210825','210826','210827','210828','210829','210830','210831','210832','210833','210834','210835','210836','210837','210838','210839','210840','210841','210842','210843','210844','210845','210846','232561','238556','238662','238715','239207','239971','240963','240968','241279','241724','242508','243145','243463','245307','246198','246701','247000','250149','250620','250684','252077','253768','254454','255003','262188','263611','263612','264455','265709','265874','266268','268696','269149','269152','269153','269346','269459','274829','275399','275758','276434','276697','279194','279733','280283','281194','281400','281402','281403','281408','281628','282545','284149','286444','286626','287173','288232','288259','288480','288625','291869','292846','295995','297591','297957','298171','298373','300578','301806','301895','302271','303904','142230','150464','150772','150841','151637','151642','158445','160180','161886','163793','163895','164733','166561','167106','167833','215795','215896','216091','232421','239222','240395','240563','240943','240944','241516','241672','242159','242160','242161','242162','242163','242515','243426','244049','244050','245228','246567','246731','246732','246824','248360','248718','248768','252047','252110','253483','266118','266429','266460','267108','267757','273787','273937','274492','275614','277808','278475','278506','278834','279377','279694','280531','281396','282908','285984','286939','287202','288101','288109','291877','294228','296223','298528','299192','302291','143691','143692','144287','149707','149708','150150','150151','151042','151043','151456','151635','151850','151972','151993','153640','153644','155477','155822','156823','156824','156825','156826','156827','156828','156829','156830','156831','157709','158015','158016','158340','158377','158657','158660','158759','159014','159095','159698','159750','159869','160036','160117','160236','160237','160820','161321','161387','161885','162366','162448','162766','162904','162905','163042','163047','163086','163324','163619','163621','163751','163800','163803','164153','164154','164176','164177','164591','164981','165029','165188','165189','165198','165199','165200','165201','165202','165203','165204','165205','165538','165815','165849','166319','166322','166445','166546','166597','166921','167359','167531','167627','167842','167991','168218','170024','170077','170078','170205','170413','170414','170415','170530','170531','170532','170533','170534','170535','170536','170537','170538','170539','170540','170541','170542','170543','185916','210493','210496','210497','210498','210499','210500','210501','210502','210503','210970','210982','210983','211008','211820','211821','211822','211823','211824','211825','211826','211827','211828','211829','211830','211831','211832','211833','211834','211835','211836','211837','211838','211839','211840','211841','211842','211843','211844','211845','211846','211847','211848','211849','211850','211851','211852','211853','211854','211855','211856','211857','211858','211859','211860','211861','211862','211863','211864','211865','211866','211867','211868','211869','211870','211871','211872','211873','211874','211875','211876','215216','215250','215415','215720','216046','216093','219761','232595','232641','232780','238590','239156','239248','239316','239317','240097','240098','240282','240285','240288','240313','240348','240349','240354','240356','240433','240445','240453','240521','240815','240816','240817','240819','240830','240833','240835','240837','240838','241310','241338','241339','241468','241469','241529','241722','241764','241978','242230','242382','242429','242516','242726','242785','242820','243287','243539','243835','243836','244210','244288','244291','245203','245384','245489','245847','246021','246257','246467','246725','246726','246727','246728','246914','246969','247358','247587','247913','248090','248210','248331','248441','248485','248620','248736','248791','248866','249149','249196','249344','249390','249537','249666','249714','249822','249850','249895','250509','250890','250903','251080','251154','251267','251498','251553','251931','251979','252153','252240','253633','253739','253852','253853','254213','254380','254382','254436','254439','254616','254646','254821','254945','254970','255106','255117','255118','255181','255361','255471','255504','255596','255942','255943','255944','255945','255946','255947','256097','256098','256104','256196','256616','256658','256724','256876','257060','257061','257177','261710','261711','261756','261773','262108','262345','262346','262939','263585','264350','264359','264363','264491','264910','264951','264962','264964','265060','265099','265227','265366','265404','265540','265695','265784','265970','266003','266090','266278','266415','266612','266825','266903','266974','266982','267054','267459','267480','267868','268011','268012','268013','268014','268015','268016','268017','268018','268019','268020','268021','268022','268023','268024','268025','268026','268027','268029','268030','268031','268032','268033','268034','268035','268036','268081','268112','268223','268347','268502','268506','268783','268784','268859','268861','269017','269032','269242','269347','269371','269462','269463','269464','269465','269466','273306','273307','273403','273404','273560','273673','273676','273677','273798','273961','274387','274388','274389','274390','274391','274392','274393','274394','274395','274437','274438','274444','274445','274783','275003','275135','275396','275625','275735','276135','276136','276138','276139','276140','276141','276246','276499','276529','276594','276668','276669','276763','276769','277338','277339','277342','277422','277511','277720','277721','277722','277723','277724','277725','277726','277727','277729','277730','277731','277798','277967','278223','278369','278370','278464','278519','278615','278693','278760','278768','278771','279455','279484','279666','279724','279725','279732','279814','280350','280366','280367','280442','280443','280589','280765','280766','280767','280768','280819','280862','280881','280990','281072','281178','281223','281388','281584','281627','282030','282112','282177','282444','282481','282768','282811','283604','284134','284184','284280','284283','284441','284579','284907','285073','285076','285121','285140','285183','285185','285333','285375','285376','285386','285431','285531','285725','285829','285830','285898','285968','286124','286373','286647','287504','287505','287993','288004','288097','288099','288127','288205','288307','288493','288869','288983','291825','291989','291990','291991','291992','291995','291999','292001','292003','292004','292006','292224','292498','292503','292716','292803','293201','293387','293525','293544','294072','294221','294237','294261','294282','294289','294494','294496','294601','294606','294801','295433','295457','295494','295512','295514','295517','295622','295751','295836','296237','296242','297454','297455','297602','297630','297794','297979','298029','298057','298137','298138','298139','298158','298522','298579','298590','298595','298601','299176','299373','299403','299448','299919','300072','300209','300328','300639','301048','301067','301881','301986','302146','302224','302292','302293','302295','303926','303927','303945','146701','148060','150159','150160','201181','201182','201183','201184','201185','201190','201191','201192','202694','211974','211975','211976','211977','211978','211979','211980','211981','211982','211983','211984','211985','232404','269049','144205','151059','151060','153923','157408','160730','167148','167149','167150','167151','167152','167212','170598','201141','201144','202769','202841','215847','239992','244263','246022','246374','247259','247451','249234','249762','250501','250502','250503','250504','250505','262857','265095','266036','266096','273852','275137','276066','276653','277293','280378','283480','284162','284625','286947','291701','297551','299680','299682','301047','144975','144976','144977','144992','146695','148991','148992','148993','148994','148995','148996','148997','148998','148999','149000','149001','155858','155859','157908','158148','158149','158603','158958','158960','159121','159227','160605','160849','167072','167672','169268','170002','170072','170374','206109','206110','206111','206112','206113','206114','206115','206116','206117','206118','206119','206120','206121','206122','206123','206124','206125','206126','206127','206128','206129','206130','206131','206132','206133','206134','206135','206136','206137','206138','206139','206140','206141','206142','206143','206144','206145','206146','206147','206148','206149','206150','206151','206152','206153','206154','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201','206202','206203','206204','206205','206206','206207','206208','206209','206210','206211','206212','206213','206214','206215','206216','206217','206218','206219','206220','206221','206222','206223','206224','206225','206226','206227','206228','206229','206230','206231','206232','206233','206234','206235','206236','206237','206238','206239','206240','206241','206242','206243','206244','206245','206246','206247','206248','206249','206250','206251','206252','206253','206254','206255','206256','206257','206258','206259','206260','206261','206262','206263','206264','206265','206266','206267','206268','206269','206270','206271','206272','206273','206274','206275','206276','206277','206278','206279','206280','206281','206282','206283','206284','206285','206286','206287','206288','206289','206290','206291','206292','206293','206294','206295','206296','206297','206298','206299','206300','206301','206302','206303','206304','206305','206306','206307','206308','206309','206310','206311','206312','206313','206314','206315','206316','206317','206318','206319','206320','206321','206322','206323','206324','206325','206326','206327','206328','206329','206330','206331','206332','206333','206334','206335','206336','206337','206338','206339','206340','206341','206342','206343','206344','206345','206346','206347','206348','206349','206350','206351','206352','206353','206354','206355','206356','206357','206358','215465','215466','216104','219754','232461','232462','232598','232620','239875','239951','240195','240196','240419','240656','240717','240744','240776','240898','243113','244026','244300','245308','245770','247292','247295','247911','249587','253263','254768','254985','254986','256441','256481','256842','263187','263508','265097','273308','273575','274324','274777','276660','277687','280920','281028','283774','284564','285597','285739','286945','297558','297646','297906','298085','298282','299048','302171','302285','302301','158118','158606','158785','159831','161192','161759','162176','164174','164175','165287','165595','240292','240466','241731','242392','244729','245255','245856','246110','246197','247975','249584','250065','251798','262519','268568','276021','276129','277801','278691','281969','283649','287126','293200','294310','299937','302065','143381','143555','149695','150273','150274','150275','150276','150277','150278','150279','150280','155456','155731','158959','159836','159837','160333','161669','163705','164267','164283','164284','164285','166031','170550','201143','202725','202823','212783','212784','212785','212786','212787','212788','212789','212790','212791','212792','212793','212794','212795','212796','212797','212798','212799','212800','212801','212802','212803','212804','212805','212806','212807','212808','212809','212810','212811','212812','212813','212814','212815','212816','212817','212818','212819','212820','212821','212822','212823','212824','212825','212826','212827','212828','212829','212830','212831','212832','212833','212834','212835','212836','212837','212838','212839','212840','212841','212842','212843','212844','212845','212846','212847','212848','212849','240065','240159','240160','240161','240162','240163','240164','240448','241396','243030','244240','244787','244904','246259','247439','248618','249062','250176','250915','262099','262724','265304','266830','268466','268562','268794','273826','281253','281425','288495','293275','294792','295470','296193','164812','170635','202720','212932','212933','212934','212935','212936','212937','212938','212939','212940','212941','212942','212943','212944','212945','212946','212947','212948','212949','212950','212951','212952','212953','239677','242387','242388','242674','242886','252015','266778','266779','266780','266781','275806','275807','275808','278703','278704','278705','278706','278707','278708','279800','282401','287797','287798','295363','141798','142896','142897','142898','142899','143161','143369','143669','147758','147875','148133','148135','149488','149489','149491','149492','149493','149494','149495','149496','149497','149498','149499','149500','149501','149502','149503','149504','149505','149506','149507','149508','149713','150790','150848','151220','151223','151435','151436','151697','151795','151816','152003','152511','152515','152516','152527','153093','153101','153106','153332','153410','153411','153575','153576','153597','154456','156631','156847','157460','157461','157462','157463','157464','157465','157466','157505','157506','157724','157725','157729','157731','157733','157734','157735','158270','158409','158491','158526','158769','158905','158913','159029','159030','159061','159377','159423','159474','159475','159476','160021','160116','160159','160198','160335','160458','160513','161085','161261','161644','161686','161798','161956','162196','162199','162230','162340','162341','162342','162343','162344','162345','162346','162409','162417','162449','162495','162658','162659','162772','162852','162858','162894','162935','162936','163049','163329','163332','163680','163987','163988','164078','164601','164739','164796','165012','165497','165605','165645','165939','165959','165983','166095','166127','166444','166673','166871','166918','166924','166926','167038','167042','167062','167092','167117','167184','167409','167427','167574','167780','169114','169159','170050','170691','201292','202578','209372','209373','209374','209375','209376','209377','209378','209379','209380','209381','209382','209383','209384','209385','209386','209387','209388','209389','209390','209391','209392','209393','209394','209395','209396','209397','209398','209399','209400','209401','209402','209403','209404','209405','209406','209407','209408','209409','209410','209411','209412','209413','209414','209415','209416','209417','209418','209419','209420','209421','209422','209423','209424','209425','209426','209427','209428','209429','209430','209431','209432','209433','209434','209435','209436','209437','209438','209439','209440','209441','209442','209443','209444','209445','209446','209447','209448','209449','209450','209451','209452','209453','209454','209455','209456','209457','209458','209459','209460','209461','209462','209463','209464','209465','209466','209467','209468','209469','209470','209471','209472','210505','210506','215348','215467','215871','216103','219717','219721','219722','219747','232441','232442','232443','232685','238111','238494','238725','239107','239157','239458','239459','239652','239750','239813','239947','240346','240451','240548','240767','241218','241477','241478','241479','241849','242098','242099','242155','242239','242241','242248','242249','242250','242252','242253','242270','242298','242366','242583','242888','242889','242890','242906','242971','243012','243026','243063','243099','243100','243101','243138','243165','243235','243448','243489','243772','243773','243774','243974','244139','244202','244264','244339','244817','244856','244950','245034','245144','245145','245209','245239','245240','245258','245332','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245488','245747','245919','245980','246928','246929','247034','247045','247075','247143','247187','247196','247197','247322','247767','247807','247811','247878','248216','248217','248230','248243','248272','248273','248274','248275','248341','248573','248574','248599','248654','249093','249251','249273','249294','249306','249393','249411','249446','249616','249659','249704','249705','249787','249876','249902','250104','250126','250128','250137','250685','250686','250740','250775','250776','250803','250812','250906','250925','251006','251063','251064','251137','251224','251252','251257','251275','251276','251286','251321','251493','251733','251933','252021','252089','253131','253808','253877','254209','254531','254748','255013','255014','255157','255163','255176','255377','255378','255569','255571','255686','255865','256136','256137','256260','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256515','256543','257117','257118','257168','257169','257219','261955','261956','262123','262480','262653','262928','263454','263534','263616','263617','263658','264410','264820','264850','264851','264966','265063','265151','266129','266162','266186','266501','266502','266503','266504','266508','266761','266762','266765','266941','267243','267473','267752','267936','268159','268259','268260','268316','268409','268533','268603','268909','269031','269377','273544','273861','274040','274159','274676','274677','274704','274752','274778','274990','275059','275267','275268','275322','275333','275522','275611','275791','275792','276409','276410','276411','276412','276413','276414','276462','277223','277278','277384','277430','277474','277584','277749','277750','277762','277809','277949','277950','278009','278259','278446','278470','278576','278694','278821','278936','279013','279669','279676','279705','279745','280386','280547','280805','280943','280944','280945','280962','281148','281224','281230','282164','282165','282199','282200','282893','282894','283479','283602','283603','283659','283791','283793','284136','284279','284321','284322','284323','284508','284550','284578','284729','284730','284823','284860','284902','284913','284948','284955','285336','285379','285555','285557','285558','285575','285672','286014','286362','286661','286814','286912','287770','287771','287985','288574','289228','289229','289231','289232','289233','289234','289235','289236','289238','289246','289247','289248','289249','289250','289251','289252','289253','289427','289428','289429','289430','289431','289432','289433','289434','289466','291625','291994','292034','292530','293210','293392','293484','294250','294273','294670','294718','294732','294733','294734','294735','294737','294746','294750','294805','294811','294847','295376','295572','295595','297120','297153','297191','297467','297758','297859','298015','298169','298244','298411','298572','299107','299122','299211','299454','299504','299549','299722','299794','299798','299799','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299995','300061','300304','300305','300306','301049','301807','301808','301809','301810','301811','301812','301855','301864','301951','302003','302004','302005','302006','302007','302008','302009','302010','302011','302012','302013','302014','302015','302016','302017','302018','302019','302020','302021','302022','302023','302024','302025','302026','302027','302028','302029','302030','302031','302032','302033','302034','302035','302036','302037','302038','302039','302040','302041','302042','302043','302044','302045','302046','302047','302048','302061','302063','303906','303908','303934','304024','151731','170662','215938','245839','249186','151114','159659','160107','160882','161330','163719','167131','167132','167133','167134','167135','167752','215561','239892','240457','240458','240459','240460','240462','240463','240464','241332','241739','242218','242681','243484','244004','244005','244006','244007','244008','244009','244010','244011','244012','244013','244014','244015','244016','244017','244018','244019','244020','244021','244022','245066','245067','245068','245352','245661','245925','246422','246628','247257','247323','247595','247617','247618','248056','248088','249011','249504','249789','249840','250212','250797','251437','251438','251806','253864','253871','254343','254350','254351','254759','254987','255570','255894','256671','256672','256673','257063','262516','262518','263088','263089','263090','263490','263715','265245','266804','267653','268319','269303','273512','273685','273717','273718','276651','277643','277986','277987','277988','277989','277990','277991','277992','277993','277994','278454','279126','279127','279128','279129','279767','279768','280371','280372','280735','283143','284519','284832','285919','286261','286394','286396','286660','287384','288271','288315','288843','291985','292511','293213','294222','297416','297545','297546','297837','298033','299102','299419','299561','299734','299769','300359','300581','300945','302337','303977','154279','158954','161563','163181','164316','238738','242167','242168','242169','242170','242171','242172','244962','245795','248941','249025','249505','250863','251691','256922','256923','267416','268736','268771','269012','273766','273853','275068','275099','275100','277695','277696','277697','278085','278086','281590','281598','281654','281655','281656','282558','282798','282799','282800','282801','283339','283340','283351','283674','284142','285137','285138','285139','285378','286046','287136','287137','288417','288441','288556','291982','292305','292319','292320','292730','292731','292751','294351','296254','297214','297644','299930','299931','300257','300258','300310','300376','300944','151015','157632','162529','242952','245711','245712','245713','249913','249914','250096','266841','266958','268847','275028','275029','276418','277034','277036','277044','280509','281904','288605','292037','294291','298388','300946','300947','288659','292014','299086','291883','299349') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('141798','141891','142230','142851','142896','142897','142898','142899','143161','143239','143274','143369','143381','143555','143669','143691','143692','143931','144205','144287','144975','144976','144977','144992','146695','146701','147224','147758','147875','147976','148060','148133','148135','148164','148165','148611','148991','148992','148993','148994','148995','148996','148997','148998','148999','149000','149001','149488','149489','149491','149492','149493','149494','149495','149496','149497','149498','149499','149500','149501','149502','149503','149504','149505','149506','149507','149508','149695','149707','149708','149713','149762','149763','149764','149765','149766','149767','149768','149769','149770','149771','149772','149773','149774','149775','149776','149777','149778','149779','150150','150151','150159','150160','150273','150274','150275','150276','150277','150278','150279','150280','150464','150670','150772','150790','150841','150848','151015','151036','151042','151043','151059','151060','151114','151220','151223','151435','151436','151456','151635','151637','151638','151639','151642','151697','151731','151795','151816','151850','151972','151993','152003','152511','152515','152516','152527','153093','153101','153106','153107','153332','153410','153411','153575','153576','153597','153640','153644','153891','153923','154279','154322','154425','154456','154772','154789','155060','155061','155265','155266','155267','155268','155269','155270','155456','155477','155731','155822','155858','155859','156284','156285','156286','156631','156823','156824','156825','156826','156827','156828','156829','156830','156831','156847','157265','157408','157460','157461','157462','157463','157464','157465','157466','157503','157505','157506','157632','157709','157724','157725','157729','157731','157733','157734','157735','157908','158015','158016','158118','158148','158149','158186','158217','158270','158340','158377','158409','158445','158491','158497','158526','158603','158606','158629','158657','158660','158759','158769','158771','158785','158829','158830','158831','158905','158913','158954','158958','158959','158960','159009','159010','159014','159029','159030','159061','159095','159121','159227','159296','159377','159423','159424','159450','159474','159475','159476','159481','159527','159528','159529','159632','159659','159698','159705','159750','159831','159833','159834','159836','159837','159838','159839','159840','159841','159869','159912','160021','160036','160107','160116','160117','160159','160180','160198','160236','160237','160304','160333','160335','160458','160513','160605','160730','160820','160839','160849','160851','160882','160894','160895','161042','161085','161102','161103','161107','161162','161192','161261','161321','161330','161387','161421','161438','161563','161644','161669','161686','161759','161768','161797','161798','161885','161886','161897','161956','162149','162176','162196','162199','162230','162257','162340','162341','162342','162343','162344','162345','162346','162366','162409','162417','162448','162449','162495','162529','162658','162659','162766','162772','162852','162858','162894','162904','162905','162935','162936','163042','163047','163049','163086','163103','163108','163109','163110','163111','163112','163113','163181','163324','163329','163332','163544','163619','163621','163661','163680','163705','163718','163719','163725','163751','163793','163800','163803','163815','163831','163895','163929','163987','163988','164078','164113','164153','164154','164174','164175','164176','164177','164263','164267','164283','164284','164285','164316','164591','164601','164684','164733','164739','164796','164812','164818','164981','165005','165012','165029','165080','165188','165189','165198','165199','165200','165201','165202','165203','165204','165205','165218','165287','165448','165497','165529','165538','165595','165605','165645','165815','165849','165914','165939','165959','165983','166031','166095','166127','166319','166322','166444','166445','166510','166546','166561','166597','166673','166871','166918','166921','166924','166926','166938','167038','167042','167062','167072','167092','167106','167117','167128','167131','167132','167133','167134','167135','167148','167149','167150','167151','167152','167184','167212','167273','167274','167359','167409','167427','167433','167434','167445','167531','167574','167627','167672','167699','167752','167780','167833','167842','167884','167926','167991','168064','168116','168218','168267','168268','168340','168398','169114','169159','169268','170002','170024','170050','170072','170077','170078','170205','170285','170374','170413','170414','170415','170530','170531','170532','170533','170534','170535','170536','170537','170538','170539','170540','170541','170542','170543','170550','170597','170598','170635','170662','170691','185916','201141','201143','201144','201181','201182','201183','201184','201185','201190','201191','201192','201292','202578','202694','202720','202725','202769','202823','202841','206109','206110','206111','206112','206113','206114','206115','206116','206117','206118','206119','206120','206121','206122','206123','206124','206125','206126','206127','206128','206129','206130','206131','206132','206133','206134','206135','206136','206137','206138','206139','206140','206141','206142','206143','206144','206145','206146','206147','206148','206149','206150','206151','206152','206153','206154','206155','206156','206157','206158','206159','206160','206161','206162','206163','206164','206165','206166','206167','206168','206169','206170','206171','206172','206173','206174','206175','206176','206177','206178','206179','206180','206181','206182','206183','206184','206185','206186','206187','206188','206189','206190','206191','206192','206193','206194','206195','206196','206197','206198','206199','206200','206201','206202','206203','206204','206205','206206','206207','206208','206209','206210','206211','206212','206213','206214','206215','206216','206217','206218','206219','206220','206221','206222','206223','206224','206225','206226','206227','206228','206229','206230','206231','206232','206233','206234','206235','206236','206237','206238','206239','206240','206241','206242','206243','206244','206245','206246','206247','206248','206249','206250','206251','206252','206253','206254','206255','206256','206257','206258','206259','206260','206261','206262','206263','206264','206265','206266','206267','206268','206269','206270','206271','206272','206273','206274','206275','206276','206277','206278','206279','206280','206281','206282','206283','206284','206285','206286','206287','206288','206289','206290','206291','206292','206293','206294','206295','206296','206297','206298','206299','206300','206301','206302','206303','206304','206305','206306','206307','206308','206309','206310','206311','206312','206313','206314','206315','206316','206317','206318','206319','206320','206321','206322','206323','206324','206325','206326','206327','206328','206329','206330','206331','206332','206333','206334','206335','206336','206337','206338','206339','206340','206341','206342','206343','206344','206345','206346','206347','206348','206349','206350','206351','206352','206353','206354','206355','206356','206357','206358','209372','209373','209374','209375','209376','209377','209378','209379','209380','209381','209382','209383','209384','209385','209386','209387','209388','209389','209390','209391','209392','209393','209394','209395','209396','209397','209398','209399','209400','209401','209402','209403','209404','209405','209406','209407','209408','209409','209410','209411','209412','209413','209414','209415','209416','209417','209418','209419','209420','209421','209422','209423','209424','209425','209426','209427','209428','209429','209430','209431','209432','209433','209434','209435','209436','209437','209438','209439','209440','209441','209442','209443','209444','209445','209446','209447','209448','209449','209450','209451','209452','209453','209454','209455','209456','209457','209458','209459','209460','209461','209462','209463','209464','209465','209466','209467','209468','209469','209470','209471','209472','210493','210496','210497','210498','210499','210500','210501','210502','210503','210505','210506','210775','210776','210777','210778','210779','210780','210781','210782','210783','210784','210785','210786','210787','210788','210789','210790','210791','210792','210793','210794','210795','210796','210797','210798','210799','210800','210801','210802','210803','210804','210805','210806','210807','210808','210809','210810','210811','210812','210813','210814','210815','210816','210817','210818','210819','210820','210821','210822','210823','210824','210825','210826','210827','210828','210829','210830','210831','210832','210833','210834','210835','210836','210837','210838','210839','210840','210841','210842','210843','210844','210845','210846','210970','210982','210983','211008','211820','211821','211822','211823','211824','211825','211826','211827','211828','211829','211830','211831','211832','211833','211834','211835','211836','211837','211838','211839','211840','211841','211842','211843','211844','211845','211846','211847','211848','211849','211850','211851','211852','211853','211854','211855','211856','211857','211858','211859','211860','211861','211862','211863','211864','211865','211866','211867','211868','211869','211870','211871','211872','211873','211874','211875','211876','211974','211975','211976','211977','211978','211979','211980','211981','211982','211983','211984','211985','212783','212784','212785','212786','212787','212788','212789','212790','212791','212792','212793','212794','212795','212796','212797','212798','212799','212800','212801','212802','212803','212804','212805','212806','212807','212808','212809','212810','212811','212812','212813','212814','212815','212816','212817','212818','212819','212820','212821','212822','212823','212824','212825','212826','212827','212828','212829','212830','212831','212832','212833','212834','212835','212836','212837','212838','212839','212840','212841','212842','212843','212844','212845','212846','212847','212848','212849','212932','212933','212934','212935','212936','212937','212938','212939','212940','212941','212942','212943','212944','212945','212946','212947','212948','212949','212950','212951','212952','212953','215216','215250','215273','215348','215415','215465','215466','215467','215542','215561','215720','215795','215847','215871','215896','215938','216001','216002','216046','216091','216093','216103','216104','219717','219721','219722','219747','219754','219761','232404','232421','232441','232442','232443','232461','232462','232561','232595','232598','232620','232641','232648','232685','232694','232780','238111','238140','238267','238445','238494','238556','238590','238662','238715','238725','238738','239106','239107','239156','239157','239207','239222','239248','239316','239317','239458','239459','239652','239677','239750','239813','239875','239892','239947','239951','239971','239992','240004','240065','240097','240098','240137','240159','240160','240161','240162','240163','240164','240195','240196','240244','240282','240285','240288','240292','240313','240346','240348','240349','240354','240356','240395','240419','240433','240445','240448','240451','240453','240457','240458','240459','240460','240462','240463','240464','240465','240466','240504','240507','240521','240548','240563','240573','240574','240575','240656','240717','240744','240767','240776','240815','240816','240817','240819','240830','240833','240835','240837','240838','240898','240943','240944','240947','240963','240968','241061','241218','241279','241310','241332','241338','241339','241395','241396','241468','241469','241477','241478','241479','241516','241529','241538','241672','241692','241722','241724','241731','241739','241764','241849','241978','242071','242098','242099','242155','242159','242160','242161','242162','242163','242167','242168','242169','242170','242171','242172','242218','242230','242239','242241','242248','242249','242250','242252','242253','242270','242298','242366','242382','242387','242388','242392','242429','242508','242515','242516','242583','242674','242681','242726','242785','242813','242814','242820','242886','242888','242889','242890','242906','242952','242971','243012','243013','243026','243030','243063','243099','243100','243101','243113','243138','243145','243165','243235','243287','243419','243426','243448','243463','243484','243489','243539','243601','243679','243680','243772','243773','243774','243835','243836','243974','244004','244005','244006','244007','244008','244009','244010','244011','244012','244013','244014','244015','244016','244017','244018','244019','244020','244021','244022','244026','244049','244050','244139','244202','244210','244240','244263','244264','244288','244291','244300','244339','244352','244473','244548','244729','244750','244787','244817','244856','244862','244904','244950','244962','245034','245066','245067','245068','245103','245144','245145','245203','245209','245228','245239','245240','245255','245258','245307','245308','245332','245352','245384','245391','245392','245394','245395','245396','245397','245398','245399','245400','245401','245402','245403','245404','245405','245406','245488','245489','245661','245711','245712','245713','245747','245770','245792','245795','245839','245847','245856','245919','245925','245980','246021','246022','246110','246170','246197','246198','246257','246259','246374','246395','246422','246467','246567','246628','246668','246669','246670','246671','246672','246673','246674','246681','246701','246715','246725','246726','246727','246728','246729','246731','246732','246759','246824','246914','246928','246929','246947','246969','247000','247034','247045','247075','247143','247186','247187','247196','247197','247245','247257','247259','247292','247295','247322','247323','247358','247439','247451','247565','247587','247595','247617','247618','247753','247767','247807','247811','247878','247911','247913','247975','248022','248056','248088','248090','248140','248210','248216','248217','248230','248243','248272','248273','248274','248275','248295','248327','248331','248341','248360','248403','248404','248405','248406','248441','248485','248573','248574','248599','248618','248620','248652','248654','248659','248718','248736','248768','248784','248791','248849','248850','248851','248852','248866','248941','249011','249025','249062','249093','249116','249149','249186','249196','249234','249251','249259','249273','249294','249306','249344','249390','249393','249411','249446','249504','249505','249537','249584','249587','249616','249659','249666','249704','249705','249714','249762','249787','249789','249822','249840','249850','249876','249895','249902','249913','249914','250044','250065','250096','250104','250126','250128','250137','250149','250176','250212','250501','250502','250503','250504','250505','250509','250611','250620','250684','250685','250686','250740','250775','250776','250796','250797','250803','250812','250849','250863','250890','250903','250906','250915','250918','250925','251006','251063','251064','251080','251137','251154','251224','251252','251257','251267','251275','251276','251286','251321','251437','251438','251493','251498','251510','251553','251691','251717','251733','251798','251806','251931','251933','251950','251979','252015','252021','252047','252077','252089','252110','252153','252240','253131','253263','253483','253633','253739','253768','253808','253852','253853','253855','253864','253871','253877','254209','254213','254343','254350','254351','254380','254382','254436','254439','254454','254531','254616','254646','254748','254759','254768','254821','254883','254896','254897','254898','254899','254945','254970','254985','254986','254987','255003','255013','255014','255106','255117','255118','255157','255163','255176','255181','255277','255361','255377','255378','255471','255504','255569','255570','255571','255596','255686','255865','255894','255942','255943','255944','255945','255946','255947','256097','256098','256104','256136','256137','256196','256260','256287','256288','256289','256290','256291','256292','256293','256294','256295','256296','256297','256298','256441','256481','256515','256543','256616','256658','256671','256672','256673','256724','256842','256876','256922','256923','257060','257061','257063','257117','257118','257168','257169','257177','257219','261710','261711','261756','261773','261955','261956','262099','262108','262123','262188','262313','262345','262346','262480','262516','262518','262519','262653','262724','262857','262928','262939','263088','263089','263090','263187','263454','263490','263508','263534','263585','263611','263612','263616','263617','263658','263681','263715','264350','264351','264359','264363','264410','264455','264491','264649','264820','264850','264851','264882','264910','264951','264962','264964','264966','265060','265063','265064','265080','265081','265095','265097','265099','265151','265227','265245','265304','265335','265366','265404','265413','265414','265523','265540','265658','265695','265709','265784','265837','265838','265845','265850','265851','265867','265874','265970','266003','266036','266038','266040','266041','266078','266090','266096','266118','266129','266162','266178','266186','266268','266278','266354','266396','266415','266429','266460','266501','266502','266503','266504','266508','266566','266612','266757','266761','266762','266765','266778','266779','266780','266781','266804','266825','266830','266841','266903','266941','266958','266974','266982','267054','267108','267227','267243','267353','267412','267416','267459','267473','267480','267528','267653','267752','267757','267868','267936','268011','268012','268013','268014','268015','268016','268017','268018','268019','268020','268021','268022','268023','268024','268025','268026','268027','268029','268030','268031','268032','268033','268034','268035','268036','268052','268081','268112','268127','268159','268223','268259','268260','268316','268319','268347','268409','268466','268501','268502','268503','268506','268533','268562','268568','268603','268696','268736','268771','268783','268784','268794','268847','268859','268861','268909','269012','269017','269031','269032','269038','269049','269149','269152','269153','269242','269303','269346','269347','269371','269377','269459','269462','269463','269464','269465','269466','269483','269586','273306','273307','273308','273361','273403','273404','273503','273512','273544','273560','273575','273673','273676','273677','273685','273717','273718','273766','273787','273798','273826','273852','273853','273861','273890','273915','273937','273949','273961','274040','274159','274324','274387','274388','274389','274390','274391','274392','274393','274394','274395','274437','274438','274444','274445','274451','274452','274453','274454','274455','274456','274492','274510','274511','274515','274649','274650','274676','274677','274704','274752','274777','274778','274783','274814','274829','274861','274862','274990','275003','275028','275029','275059','275068','275099','275100','275135','275137','275267','275268','275322','275333','275353','275396','275399','275485','275522','275611','275614','275625','275735','275758','275762','275791','275792','275806','275807','275808','276021','276066','276129','276135','276136','276138','276139','276140','276141','276246','276409','276410','276411','276412','276413','276414','276418','276434','276462','276499','276529','276564','276594','276598','276651','276653','276660','276668','276669','276697','276763','276769','276810','277034','277036','277044','277068','277223','277265','277266','277278','277291','277293','277304','277338','277339','277342','277384','277422','277430','277463','277474','277511','277584','277643','277687','277695','277696','277697','277720','277721','277722','277723','277724','277725','277726','277727','277729','277730','277731','277749','277750','277762','277798','277801','277808','277809','277949','277950','277967','277980','277981','277982','277983','277984','277985','277986','277987','277988','277989','277990','277991','277992','277993','277994','278009','278085','278086','278191','278223','278259','278369','278370','278446','278454','278464','278470','278475','278506','278519','278576','278615','278691','278693','278694','278703','278704','278705','278706','278707','278708','278734','278743','278760','278768','278771','278815','278821','278834','278928','278936','279013','279073','279126','279127','279128','279129','279194','279262','279267','279268','279296','279377','279455','279484','279666','279669','279676','279690','279694','279705','279724','279725','279732','279733','279745','279767','279768','279800','279814','280283','280350','280366','280367','280371','280372','280378','280386','280442','280443','280509','280531','280547','280589','280709','280735','280765','280766','280767','280768','280805','280819','280862','280881','280920','280943','280944','280945','280962','280990','281028','281072','281148','281178','281194','281223','281224','281230','281253','281388','281396','281400','281402','281403','281408','281425','281584','281590','281598','281627','281628','281654','281655','281656','281768','281904','281969','282030','282112','282164','282165','282170','282174','282177','282199','282200','282366','282401','282444','282481','282545','282558','282768','282798','282799','282800','282801','282811','282839','282893','282894','282908','283065','283110','283143','283339','283340','283341','283345','283351','283479','283480','283602','283603','283604','283606','283649','283659','283674','283733','283774','283791','283793','284134','284136','284142','284149','284162','284184','284279','284280','284283','284321','284322','284323','284441','284508','284519','284550','284564','284578','284579','284625','284729','284730','284823','284832','284843','284860','284902','284907','284913','284948','284955','285054','285073','285076','285121','285137','285138','285139','285140','285141','285183','285185','285223','285333','285336','285375','285376','285378','285379','285386','285431','285531','285555','285557','285558','285575','285597','285672','285725','285739','285829','285830','285898','285914','285919','285968','285984','286014','286046','286113','286124','286127','286261','286281','286362','286373','286394','286396','286444','286603','286626','286647','286660','286661','286814','286912','286939','286945','286947','287126','287136','287137','287173','287197','287198','287202','287384','287504','287505','287770','287771','287797','287798','287799','287800','287801','287802','287803','287804','287805','287806','287807','287808','287809','287810','287811','287812','287813','287814','287815','287816','287817','287818','287819','287820','287821','287822','287823','287824','287825','287826','287827','287828','287829','287830','287831','287832','287833','287834','287835','287836','287837','287838','287839','287840','287841','287842','287843','287844','287845','287846','287847','287848','287849','287850','287851','287852','287853','287854','287855','287856','287857','287858','287859','287860','287861','287862','287863','287864','287865','287866','287867','287868','287869','287870','287871','287872','287873','287874','287875','287876','287877','287878','287879','287880','287881','287882','287883','287884','287885','287886','287887','287888','287889','287890','287891','287892','287893','287894','287895','287896','287897','287898','287899','287900','287901','287902','287903','287904','287905','287906','287907','287908','287909','287910','287911','287912','287913','287914','287915','287916','287917','287918','287919','287920','287921','287922','287923','287924','287925','287926','287927','287928','287929','287930','287931','287932','287933','287934','287935','287936','287937','287938','287939','287940','287941','287942','287943','287944','287945','287946','287947','287948','287949','287950','287951','287952','287953','287954','287955','287956','287957','287958','287959','287960','287961','287962','287963','287964','287965','287966','287967','287985','287993','288004','288097','288099','288101','288109','288127','288205','288232','288259','288271','288293','288307','288315','288355','288417','288441','288480','288493','288495','288556','288574','288605','288625','288659','288843','288869','288983','289228','289229','289231','289232','289233','289234','289235','289236','289238','289246','289247','289248','289249','289250','289251','289252','289253','289261','289427','289428','289429','289430','289431','289432','289433','289434','289466','291625','291701','291825','291869','291877','291883','291885','291982','291985','291989','291990','291991','291992','291994','291995','291999','292001','292003','292004','292006','292014','292034','292037','292224','292305','292319','292320','292386','292498','292503','292511','292530','292716','292730','292731','292735','292736','292737','292738','292739','292751','292803','292846','293200','293201','293210','293213','293275','293387','293392','293484','293525','293544','294072','294221','294222','294228','294237','294250','294261','294267','294273','294282','294289','294291','294310','294351','294494','294496','294601','294606','294670','294718','294732','294733','294734','294735','294737','294746','294750','294792','294801','294805','294811','294847','295338','295363','295376','295433','295457','295470','295494','295512','295514','295517','295572','295595','295622','295751','295836','295995','296193','296223','296237','296242','296254','297120','297153','297191','297196','297214','297416','297454','297455','297467','297545','297546','297551','297558','297590','297591','297602','297630','297644','297646','297758','297794','297837','297859','297906','297957','297979','298015','298029','298033','298057','298085','298137','298138','298139','298158','298169','298171','298242','298244','298282','298334','298373','298388','298411','298453','298522','298528','298572','298579','298590','298595','298601','299048','299086','299102','299107','299122','299176','299192','299211','299349','299373','299403','299419','299448','299454','299504','299549','299561','299680','299682','299722','299734','299769','299794','299798','299799','299877','299906','299919','299930','299931','299937','299965','299966','299967','299968','299969','299970','299971','299972','299973','299974','299975','299976','299995','300031','300061','300072','300209','300257','300258','300304','300305','300306','300310','300328','300359','300376','300578','300581','300610','300639','300926','300927','300944','300945','300946','300947','301047','301048','301049','301067','301806','301807','301808','301809','301810','301811','301812','301855','301864','301881','301895','301951','301986','302003','302004','302005','302006','302007','302008','302009','302010','302011','302012','302013','302014','302015','302016','302017','302018','302019','302020','302021','302022','302023','302024','302025','302026','302027','302028','302029','302030','302031','302032','302033','302034','302035','302036','302037','302038','302039','302040','302041','302042','302043','302044','302045','302046','302047','302048','302061','302063','302065','302107','302146','302171','302224','302271','302285','302291','302292','302293','302295','302301','302337','302350','302352','303804','303904','303906','303908','303926','303927','303934','303945','303977','304024') GROUP BY `manuf` ORDER BY `manuf` ASC