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 ('41','59','186','197','239','245','280','282','295','304','157708','232436','232689','242634','242825','248199','249188','249624','15','46','141226','156817','156818','156819','156820','156821','156822','162929','163035','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681','153426','153619','153629','154408','154731','155271','155272','155273','155274','155275','155302','155303','155657','157261','157263','157264','157266','157267','157587','157961','158269','158654','159019','159255','159772','160145','161905','161979','161980','163868','164286','164545','164546','164959','166251','166714','166993','167587','238661','238966','239217','239357','239719','239742','240353','241126','241282','241531','242433','244269','244781','245495','247119','247674','249263','249827','250233','251205','251759','253875','254769','255107','255908','256178','256179','256449','256500','256541','262946','263550','263704','264648','266219','266393','266417','267090','267836','268146','269124','269164','273456','273534','274278','274948','276416','277953','280956','281190','281690','284185','288275','288732','289221','291708','291709','291855','294611','294939','295426','295689','298165','298486','299143','300057','301002','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289','303803','303883','303901','303902','303903','304020','304029','153585','158541','159079','160336','163844','164026','164551','164627','164646','164754','166243','168375','239543','239707','239732','239998','240088','241429','242426','242947','244096','244197','244550','245894','246953','248714','248880','249064','249746','250832','264657','264658','264892','276113','281423','282670','292061','296271','298387','299548','300935','303844','157787','157788','157790','164253','243917','244429','288310','292860','153633','153946','153947','154775','154874','155133','155723','157428','157429','157430','157431','157434','157435','157623','157843','157968','158100','158388','158397','158399','158631','158640','158875','158876','158912','159452','159646','159853','160283','160537','160833','160858','160949','161346','161509','161601','161617','161954','162081','162144','162255','162268','162686','162866','162867','162902','162920','163039','163344','163834','163882','163955','164499','164645','164858','164899','164964','165503','165557','165648','165710','165754','166433','167036','167079','167081','167432','167551','167819','168381','232520','238184','239127','239191','239192','239746','240526','240529','240629','240812','241076','241155','241406','241410','242324','243497','243533','244347','244760','244972','245002','245130','245167','245564','245692','245727','245757','246174','246236','246565','246717','246773','246899','247011','247161','247863','248000','248342','248695','248729','249173','249324','250195','250267','250640','250720','251341','251763','251834','252092','253630','253780','253825','254891','255224','255393','255997','256096','256099','256506','256510','256966','256972','257174','261800','261945','261947','262789','263546','264798','264853','265144','265375','265476','266116','266544','266915','266983','267214','267330','267941','268049','273964','274276','274624','275056','275093','275818','277673','277759','277800','278212','278476','278889','278927','281712','282838','283000','283214','285762','286013','286061','286065','286795','288010','291747','293224','293394','293452','294754','295163','295663','295665','295690','295692','295774','296284','297013','297457','298133','298389','299449','299559','299678','299711','300235','300552','301033','302195','153653','154952','157436','160542','162227','165348','166092','166485','167412','167773','168079','168366','240592','243948','244187','244188','244229','244230','244232','244233','244234','244235','244236','244505','244565','247700','247937','249034','250079','253488','253489','253490','253491','254710','256507','256539','256705','257221','262587','262830','263104','264437','264441','264830','265119','265193','265350','265352','265386','265438','265762','266284','267215','267481','267690','268047','268048','268359','268563','268881','273398','273918','273919','274448','274720','274912','275053','275248','275500','275604','275783','277340','277345','277346','278063','278640','279367','279692','280410','280917','281255','281898','283229','284228','284736','285172','285612','286006','286826','287124','288122','291753','292362','292527','292576','292798','294665','297327','297860','298281','298369','298481','299105','299857','300276','302347','161045','161046','161062','165514','168053','168054','219755','238380','238665','240327','242369','242457','242969','243081','243475','243476','243477','243478','243479','243480','243481','244228','244954','250912','250913','251596','253252','253253','253254','254721','266657','267522','267523','267524','267525','267526','267527','267992','273696','273916','275001','275617','275626','277069','277248','277343','277344','278759','281760','281764','284209','284356','284499','284596','285738','288261','291711','292032','292379','292753','293261','293375','293549','293550','294998','299059','302132','250680','279298','285442','300315','300337','300413','300414','303935','160767','160769','240075','245668','247544','249612','253504','274855','287128') 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 ('141226','153426','153585','153619','153629','153633','153653','153773','153946','153947','154231','154408','154571','154661','154679','154730','154731','154732','154775','154791','154874','154952','155133','155271','155272','155273','155274','155275','155302','155303','155367','155657','155723','156817','156818','156819','156820','156821','156822','156959','156960','157261','157263','157264','157266','157267','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157433','157434','157435','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157583','157587','157623','157665','157708','157787','157788','157790','157843','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','157961','157968','158100','158269','158323','158339','158341','158388','158397','158399','158485','158486','158541','158631','158640','158654','158685','158757','158810','158811','158813','158875','158876','158912','159019','159079','159097','159098','159253','159255','159259','159340','159341','159369','159452','159552','159646','159772','159853','159916','160098','160132','160145','160157','160158','160283','160316','160336','160384','160537','160542','160767','160769','160813','160833','160858','160949','161045','161046','161062','161137','161182','161326','161327','161346','161423','161461','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161509','161528','161590','161601','161617','161809','161905','161933','161934','161935','161949','161954','161979','161980','162003','162029','162030','162031','162032','162080','162081','162144','162227','162255','162268','162379','162383','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','162672','162673','162686','162866','162867','162902','162920','162929','163035','163039','163344','163542','163607','163694','163695','163834','163844','163868','163882','163955','164026','164070','164155','164253','164271','164286','164499','164519','164545','164546','164551','164627','164645','164646','164754','164771','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164858','164899','164933','164959','164964','165025','165058','165094','165176','165180','165195','165331','165332','165348','165363','165379','165395','165503','165514','165557','165574','165648','165652','165657','165675','165694','165710','165731','165754','165840','165841','165853','165969','166016','166086','166092','166198','166242','166243','166251','166284','166324','166344','166422','166433','166471','166485','166611','166642','166701','166714','166735','166835','166883','166983','166993','167036','167079','167081','167118','167231','167245','167412','167432','167551','167587','167773','167790','167819','167900','168002','168031','168032','168053','168054','168079','168084','168127','168128','168152','168219','168333','168366','168375','168381','219755','232436','232444','232445','232520','232689','232720','238025','238042','238179','238184','238380','238661','238665','238809','238966','239110','239111','239112','239113','239114','239115','239116','239117','239127','239191','239192','239217','239310','239356','239357','239453','239543','239578','239616','239707','239713','239714','239719','239732','239742','239743','239746','239818','239835','239987','239998','239999','240009','240051','240075','240088','240114','240200','240286','240307','240327','240353','240526','240529','240586','240592','240629','240786','240787','240812','240936','240989','240990','240991','240992','241060','241076','241126','241155','241161','241282','241383','241406','241410','241429','241531','241734','241735','241787','241798','241850','241851','241864','241895','241962','241963','241964','241965','242101','242324','242334','242341','242369','242426','242433','242457','242489','242589','242603','242634','242706','242825','242904','242927','242947','242969','243081','243186','243211','243316','243436','243475','243476','243477','243478','243479','243480','243481','243497','243533','243724','243725','243744','243829','243916','243917','243948','243949','244096','244187','244188','244195','244197','244223','244224','244228','244229','244230','244232','244233','244234','244235','244236','244244','244269','244347','244429','244505','244538','244550','244554','244565','244591','244625','244718','244755','244760','244781','244798','244861','244865','244954','244972','245002','245130','245167','245495','245534','245564','245668','245692','245727','245751','245757','245811','245894','245924','246001','246002','246129','246138','246172','246174','246176','246236','246285','246309','246565','246679','246717','246719','246756','246773','246857','246899','246901','246934','246953','246962','247011','247107','247119','247161','247442','247543','247544','247674','247700','247732','247863','247930','247937','247940','248000','248081','248199','248252','248342','248421','248440','248533','248695','248714','248729','248761','248809','248880','248954','249001','249002','249003','249004','249005','249034','249064','249076','249103','249173','249188','249263','249324','249354','249392','249612','249624','249709','249746','249764','249827','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250079','250098','250195','250233','250244','250245','250246','250267','250353','250595','250640','250677','250680','250720','250832','250869','250912','250913','251175','251205','251217','251218','251219','251220','251288','251341','251463','251523','251548','251596','251677','251759','251763','251817','251834','252053','252092','253021','253022','253023','253209','253252','253253','253254','253373','253376','253417','253467','253488','253489','253490','253491','253504','253511','253627','253630','253736','253738','253762','253780','253791','253825','253846','253851','253865','253875','253902','254196','254326','254378','254379','254394','254445','254447','254710','254712','254721','254769','254771','254891','254937','255107','255161','255216','255224','255306','255393','255458','255677','255807','255838','255850','255908','255997','256096','256099','256178','256179','256219','256223','256247','256267','256272','256449','256500','256506','256507','256508','256510','256539','256541','256705','256771','256782','256783','256784','256840','256966','256972','257162','257174','257184','257221','261757','261777','261794','261800','261945','261947','262005','262007','262011','262182','262383','262576','262587','262754','262781','262789','262823','262830','262946','263061','263104','263514','263546','263550','263629','263660','263699','263704','264437','264441','264449','264648','264657','264658','264798','264830','264853','264866','264892','265051','265079','265119','265144','265152','265158','265164','265192','265193','265194','265195','265270','265336','265350','265352','265353','265356','265375','265386','265418','265421','265438','265468','265476','265536','265555','265559','265762','265870','265889','265892','265899','265915','265948','266095','266116','266138','266139','266219','266245','266274','266284','266322','266393','266417','266544','266623','266657','266684','266685','266686','266710','266755','266756','266864','266880','266915','266936','266983','267090','267103','267178','267214','267215','267251','267289','267325','267330','267481','267522','267523','267524','267525','267526','267527','267682','267690','267701','267703','267836','267941','267992','268000','268047','268048','268049','268066','268087','268146','268217','268234','268265','268291','268359','268563','268600','268769','268881','269124','269164','269402','269441','269549','269589','269597','269598','273335','273398','273456','273466','273521','273522','273534','273613','273695','273696','273724','273831','273916','273918','273919','273964','274276','274278','274298','274411','274448','274593','274624','274629','274720','274786','274790','274792','274842','274855','274891','274911','274912','274921','274948','274991','275001','275053','275056','275093','275229','275236','275248','275500','275600','275604','275617','275626','275655','275679','275783','275818','275836','276113','276130','276145','276250','276289','276295','276416','276438','276532','276578','276768','276780','276807','276941','276942','277014','277069','277174','277248','277306','277333','277340','277343','277344','277345','277346','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277673','277689','277759','277800','277830','277873','277953','278063','278105','278112','278114','278134','278135','278142','278157','278188','278212','278458','278468','278476','278477','278533','278599','278600','278601','278640','278744','278759','278871','278889','278927','279017','279061','279065','279074','279298','279299','279367','279404','279600','279692','279698','279756','279801','279825','280403','280410','280453','280538','280603','280604','280778','280780','280867','280870','280880','280917','280930','280931','280956','280987','281011','281112','281190','281255','281321','281330','281423','281494','281609','281685','281690','281712','281741','281760','281764','281859','281898','282144','282196','282356','282421','282492','282555','282670','282777','282838','282912','282921','282923','282924','283000','283058','283059','283214','283229','283330','283494','283792','284152','284153','284185','284209','284228','284284','284307','284356','284416','284499','284562','284596','284619','284736','284866','284994','285035','285058','285172','285182','285244','285302','285338','285441','285442','285514','285612','285738','285762','285766','286006','286013','286061','286065','286071','286322','286323','286795','286826','286964','287124','287128','287130','287506','287780','287969','288010','288122','288197','288198','288199','288200','288201','288212','288260','288261','288275','288310','288317','288531','288573','288611','288664','288709','288718','288719','288732','288755','288994','289221','289257','289400','289495','289496','289503','291708','291709','291711','291746','291747','291753','291832','291855','291857','291859','291860','291956','292032','292061','292225','292245','292304','292321','292322','292362','292379','292389','292527','292576','292718','292753','292779','292798','292806','292860','292873','292874','293224','293261','293375','293393','293394','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293452','293549','293550','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294227','294318','294358','294360','294502','294588','294603','294604','294611','294634','294635','294665','294754','294755','294939','294973','294998','295163','295364','295365','295366','295406','295426','295487','295645','295662','295663','295665','295689','295690','295692','295732','295774','295801','295830','296234','296271','296276','296278','296284','297012','297013','297138','297327','297429','297457','297585','297589','297849','297860','297921','297974','297975','297978','298056','298133','298165','298208','298224','298281','298287','298288','298365','298369','298387','298389','298478','298481','298486','298511','299030','299059','299105','299143','299191','299234','299376','299409','299439','299443','299449','299493','299548','299559','299655','299678','299711','299755','299756','299857','299934','299959','300022','300038','300057','300235','300259','300260','300276','300315','300337','300413','300414','300426','300434','300515','300552','300620','300631','300681','300935','301002','301033','302050','302132','302195','302204','302263','302264','302289','302347','303803','303844','303883','303901','303902','303903','303935','304020','304029') 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 ('41','59','186','197','239','245','280','282','295','304','157708','232436','232689','242634','242825','248199','249188','249624','15','46','141226','156817','156818','156819','156820','156821','156822','162929','163035','239578','239999','241895','243436','245751','249076','250245','250246','251523','253023','255677','255807','257162','263699','265336','265353','265418','265555','265559','267103','267325','268087','274891','277174','277873','279600','280870','280987','281321','284866','289257','292806','294064','294225','294973','300038','300426','300631','302050','154732','156959','156960','157583','158323','160813','161461','161528','161949','162003','162383','162672','162673','164155','164519','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164933','165025','165058','165176','165180','165657','165675','165694','165853','166016','166086','166198','166242','166284','166324','166422','166471','166611','166701','167231','168002','168127','168128','168219','168333','232444','239743','239835','239987','240009','241060','241161','241383','242603','242904','243211','243916','243949','244244','244554','244625','244718','245924','246001','246002','246138','246176','246309','246857','246901','247732','247940','248252','248421','248440','249103','249709','250098','250244','250353','250869','251677','252053','253021','253022','253209','253373','253417','253467','253738','253762','253791','253851','254445','254447','254712','255161','256247','256272','257184','261794','262005','262007','262011','262182','262781','263061','263629','265158','265468','265870','265899','265948','266274','266710','267701','268291','269441','269589','273521','273522','273831','274629','274786','274911','274921','275229','275236','275679','275836','276289','276295','276578','277306','277830','278105','278112','278142','278157','278458','278468','278533','278599','278600','278601','278744','279065','279825','280453','280603','280604','280778','280867','281494','281609','282196','282492','282555','282921','282924','283494','284284','284307','284416','284562','284619','285058','285441','285766','286071','286964','288317','289400','291746','291832','291956','292225','292321','292322','292389','293897','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294226','294360','294588','295487','295645','295801','295830','296278','297429','297585','297589','297849','298224','298478','298511','299191','299376','299443','300022','300681','153426','153619','153629','154408','154731','155271','155272','155273','155274','155275','155302','155303','155657','157261','157263','157264','157266','157267','157587','157961','158269','158654','159019','159255','159772','160145','161905','161979','161980','163868','164286','164545','164546','164959','166251','166714','166993','167587','238661','238966','239217','239357','239719','239742','240353','241126','241282','241531','242433','244269','244781','245495','247119','247674','249263','249827','250233','251205','251759','253875','254769','255107','255908','256178','256179','256449','256500','256541','262946','263550','263704','264648','266219','266393','266417','267090','267836','268146','269124','269164','273456','273534','274278','274948','276416','277953','280956','281190','281690','284185','288275','288732','289221','291708','291709','291855','294611','294939','295426','295689','298165','298486','299143','300057','301002','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289','303803','303883','303901','303902','303903','304020','304029','153585','158541','159079','160336','163844','164026','164551','164627','164646','164754','166243','168375','239543','239707','239732','239998','240088','241429','242426','242947','244096','244197','244550','245894','246953','248714','248880','249064','249746','250832','264657','264658','264892','276113','281423','282670','292061','296271','298387','299548','300935','303844','157787','157788','157790','164253','243917','244429','288310','292860','153633','153946','153947','154775','154874','155133','155723','157428','157429','157430','157431','157434','157435','157623','157843','157968','158100','158388','158397','158399','158631','158640','158875','158876','158912','159452','159646','159853','160283','160537','160833','160858','160949','161346','161509','161601','161617','161954','162081','162144','162255','162268','162686','162866','162867','162902','162920','163039','163344','163834','163882','163955','164499','164645','164858','164899','164964','165503','165557','165648','165710','165754','166433','167036','167079','167081','167432','167551','167819','168381','232520','238184','239127','239191','239192','239746','240526','240529','240629','240812','241076','241155','241406','241410','242324','243497','243533','244347','244760','244972','245002','245130','245167','245564','245692','245727','245757','246174','246236','246565','246717','246773','246899','247011','247161','247863','248000','248342','248695','248729','249173','249324','250195','250267','250640','250720','251341','251763','251834','252092','253630','253780','253825','254891','255224','255393','255997','256096','256099','256506','256510','256966','256972','257174','261800','261945','261947','262789','263546','264798','264853','265144','265375','265476','266116','266544','266915','266983','267214','267330','267941','268049','273964','274276','274624','275056','275093','275818','277673','277759','277800','278212','278476','278889','278927','281712','282838','283000','283214','285762','286013','286061','286065','286795','288010','291747','293224','293394','293452','294754','295163','295663','295665','295690','295692','295774','296284','297013','297457','298133','298389','299449','299559','299678','299711','300235','300552','301033','302195','153653','154952','157436','160542','162227','165348','166092','166485','167412','167773','168079','168366','240592','243948','244187','244188','244229','244230','244232','244233','244234','244235','244236','244505','244565','247700','247937','249034','250079','253488','253489','253490','253491','254710','256507','256539','256705','257221','262587','262830','263104','264437','264441','264830','265119','265193','265350','265352','265386','265438','265762','266284','267215','267481','267690','268047','268048','268359','268563','268881','273398','273918','273919','274448','274720','274912','275053','275248','275500','275604','275783','277340','277345','277346','278063','278640','279367','279692','280410','280917','281255','281898','283229','284228','284736','285172','285612','286006','286826','287124','288122','291753','292362','292527','292576','292798','294665','297327','297860','298281','298369','298481','299105','299857','300276','302347','161045','161046','161062','165514','168053','168054','219755','238380','238665','240327','242369','242457','242969','243081','243475','243476','243477','243478','243479','243480','243481','244228','244954','250912','250913','251596','253252','253253','253254','254721','266657','267522','267523','267524','267525','267526','267527','267992','273696','273916','275001','275617','275626','277069','277248','277343','277344','278759','281760','281764','284209','284356','284499','284596','285738','288261','291711','292032','292379','292753','293261','293375','293549','293550','294998','299059','302132','250680','279298','285442','300315','300337','300413','300414','303935','160767','160769','240075','245668','247544','249612','253504','274855','287128') 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 ('141226','153426','153585','153619','153629','153633','153653','153773','153946','153947','154231','154408','154571','154661','154679','154730','154731','154732','154775','154791','154874','154952','155133','155271','155272','155273','155274','155275','155302','155303','155367','155657','155723','156817','156818','156819','156820','156821','156822','156959','156960','157261','157263','157264','157266','157267','157423','157424','157425','157426','157427','157428','157429','157430','157431','157432','157433','157434','157435','157436','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157583','157587','157623','157665','157708','157787','157788','157790','157843','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','157961','157968','158100','158269','158323','158339','158341','158388','158397','158399','158485','158486','158541','158631','158640','158654','158685','158757','158810','158811','158813','158875','158876','158912','159019','159079','159097','159098','159253','159255','159259','159340','159341','159369','159452','159552','159646','159772','159853','159916','160098','160132','160145','160157','160158','160283','160316','160336','160384','160537','160542','160767','160769','160813','160833','160858','160949','161045','161046','161062','161137','161182','161326','161327','161346','161423','161461','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161509','161528','161590','161601','161617','161809','161905','161933','161934','161935','161949','161954','161979','161980','162003','162029','162030','162031','162032','162080','162081','162144','162227','162255','162268','162379','162383','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','162672','162673','162686','162866','162867','162902','162920','162929','163035','163039','163344','163542','163607','163694','163695','163834','163844','163868','163882','163955','164026','164070','164155','164253','164271','164286','164499','164519','164545','164546','164551','164627','164645','164646','164754','164771','164778','164779','164782','164783','164784','164785','164786','164787','164788','164789','164790','164791','164858','164899','164933','164959','164964','165025','165058','165094','165176','165180','165195','165331','165332','165348','165363','165379','165395','165503','165514','165557','165574','165648','165652','165657','165675','165694','165710','165731','165754','165840','165841','165853','165969','166016','166086','166092','166198','166242','166243','166251','166284','166324','166344','166422','166433','166471','166485','166611','166642','166701','166714','166735','166835','166883','166983','166993','167036','167079','167081','167118','167231','167245','167412','167432','167551','167587','167773','167790','167819','167900','168002','168031','168032','168053','168054','168079','168084','168127','168128','168152','168219','168333','168366','168375','168381','219755','232436','232444','232445','232520','232689','232720','238025','238042','238179','238184','238380','238661','238665','238809','238966','239110','239111','239112','239113','239114','239115','239116','239117','239127','239191','239192','239217','239310','239356','239357','239453','239543','239578','239616','239707','239713','239714','239719','239732','239742','239743','239746','239818','239835','239987','239998','239999','240009','240051','240075','240088','240114','240200','240286','240307','240327','240353','240526','240529','240586','240592','240629','240786','240787','240812','240936','240989','240990','240991','240992','241060','241076','241126','241155','241161','241282','241383','241406','241410','241429','241531','241734','241735','241787','241798','241850','241851','241864','241895','241962','241963','241964','241965','242101','242324','242334','242341','242369','242426','242433','242457','242489','242589','242603','242634','242706','242825','242904','242927','242947','242969','243081','243186','243211','243316','243436','243475','243476','243477','243478','243479','243480','243481','243497','243533','243724','243725','243744','243829','243916','243917','243948','243949','244096','244187','244188','244195','244197','244223','244224','244228','244229','244230','244232','244233','244234','244235','244236','244244','244269','244347','244429','244505','244538','244550','244554','244565','244591','244625','244718','244755','244760','244781','244798','244861','244865','244954','244972','245002','245130','245167','245495','245534','245564','245668','245692','245727','245751','245757','245811','245894','245924','246001','246002','246129','246138','246172','246174','246176','246236','246285','246309','246565','246679','246717','246719','246756','246773','246857','246899','246901','246934','246953','246962','247011','247107','247119','247161','247442','247543','247544','247674','247700','247732','247863','247930','247937','247940','248000','248081','248199','248252','248342','248421','248440','248533','248695','248714','248729','248761','248809','248880','248954','249001','249002','249003','249004','249005','249034','249064','249076','249103','249173','249188','249263','249324','249354','249392','249612','249624','249709','249746','249764','249827','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250079','250098','250195','250233','250244','250245','250246','250267','250353','250595','250640','250677','250680','250720','250832','250869','250912','250913','251175','251205','251217','251218','251219','251220','251288','251341','251463','251523','251548','251596','251677','251759','251763','251817','251834','252053','252092','253021','253022','253023','253209','253252','253253','253254','253373','253376','253417','253467','253488','253489','253490','253491','253504','253511','253627','253630','253736','253738','253762','253780','253791','253825','253846','253851','253865','253875','253902','254196','254326','254378','254379','254394','254445','254447','254710','254712','254721','254769','254771','254891','254937','255107','255161','255216','255224','255306','255393','255458','255677','255807','255838','255850','255908','255997','256096','256099','256178','256179','256219','256223','256247','256267','256272','256449','256500','256506','256507','256508','256510','256539','256541','256705','256771','256782','256783','256784','256840','256966','256972','257162','257174','257184','257221','261757','261777','261794','261800','261945','261947','262005','262007','262011','262182','262383','262576','262587','262754','262781','262789','262823','262830','262946','263061','263104','263514','263546','263550','263629','263660','263699','263704','264437','264441','264449','264648','264657','264658','264798','264830','264853','264866','264892','265051','265079','265119','265144','265152','265158','265164','265192','265193','265194','265195','265270','265336','265350','265352','265353','265356','265375','265386','265418','265421','265438','265468','265476','265536','265555','265559','265762','265870','265889','265892','265899','265915','265948','266095','266116','266138','266139','266219','266245','266274','266284','266322','266393','266417','266544','266623','266657','266684','266685','266686','266710','266755','266756','266864','266880','266915','266936','266983','267090','267103','267178','267214','267215','267251','267289','267325','267330','267481','267522','267523','267524','267525','267526','267527','267682','267690','267701','267703','267836','267941','267992','268000','268047','268048','268049','268066','268087','268146','268217','268234','268265','268291','268359','268563','268600','268769','268881','269124','269164','269402','269441','269549','269589','269597','269598','273335','273398','273456','273466','273521','273522','273534','273613','273695','273696','273724','273831','273916','273918','273919','273964','274276','274278','274298','274411','274448','274593','274624','274629','274720','274786','274790','274792','274842','274855','274891','274911','274912','274921','274948','274991','275001','275053','275056','275093','275229','275236','275248','275500','275600','275604','275617','275626','275655','275679','275783','275818','275836','276113','276130','276145','276250','276289','276295','276416','276438','276532','276578','276768','276780','276807','276941','276942','277014','277069','277174','277248','277306','277333','277340','277343','277344','277345','277346','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277673','277689','277759','277800','277830','277873','277953','278063','278105','278112','278114','278134','278135','278142','278157','278188','278212','278458','278468','278476','278477','278533','278599','278600','278601','278640','278744','278759','278871','278889','278927','279017','279061','279065','279074','279298','279299','279367','279404','279600','279692','279698','279756','279801','279825','280403','280410','280453','280538','280603','280604','280778','280780','280867','280870','280880','280917','280930','280931','280956','280987','281011','281112','281190','281255','281321','281330','281423','281494','281609','281685','281690','281712','281741','281760','281764','281859','281898','282144','282196','282356','282421','282492','282555','282670','282777','282838','282912','282921','282923','282924','283000','283058','283059','283214','283229','283330','283494','283792','284152','284153','284185','284209','284228','284284','284307','284356','284416','284499','284562','284596','284619','284736','284866','284994','285035','285058','285172','285182','285244','285302','285338','285441','285442','285514','285612','285738','285762','285766','286006','286013','286061','286065','286071','286322','286323','286795','286826','286964','287124','287128','287130','287506','287780','287969','288010','288122','288197','288198','288199','288200','288201','288212','288260','288261','288275','288310','288317','288531','288573','288611','288664','288709','288718','288719','288732','288755','288994','289221','289257','289400','289495','289496','289503','291708','291709','291711','291746','291747','291753','291832','291855','291857','291859','291860','291956','292032','292061','292225','292245','292304','292321','292322','292362','292379','292389','292527','292576','292718','292753','292779','292798','292806','292860','292873','292874','293224','293261','293375','293393','293394','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','293452','293549','293550','293897','294064','294080','294081','294082','294083','294084','294085','294086','294087','294088','294089','294090','294091','294092','294093','294094','294095','294096','294097','294098','294099','294100','294101','294102','294103','294104','294105','294106','294107','294108','294109','294110','294111','294112','294113','294114','294115','294116','294117','294118','294119','294120','294121','294122','294123','294124','294125','294126','294127','294128','294129','294225','294226','294227','294318','294358','294360','294502','294588','294603','294604','294611','294634','294635','294665','294754','294755','294939','294973','294998','295163','295364','295365','295366','295406','295426','295487','295645','295662','295663','295665','295689','295690','295692','295732','295774','295801','295830','296234','296271','296276','296278','296284','297012','297013','297138','297327','297429','297457','297585','297589','297849','297860','297921','297974','297975','297978','298056','298133','298165','298208','298224','298281','298287','298288','298365','298369','298387','298389','298478','298481','298486','298511','299030','299059','299105','299143','299191','299234','299376','299409','299439','299443','299449','299493','299548','299559','299655','299678','299711','299755','299756','299857','299934','299959','300022','300038','300057','300235','300259','300260','300276','300315','300337','300413','300414','300426','300434','300515','300552','300620','300631','300681','300935','301002','301033','302050','302132','302195','302204','302263','302264','302289','302347','303803','303844','303883','303901','303902','303903','303935','304020','304029') GROUP BY `manuf` ORDER BY `manuf` ASC