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 ('68','286','296','151815','158077','158284','160633','160714','160883','161115','161368','161923','161969','163061','163370','163419','165603','166748','166751','167172','167588','167690','213178','213179','213180','213181','213182','213183','213184','213185','213186','213187','213188','213189','213190','213191','213192','213193','215316','238444','239032','239033','239452','240393','240631','242509','242629','243608','243934','245633','246332','246611','247415','248822','249329','249492','250196','250197','253839','253840','254527','254782','254871','255237','262509','263562','263607','278738','69','70','239308','239320','141989','141990','142876','143155','143156','143323','143359','143618','143645','143659','144218','149615','149663','150819','150962','150963','150964','151093','151094','151569','151941','151955','153544','153815','154554','154575','154722','154726','154750','154770','154771','154832','154892','155202','156953','156955','156956','156958','157619','157620','157621','157926','157927','157958','157959','157960','158009','158017','158018','158299','158316','158342','158343','158344','158345','158499','158650','158682','158683','158684','158832','158870','158871','159046','159084','159085','159334','159380','159444','159505','159508','159573','159574','159780','159830','159968','159969','160167','160168','160282','160426','160461','160502','160621','160644','160663','160804','160843','160913','160978','160981','160987','161035','161053','161111','161149','161150','161187','161188','161310','161378','161556','161591','161744','161745','161771','161790','161793','161811','161900','161944','161984','162004','162021','162038','162106','162126','162190','162408','162598','162599','162605','162607','162611','162703','162837','162890','162912','162913','162930','162975','162983','163007','163010','163021','163077','163169','163170','163171','163245','163246','163247','163248','163414','163433','163481','163491','163496','163591','163753','163791','163836','163842','163905','163994','164014','164015','164067','164116','164149','164150','164151','164152','164201','164453','164462','164463','164490','164491','164529','164531','164600','164740','164822','164847','164998','165041','165241','165245','165285','165419','165643','165967','166114','166129','166279','166593','166683','166802','166982','167000','167045','167064','167065','167168','167275','167306','167368','167439','167535','167591','167595','167682','167692','167798','167857','167870','167882','167885','168168','168171','168247','168298','168316','168317','170149','170242','170346','170421','170422','170423','170425','170426','170427','170456','170699','170719','201153','202582','202583','202810','211173','211174','211175','211176','211177','211178','211179','211180','211181','211182','211183','211184','211185','215282','215484','215532','215769','216102','218777','232459','232634','232688','238050','238091','238092','238151','238180','238324','238329','238338','238340','238341','238628','239120','239121','239123','239124','239125','239126','239272','239273','239281','239282','239291','239292','239297','239350','239351','239352','239353','239395','239729','239735','239798','239799','239848','240022','240023','240024','240332','240352','240520','240698','240806','241097','241164','241192','241195','241211','241321','241325','241411','241434','241447','241506','241542','241543','241562','241676','241681','241701','241804','242106','242108','242474','242484','242546','242664','242695','242697','242709','242710','242715','242730','242735','242770','242800','242810','242811','242815','242914','242921','243141','243409','243438','243450','243499','243655','243705','243801','243919','243933','244374','244375','244376','244377','244539','244662','244702','244772','244806','244983','245045','245046','245069','245076','245077','245078','245349','245413','245414','245561','245645','245657','245669','245678','245797','245827','245828','245860','245861','245862','245863','245864','245865','245867','245868','245869','245871','245875','245876','245877','245905','245906','245940','245941','245985','246079','246099','246105','246201','246221','246235','246291','246304','246316','246317','246318','246319','246320','246321','246322','246323','246327','246424','246489','246501','246528','246529','246531','246564','246625','246639','246642','246675','246787','246788','246823','246844','246845','246846','246884','246900','246970','247006','247007','247094','247167','247177','247185','247309','247317','247392','247398','247404','247513','247537','247538','247571','247573','247654','247668','247672','247755','247756','247757','247812','247849','247953','247969','248013','248050','248102','248307','248363','248413','248478','248521','248550','248581','248672','248673','248674','248706','248708','248710','248914','248922','248933','249018','249046','249073','249074','249084','249085','249086','249089','249119','249197','249287','249349','249413','249417','249448','249450','249451','249490','249516','249816','249939','249940','249941','250059','250081','250107','250173','250174','250209','250227','250760','250817','250825','250871','250872','250873','250876','250879','250975','250976','251009','251086','251103','251104','251126','251127','251128','251129','251298','251382','251419','251444','251464','251705','251711','251713','251722','251804','251903','251991','251992','252078','252079','252136','252219','253017','253123','253124','253143','253276','253288','253320','253323','253337','253716','253748','253838','253856','253866','253872','253891','253895','254391','254555','254683','254833','254904','254989','254993','255042','255043','255057','255066','255154','255178','255198','255201','255218','255305','255332','255338','255427','255565','255635','255729','255871','256068','256158','256161','256186','256683','256689','256736','256743','256778','256917','257090','257091','257092','257094','257138','257164','257175','257234','261702','261704','261946','262089','262114','262246','262249','262293','262336','262338','262356','262359','262376','262507','262552','262657','262698','262713','263018','263026','263027','263093','263094','263110','263132','263455','263515','263539','263673','263701','264406','264411','264422','264428','264675','264745','264802','264919','264965','264997','264998','265016','265046','265052','265053','265337','265369','265377','265516','265517','265561','265564','265570','265596','265606','265620','265622','265676','265744','265756','265777','265815','265855','265902','265976','265999','266055','266140','266243','266265','266269','266292','266296','266380','266394','266435','266481','266487','266541','266551','266661','266745','266754','266758','266879','266902','266978','267017','267061','267063','267165','267423','267468','267820','267983','268067','268283','268315','268540','268548','268551','268552','268573','268609','268626','268664','268735','268750','268752','268761','269123','269230','269564','269751','273336','273394','273436','273454','273483','273542','273562','273870','273872','273884','273998','274144','274357','274363','274368','274369','274484','274502','274665','274670','274699','274710','274715','274721','274771','274776','274848','274885','275002','275195','275197','275198','275207','275208','275210','275544','275567','275641','275688','275812','275844','275845','275949','275973','275975','276035','276086','276101','276157','276286','276287','276352','276353','276354','276362','276527','276814','276815','276818','276949','276950','276954','276956','276969','276970','276987','277257','277309','277395','277490','277518','277519','277538','277583','277796','277896','277966','278020','278023','278126','278146','278213','278266','278302','278465','278485','278593','278594','278597','278598','278758','278845','278850','278851','279147','279165','279171','279254','279255','279265','279310','279311','279312','279313','279391','279429','279462','279533','279662','279672','279673','279682','279695','279765','280418','280450','280534','280536','280569','280605','280607','280608','280919','280938','280997','281020','281070','281197','281420','281594','281622','281784','281785','281789','282073','282077','282110','282152','282510','282773','282775','282935','283012','283203','283215','283435','283581','283584','283642','283648','283790','284170','284171','284172','284173','284238','284272','284352','284513','284856','285102','285186','285458','285464','285491','285534','285536','285537','285545','285546','285779','285882','285885','285886','285906','285910','285920','285932','285955','286088','286112','286203','286244','286293','286430','286431','286432','286586','286645','286652','286653','286664','286672','286673','286674','286675','286676','286677','286678','286679','286680','286681','286682','286683','286684','286685','286686','286687','286688','286689','286690','286691','286692','286693','286694','286695','286696','286697','286698','286699','286700','286701','286702','286703','286704','286705','286706','286707','286708','286709','286710','286711','286712','286713','286714','286715','286716','286717','286718','286719','286720','286721','286722','286723','286724','286725','286726','286727','286728','286729','286730','286731','286732','286733','286734','286735','286736','286737','286738','286739','286740','286741','286742','286743','286744','286745','286746','286747','286748','286749','286750','286751','286752','286753','286754','286755','286756','286757','286758','286759','286760','286761','286762','286763','286764','286765','286766','286767','286768','286769','286770','286771','286772','286773','286774','286775','286776','286777','286778','286779','286780','286832','286845','286851','286866','286887','287009','287032','287188','287982','288153','288253','288316','288442','288486','288492','288501','288513','288514','288577','288593','288866','288988','289118','289186','289476','291584','291614','291757','291758','291759','291834','291845','291875','291943','291981','292028','292030','292047','292065','292066','292250','292257','292271','292295','292323','292324','292331','292332','292345','292383','292489','292519','292522','292526','292568','292645','292782','293245','293249','293517','293532','293558','293594','293599','293620','293622','293623','293624','293625','293986','294065','294149','294223','294224','294296','294492','294540','294541','294542','294779','294882','294885','294930','294931','294932','295496','295499','295538','295542','295545','295609','295710','295711','295786','296205','296207','296208','296209','296211','296212','296280','297090','297182','297226','297265','297477','297565','297803','297831','298009','298023','298044','298135','298219','298278','298316','298475','298492','298503','298521','298551','298555','298556','298599','299032','299033','299037','299041','299087','299150','299151','299153','299154','299155','299169','299198','299387','299609','299672','299730','299752','299802','299878','300021','300189','300210','300211','300297','300299','300318','300370','300546','300671','300697','300923','301030','301058','301833','301884','301889','301916','301917','301943','302085','302196','303802','303816','141443','141448','141449','141577','141636','141637','141698','141699','141700','141701','141702','141703','141888','141889','141915','141927','141946','141947','142059','142060','142061','142182','142231','142900','142901','142921','143054','143176','143246','143247','143248','143272','143389','143445','143577','143681','144038','146553','147047','148034','148035','148166','148583','149703','149704','150596','150801','150916','151013','151095','151154','151312','151313','151431','151481','151797','151837','152536','153241','153621','153782','153808','153945','154126','154156','154257','154348','154466','154471','154472','154497','154499','154548','154610','154761','154768','154773','154872','154875','155187','155240','156263','156264','156265','156266','156268','156895','156896','156897','156898','156899','156900','156901','156902','156903','156904','156905','156906','156907','156908','156909','156910','156911','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156938','156939','156940','156941','156942','156943','156944','156945','156946','156947','156948','156949','156950','156951','156952','156954','156957','157604','157605','157606','157607','157608','157609','157610','157611','157612','157613','157614','157615','157616','157617','157618','157628','157629','157839','158031','158039','158040','158041','158042','158043','158044','158046','158047','158048','158049','158050','158063','158064','158065','158069','158074','158075','158076','158132','158133','158144','158173','158219','158550','158597','158598','158709','158738','159209','159217','159332','159559','159733','159878','159879','159880','159881','159882','159908','159990','159993','160001','160893','160957','160994','160999','161180','161294','161319','161646','161647','161648','161649','161650','161651','161652','161653','161654','161655','161656','161657','161658','161659','161660','161661','161662','161663','161664','161665','161666','161824','161825','161834','161931','162260','162391','162547','162548','162768','162787','163224','163515','163845','163846','163883','164010','164016','164049','164210','164270','164442','164498','164629','164703','164837','164925','164938','164939','164986','165586','165591','165690','165775','165903','166179','166550','166551','166564','166572','167058','167279','167621','167769','167859','167869','168055','168076','168159','168252','168368','169135','169136','169213','169750','169824','169889','170137','170140','170420','170589','170618','170640','201155','202768','202773','202835','211186','211187','211188','211189','211190','211191','211192','211193','211194','211195','211196','211197','211198','211199','211200','211201','211202','211203','211204','211205','215268','215283','215383','215424','215580','215825','215826','215827','215851','215906','216009','216010','216090','232546','232635','232711','232759','232762','232779','238033','238035','238036','238183','238336','238398','238406','238504','238547','238579','238629','238713','238714','238746','238747','238748','238749','238750','238751','238752','238753','238754','238755','238756','238757','238758','238759','238760','238761','238762','238763','238846','238847','239122','239141','239158','239170','239283','239312','239325','239414','239415','239416','239417','239418','239419','239420','239421','239422','239423','239424','239425','239426','239427','239428','239429','239430','239431','239432','239433','239434','239435','239436','239437','239438','239439','239440','239554','239909','239910','239911','239912','240093','240296','240411','240589','241042','241303','241304','241522','241523','241524','241525','241740','242005','242150','242205','242217','242446','243432','243806','243807','243808','243963','244171','244313','244330','244331','244332','244334','244335','244343','244360','244563','244948','245587','245651','245812','245813','245814','246017','246018','246228','246239','246252','246253','246612','246712','246980','247105','247146','247344','247519','247550','247963','247967','248007','248085','248456','248571','248810','248978','249109','249181','249348','249415','249706','249825','249856','250158','250159','251043','251351','251459','251495','251517','251518','251645','251747','251955','253506','253876','254327','254344','254538','254864','255236','255307','255611','255671','255862','256112','256148','256365','256517','256813','262377','262644','262769','263095','263507','263565','264429','264452','264453','264454','264678','264747','264877','265006','265143','265235','265370','265494','265522','265754','266172','266221','266895','267024','267052','267053','267087','267333','268353','268514','268517','268542','268845','268910','269211','269320','269366','269398','273498','274140','274158','274430','274476','274485','274607','274773','275243','275340','275524','275548','275554','276014','276060','276486','276540','276561','276804','276974','277222','277464','278307','278843','279592','280342','280368','280933','281489','281617','282143','282843','283313','283637','283666','284146','284206','284293','284644','285451','285489','285685','286000','286781','286782','286783','286784','286785','286786','286787','286788','286789','286790','286791','286792','286793','286794','291891','292087','292218','292613','292631','292904','293217','293621','294881','294892','295515','295536','297212','297562','297651','298045','298554','299228','299240','299407','299455','299889','299892','300222','300559','300569','300649','301817','301820','302346','148050','148146','151695','151696','153512','153513','153727','154221','154882','155013','157268','157269','157826','158194','158306','158414','158418','158806','158807','159506','159583','159781','159980','160189','160260','160375','160475','161360','162179','162359','162895','163656','164370','164418','164865','165087','165170','165353','165490','166232','166627','166991','167225','167366','167428','167504','167601','167675','168243','170461','215478','232553','232794','238219','238841','238842','238972','239792','240254','240255','240396','240410','240533','240724','240808','240952','240972','241439','241440','241476','242120','242514','242896','243797','243946','244318','244345','244679','244895','245296','245297','245457','245514','246270','248207','248235','248361','248770','248886','248956','249015','249016','249304','249592','249665','249838','249841','250129','250247','250588','251003','251133','251235','251238','251456','251490','251549','251618','251657','251731','251944','252051','253682','254892','255244','255460','255588','256484','256666','256799','256849','256855','256863','261739','262090','262401','263097','263109','263193','263566','263650','264720','264721','264722','264723','264724','264871','265025','265026','265110','265852','265983','266900','266969','267045','267160','267662','267825','267858','268107','268119','268588','269363','269400','273457','273476','273644','273712','273715','273892','275058','275475','275620','275838','275976','276209','276978','277201','277227','277791','277795','277932','278103','278412','280395','280396','280976','281316','281327','281582','282485','282544','282850','283333','284591','284600','284833','285075','285221','286341','286342','287548','288178','288216','288506','288586','291741','292585','292617','292770','293612','293994','294511','295377','295835','296213','296219','297020','297271','297575','297926','298203','300909','301778','302164','141806','151814','154890','158679','160313','160394','160462','161114','161483','161540','161572','162174','162467','162931','163168','163183','163294','163295','163492','163549','163708','164148','165079','165820','165960','166590','167285','167352','167355','167544','168037','170132','218999','238817','240121','240122','241272','241437','241438','242148','242390','242591','242944','243074','243433','243839','243920','244341','244649','245586','245685','245789','246075','246254','246290','246751','246752','246847','246948','247155','247813','248152','248153','248671','248816','251263','251304','251334','253473','253899','254386','254554','254795','254798','254834','254966','254980','254981','256717','256815','256973','262076','264483','264556','264839','265411','266359','266540','266994','267242','267401','268139','268842','269059','269505','269551','274086','274148','274232','274364','274509','274803','275111','275253','276057','276392','276539','276640','277378','278432','278781','278785','279208','279371','281825','281826','283643','283762','284223','285647','285909','285929','285930','285931','286219','287540','287778','287789','288665','289300','291603','291604','291605','291606','291607','291608','291609','291790','291817','292022','292023','292024','292285','293401','294008','294063','294172','294215','294216','294219','294677','294823','294886','294916','294917','294918','295516','295596','295652','297241','297595','298117','298119','298210','298254','298255','298256','298257','298289','299084','299104','299195','299202','299241','299242','299245','299247','299248','299249','299250','299684','299779','299780','299781','299782','299783','299784','299859','299860','299926','299927','300663','301958','301959','301960','301961','301962','301963','301964','301965','301966','301967','160187','160188','167280','251283','273767','275241','276593','278832','278833','280835','283496','285941','286392','296255','297826','299295','301861','302119') 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 ('141443','141448','141449','141577','141636','141637','141698','141699','141700','141701','141702','141703','141806','141888','141889','141915','141927','141946','141947','141989','141990','142059','142060','142061','142182','142231','142876','142900','142901','142921','143054','143155','143156','143176','143246','143247','143248','143272','143323','143359','143389','143445','143577','143618','143645','143659','143681','144038','144218','146553','147047','148034','148035','148050','148146','148166','148583','149615','149663','149703','149704','150596','150801','150819','150916','150962','150963','150964','151013','151093','151094','151095','151154','151312','151313','151431','151481','151569','151695','151696','151797','151814','151815','151837','151941','151955','152536','153241','153512','153513','153544','153621','153727','153782','153808','153815','153945','154126','154156','154221','154257','154348','154466','154471','154472','154497','154499','154548','154554','154575','154610','154722','154726','154750','154761','154768','154770','154771','154773','154832','154872','154875','154882','154890','154892','155013','155187','155202','155240','156263','156264','156265','156266','156268','156895','156896','156897','156898','156899','156900','156901','156902','156903','156904','156905','156906','156907','156908','156909','156910','156911','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156938','156939','156940','156941','156942','156943','156944','156945','156946','156947','156948','156949','156950','156952','156953','156954','156955','156956','156957','156958','157268','157269','157604','157605','157606','157607','157608','157609','157610','157611','157612','157613','157614','157615','157616','157617','157618','157619','157620','157621','157628','157629','157826','157839','157926','157927','157958','157959','157960','158009','158017','158018','158031','158039','158040','158041','158042','158043','158044','158046','158047','158048','158049','158050','158063','158064','158065','158069','158074','158075','158076','158077','158132','158133','158144','158173','158194','158219','158284','158299','158306','158316','158342','158343','158344','158345','158414','158418','158499','158550','158597','158598','158650','158679','158682','158683','158684','158709','158738','158806','158807','158832','158870','158871','159046','159084','159085','159209','159217','159332','159334','159380','159444','159505','159506','159508','159559','159573','159574','159583','159733','159780','159781','159830','159878','159879','159880','159881','159882','159908','159968','159969','159980','159990','159993','160001','160167','160168','160187','160188','160189','160260','160282','160313','160375','160394','160426','160461','160462','160475','160502','160621','160633','160644','160663','160714','160804','160843','160883','160893','160913','160957','160978','160981','160987','160994','160999','161035','161053','161111','161114','161115','161149','161150','161180','161187','161188','161294','161310','161319','161360','161368','161378','161483','161540','161556','161572','161591','161646','161647','161648','161649','161650','161651','161652','161653','161654','161655','161656','161657','161658','161659','161660','161661','161662','161663','161664','161665','161666','161744','161745','161771','161790','161793','161811','161824','161825','161834','161900','161923','161931','161944','161969','161984','162004','162021','162038','162106','162126','162174','162179','162190','162260','162359','162391','162408','162467','162547','162548','162598','162599','162605','162607','162611','162703','162768','162787','162837','162890','162895','162912','162913','162930','162931','162975','162983','163007','163010','163021','163061','163077','163168','163169','163170','163171','163183','163224','163245','163246','163247','163248','163294','163295','163370','163414','163419','163433','163481','163491','163492','163496','163515','163549','163591','163656','163708','163753','163791','163836','163842','163845','163846','163883','163905','163994','164010','164014','164015','164016','164049','164067','164116','164148','164149','164150','164151','164152','164201','164210','164270','164370','164418','164442','164453','164462','164463','164490','164491','164498','164529','164531','164600','164629','164703','164740','164822','164837','164847','164865','164925','164938','164939','164986','164998','165041','165079','165087','165170','165241','165245','165285','165353','165419','165490','165586','165591','165603','165643','165690','165775','165820','165903','165960','165967','166114','166129','166179','166232','166279','166550','166551','166564','166572','166590','166593','166627','166683','166748','166751','166802','166982','166991','167000','167045','167058','167064','167065','167168','167172','167225','167275','167279','167280','167285','167306','167352','167355','167366','167368','167428','167439','167504','167535','167544','167588','167591','167595','167601','167621','167675','167682','167690','167692','167769','167798','167857','167859','167869','167870','167882','167885','168037','168055','168076','168159','168168','168171','168243','168247','168252','168298','168316','168317','168368','169135','169136','169213','169750','169824','169889','170132','170137','170140','170149','170242','170346','170420','170421','170422','170423','170425','170426','170427','170456','170461','170589','170618','170640','170699','170719','201153','201155','202582','202583','202768','202773','202810','202835','211173','211174','211175','211176','211177','211178','211179','211180','211181','211182','211183','211184','211185','211186','211187','211188','211189','211190','211191','211192','211193','211194','211195','211196','211197','211198','211199','211200','211201','211202','211203','211204','211205','213178','213179','213180','213181','213182','213183','213184','213185','213186','213187','213188','213189','213190','213191','213192','213193','215268','215282','215283','215316','215383','215424','215478','215484','215532','215580','215769','215825','215826','215827','215851','215906','216009','216010','216090','216102','218777','218999','232459','232546','232553','232634','232635','232688','232711','232759','232762','232779','232794','238033','238035','238036','238050','238091','238092','238151','238180','238183','238219','238324','238329','238336','238338','238340','238341','238398','238406','238444','238504','238547','238579','238628','238629','238713','238714','238746','238747','238748','238749','238750','238751','238752','238753','238754','238755','238756','238757','238758','238759','238760','238761','238762','238763','238817','238841','238842','238846','238847','238972','239032','239033','239120','239121','239122','239123','239124','239125','239126','239141','239158','239170','239272','239273','239281','239282','239283','239291','239292','239297','239308','239312','239320','239325','239350','239351','239352','239353','239395','239414','239415','239416','239417','239418','239419','239420','239421','239422','239423','239424','239425','239426','239427','239428','239429','239430','239431','239432','239433','239434','239435','239436','239437','239438','239439','239440','239452','239554','239729','239735','239792','239798','239799','239848','239909','239910','239911','239912','240022','240023','240024','240093','240121','240122','240254','240255','240296','240332','240352','240393','240396','240410','240411','240520','240533','240589','240631','240698','240724','240806','240808','240952','240972','241042','241097','241164','241192','241195','241211','241272','241303','241304','241321','241325','241411','241434','241437','241438','241439','241440','241447','241476','241506','241522','241523','241524','241525','241542','241543','241562','241676','241681','241701','241740','241804','242005','242106','242108','242120','242148','242150','242205','242217','242390','242446','242474','242484','242509','242514','242546','242591','242629','242664','242695','242697','242709','242710','242715','242730','242735','242770','242800','242810','242811','242815','242896','242914','242921','242944','243074','243141','243409','243432','243433','243438','243450','243499','243608','243655','243705','243797','243801','243806','243807','243808','243839','243919','243920','243933','243934','243946','243963','244171','244313','244318','244330','244331','244332','244334','244335','244341','244343','244345','244360','244374','244375','244376','244377','244539','244563','244649','244662','244679','244702','244772','244806','244895','244948','244983','245045','245046','245069','245076','245077','245078','245296','245297','245349','245413','245414','245457','245514','245561','245586','245587','245633','245645','245651','245657','245669','245678','245685','245789','245797','245812','245813','245814','245827','245828','245860','245861','245862','245863','245864','245865','245867','245868','245869','245871','245875','245876','245877','245905','245906','245940','245941','245985','246017','246018','246075','246079','246099','246105','246201','246221','246228','246235','246239','246252','246253','246254','246270','246290','246291','246304','246316','246317','246318','246319','246320','246321','246322','246323','246327','246332','246424','246489','246501','246528','246529','246531','246564','246611','246612','246625','246639','246642','246675','246712','246751','246752','246787','246788','246823','246844','246845','246846','246847','246884','246900','246948','246970','246980','247006','247007','247094','247105','247146','247155','247167','247177','247185','247309','247317','247344','247392','247398','247404','247415','247513','247519','247537','247538','247550','247571','247573','247654','247668','247672','247755','247756','247757','247812','247813','247849','247953','247963','247967','247969','248007','248013','248050','248085','248102','248152','248153','248207','248235','248307','248361','248363','248413','248456','248478','248521','248550','248571','248581','248671','248672','248673','248674','248706','248708','248710','248770','248810','248816','248822','248886','248914','248922','248933','248956','248978','249015','249016','249018','249046','249073','249074','249084','249085','249086','249089','249109','249119','249181','249197','249287','249304','249329','249348','249349','249413','249415','249417','249448','249450','249451','249490','249492','249516','249592','249665','249706','249816','249825','249838','249841','249856','249939','249940','249941','250059','250081','250107','250129','250158','250159','250173','250174','250196','250197','250209','250227','250247','250588','250760','250817','250825','250871','250872','250873','250876','250879','250975','250976','251003','251009','251043','251086','251103','251104','251126','251127','251128','251129','251133','251235','251238','251263','251283','251298','251304','251334','251351','251382','251419','251444','251456','251459','251464','251490','251495','251517','251518','251549','251618','251645','251657','251705','251711','251713','251722','251731','251747','251804','251903','251944','251955','251991','251992','252051','252078','252079','252136','252219','253017','253123','253124','253143','253276','253288','253320','253323','253337','253473','253506','253682','253716','253748','253838','253839','253840','253856','253866','253872','253876','253891','253895','253899','254327','254344','254386','254391','254527','254538','254554','254555','254683','254782','254795','254798','254833','254834','254864','254871','254892','254904','254966','254980','254981','254989','254993','255042','255043','255057','255066','255154','255178','255198','255201','255218','255236','255237','255244','255305','255307','255332','255338','255427','255460','255565','255588','255611','255635','255671','255729','255862','255871','256068','256112','256148','256158','256161','256186','256365','256484','256517','256666','256683','256689','256717','256736','256743','256778','256799','256813','256815','256849','256855','256863','256917','256973','257090','257091','257092','257094','257138','257164','257175','257234','261702','261704','261739','261946','262076','262089','262090','262114','262246','262249','262293','262336','262338','262356','262359','262376','262377','262401','262507','262509','262552','262644','262657','262698','262713','262769','263018','263026','263027','263093','263094','263095','263097','263109','263110','263132','263193','263455','263507','263515','263539','263562','263565','263566','263607','263650','263673','263701','264406','264411','264422','264428','264429','264452','264453','264454','264483','264556','264675','264678','264720','264721','264722','264723','264724','264745','264747','264802','264839','264871','264877','264919','264965','264997','264998','265006','265016','265025','265026','265046','265052','265053','265110','265143','265235','265337','265369','265370','265377','265411','265494','265516','265517','265522','265561','265564','265570','265596','265606','265620','265622','265676','265744','265754','265756','265777','265815','265852','265855','265902','265976','265983','265999','266055','266140','266172','266221','266243','266265','266269','266292','266296','266359','266380','266394','266435','266481','266487','266540','266541','266551','266661','266745','266754','266758','266879','266895','266900','266902','266969','266978','266994','267017','267024','267045','267052','267053','267061','267063','267087','267160','267165','267242','267333','267401','267423','267468','267662','267820','267825','267858','267983','268067','268107','268119','268139','268283','268315','268353','268514','268517','268540','268542','268548','268551','268552','268573','268588','268609','268626','268664','268735','268750','268752','268761','268842','268845','268910','269059','269123','269211','269230','269320','269363','269366','269398','269400','269505','269551','269564','269751','273336','273394','273436','273454','273457','273476','273483','273498','273542','273562','273644','273712','273715','273767','273870','273872','273884','273892','273998','274086','274140','274144','274148','274158','274232','274357','274363','274364','274368','274369','274430','274476','274484','274485','274502','274509','274607','274665','274670','274699','274710','274715','274721','274771','274773','274776','274803','274848','274885','275002','275058','275111','275195','275197','275198','275207','275208','275210','275241','275243','275253','275340','275475','275524','275544','275548','275554','275567','275620','275641','275688','275812','275838','275844','275845','275949','275973','275975','275976','276014','276035','276057','276060','276086','276101','276157','276209','276286','276287','276352','276353','276354','276362','276392','276486','276527','276539','276540','276561','276593','276640','276804','276814','276815','276818','276949','276950','276954','276956','276969','276970','276974','276978','276987','277201','277222','277227','277257','277309','277378','277395','277464','277490','277518','277519','277538','277583','277791','277795','277796','277896','277932','277966','278020','278023','278103','278126','278146','278213','278266','278302','278307','278412','278432','278465','278485','278593','278594','278597','278598','278758','278781','278785','278832','278833','278843','278845','278850','278851','279147','279165','279171','279208','279254','279255','279265','279310','279311','279312','279313','279371','279391','279429','279462','279533','279592','279662','279672','279673','279682','279695','279765','280342','280368','280395','280396','280418','280450','280534','280536','280569','280605','280607','280608','280835','280919','280933','280938','280976','280997','281020','281070','281197','281316','281327','281420','281489','281582','281594','281617','281622','281784','281785','281789','281825','281826','282073','282077','282110','282143','282152','282485','282510','282544','282773','282775','282843','282850','282935','283012','283203','283215','283313','283333','283435','283496','283581','283584','283637','283642','283643','283648','283666','283762','283790','284146','284170','284171','284172','284173','284206','284223','284238','284272','284293','284352','284513','284591','284600','284644','284833','284856','285075','285102','285186','285221','285451','285458','285464','285489','285491','285534','285536','285537','285545','285546','285647','285685','285779','285882','285885','285886','285906','285909','285910','285920','285929','285930','285931','285932','285941','285955','286000','286088','286112','286203','286219','286244','286293','286341','286342','286392','286430','286431','286432','286586','286645','286652','286653','286664','286672','286673','286674','286675','286676','286677','286678','286679','286680','286681','286682','286683','286684','286685','286686','286687','286688','286689','286690','286691','286692','286693','286694','286695','286696','286697','286698','286699','286700','286701','286702','286703','286704','286705','286706','286707','286708','286709','286710','286711','286712','286713','286714','286715','286716','286717','286718','286719','286720','286721','286722','286723','286724','286725','286726','286727','286728','286729','286730','286731','286732','286733','286734','286735','286736','286737','286738','286739','286740','286741','286742','286743','286744','286745','286746','286747','286748','286749','286750','286751','286752','286753','286754','286755','286756','286757','286758','286759','286760','286761','286762','286763','286764','286765','286766','286767','286768','286769','286770','286771','286772','286773','286774','286775','286776','286777','286778','286779','286780','286781','286782','286783','286784','286785','286786','286787','286788','286789','286790','286791','286792','286793','286794','286832','286845','286851','286866','286887','287009','287032','287188','287540','287548','287778','287789','287982','288153','288178','288216','288253','288316','288442','288486','288492','288501','288506','288513','288514','288577','288586','288593','288665','288866','288988','289118','289186','289300','289476','291584','291603','291604','291605','291606','291607','291608','291609','291614','291741','291757','291758','291759','291790','291817','291834','291845','291875','291891','291943','291981','292022','292023','292024','292028','292030','292047','292065','292066','292087','292218','292250','292257','292271','292285','292295','292323','292324','292331','292332','292345','292383','292489','292519','292522','292526','292568','292585','292613','292617','292631','292645','292770','292782','292904','293217','293245','293249','293401','293517','293532','293558','293594','293599','293612','293620','293621','293622','293623','293624','293625','293986','293994','294008','294063','294065','294149','294172','294215','294216','294219','294223','294224','294296','294492','294511','294540','294541','294542','294677','294779','294823','294881','294882','294885','294886','294892','294916','294917','294918','294930','294931','294932','295377','295496','295499','295515','295516','295536','295538','295542','295545','295596','295609','295652','295710','295711','295786','295835','296205','296207','296208','296209','296211','296212','296213','296219','296255','296280','297020','297090','297182','297212','297226','297241','297265','297271','297477','297562','297565','297575','297595','297651','297803','297826','297831','297926','298009','298023','298044','298045','298117','298119','298135','298203','298210','298219','298254','298255','298256','298257','298278','298289','298316','298475','298492','298503','298521','298551','298554','298555','298556','298599','299032','299033','299037','299041','299084','299087','299104','299150','299151','299153','299154','299155','299169','299195','299198','299202','299228','299240','299241','299242','299245','299247','299248','299249','299250','299295','299387','299407','299455','299609','299672','299684','299730','299752','299779','299780','299781','299782','299783','299784','299802','299859','299860','299878','299889','299892','299926','299927','300021','300189','300210','300211','300222','300297','300299','300318','300370','300546','300559','300569','300649','300663','300671','300697','300909','300923','301030','301058','301778','301817','301820','301833','301861','301884','301889','301916','301917','301943','301958','301959','301960','301961','301962','301963','301964','301965','301966','301967','302085','302119','302164','302196','302346','303802','303816') 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 ('68','286','296','151815','158077','158284','160633','160714','160883','161115','161368','161923','161969','163061','163370','163419','165603','166748','166751','167172','167588','167690','213178','213179','213180','213181','213182','213183','213184','213185','213186','213187','213188','213189','213190','213191','213192','213193','215316','238444','239032','239033','239452','240393','240631','242509','242629','243608','243934','245633','246332','246611','247415','248822','249329','249492','250196','250197','253839','253840','254527','254782','254871','255237','262509','263562','263607','278738','69','70','239308','239320','141989','141990','142876','143155','143156','143323','143359','143618','143645','143659','144218','149615','149663','150819','150962','150963','150964','151093','151094','151569','151941','151955','153544','153815','154554','154575','154722','154726','154750','154770','154771','154832','154892','155202','156953','156955','156956','156958','157619','157620','157621','157926','157927','157958','157959','157960','158009','158017','158018','158299','158316','158342','158343','158344','158345','158499','158650','158682','158683','158684','158832','158870','158871','159046','159084','159085','159334','159380','159444','159505','159508','159573','159574','159780','159830','159968','159969','160167','160168','160282','160426','160461','160502','160621','160644','160663','160804','160843','160913','160978','160981','160987','161035','161053','161111','161149','161150','161187','161188','161310','161378','161556','161591','161744','161745','161771','161790','161793','161811','161900','161944','161984','162004','162021','162038','162106','162126','162190','162408','162598','162599','162605','162607','162611','162703','162837','162890','162912','162913','162930','162975','162983','163007','163010','163021','163077','163169','163170','163171','163245','163246','163247','163248','163414','163433','163481','163491','163496','163591','163753','163791','163836','163842','163905','163994','164014','164015','164067','164116','164149','164150','164151','164152','164201','164453','164462','164463','164490','164491','164529','164531','164600','164740','164822','164847','164998','165041','165241','165245','165285','165419','165643','165967','166114','166129','166279','166593','166683','166802','166982','167000','167045','167064','167065','167168','167275','167306','167368','167439','167535','167591','167595','167682','167692','167798','167857','167870','167882','167885','168168','168171','168247','168298','168316','168317','170149','170242','170346','170421','170422','170423','170425','170426','170427','170456','170699','170719','201153','202582','202583','202810','211173','211174','211175','211176','211177','211178','211179','211180','211181','211182','211183','211184','211185','215282','215484','215532','215769','216102','218777','232459','232634','232688','238050','238091','238092','238151','238180','238324','238329','238338','238340','238341','238628','239120','239121','239123','239124','239125','239126','239272','239273','239281','239282','239291','239292','239297','239350','239351','239352','239353','239395','239729','239735','239798','239799','239848','240022','240023','240024','240332','240352','240520','240698','240806','241097','241164','241192','241195','241211','241321','241325','241411','241434','241447','241506','241542','241543','241562','241676','241681','241701','241804','242106','242108','242474','242484','242546','242664','242695','242697','242709','242710','242715','242730','242735','242770','242800','242810','242811','242815','242914','242921','243141','243409','243438','243450','243499','243655','243705','243801','243919','243933','244374','244375','244376','244377','244539','244662','244702','244772','244806','244983','245045','245046','245069','245076','245077','245078','245349','245413','245414','245561','245645','245657','245669','245678','245797','245827','245828','245860','245861','245862','245863','245864','245865','245867','245868','245869','245871','245875','245876','245877','245905','245906','245940','245941','245985','246079','246099','246105','246201','246221','246235','246291','246304','246316','246317','246318','246319','246320','246321','246322','246323','246327','246424','246489','246501','246528','246529','246531','246564','246625','246639','246642','246675','246787','246788','246823','246844','246845','246846','246884','246900','246970','247006','247007','247094','247167','247177','247185','247309','247317','247392','247398','247404','247513','247537','247538','247571','247573','247654','247668','247672','247755','247756','247757','247812','247849','247953','247969','248013','248050','248102','248307','248363','248413','248478','248521','248550','248581','248672','248673','248674','248706','248708','248710','248914','248922','248933','249018','249046','249073','249074','249084','249085','249086','249089','249119','249197','249287','249349','249413','249417','249448','249450','249451','249490','249516','249816','249939','249940','249941','250059','250081','250107','250173','250174','250209','250227','250760','250817','250825','250871','250872','250873','250876','250879','250975','250976','251009','251086','251103','251104','251126','251127','251128','251129','251298','251382','251419','251444','251464','251705','251711','251713','251722','251804','251903','251991','251992','252078','252079','252136','252219','253017','253123','253124','253143','253276','253288','253320','253323','253337','253716','253748','253838','253856','253866','253872','253891','253895','254391','254555','254683','254833','254904','254989','254993','255042','255043','255057','255066','255154','255178','255198','255201','255218','255305','255332','255338','255427','255565','255635','255729','255871','256068','256158','256161','256186','256683','256689','256736','256743','256778','256917','257090','257091','257092','257094','257138','257164','257175','257234','261702','261704','261946','262089','262114','262246','262249','262293','262336','262338','262356','262359','262376','262507','262552','262657','262698','262713','263018','263026','263027','263093','263094','263110','263132','263455','263515','263539','263673','263701','264406','264411','264422','264428','264675','264745','264802','264919','264965','264997','264998','265016','265046','265052','265053','265337','265369','265377','265516','265517','265561','265564','265570','265596','265606','265620','265622','265676','265744','265756','265777','265815','265855','265902','265976','265999','266055','266140','266243','266265','266269','266292','266296','266380','266394','266435','266481','266487','266541','266551','266661','266745','266754','266758','266879','266902','266978','267017','267061','267063','267165','267423','267468','267820','267983','268067','268283','268315','268540','268548','268551','268552','268573','268609','268626','268664','268735','268750','268752','268761','269123','269230','269564','269751','273336','273394','273436','273454','273483','273542','273562','273870','273872','273884','273998','274144','274357','274363','274368','274369','274484','274502','274665','274670','274699','274710','274715','274721','274771','274776','274848','274885','275002','275195','275197','275198','275207','275208','275210','275544','275567','275641','275688','275812','275844','275845','275949','275973','275975','276035','276086','276101','276157','276286','276287','276352','276353','276354','276362','276527','276814','276815','276818','276949','276950','276954','276956','276969','276970','276987','277257','277309','277395','277490','277518','277519','277538','277583','277796','277896','277966','278020','278023','278126','278146','278213','278266','278302','278465','278485','278593','278594','278597','278598','278758','278845','278850','278851','279147','279165','279171','279254','279255','279265','279310','279311','279312','279313','279391','279429','279462','279533','279662','279672','279673','279682','279695','279765','280418','280450','280534','280536','280569','280605','280607','280608','280919','280938','280997','281020','281070','281197','281420','281594','281622','281784','281785','281789','282073','282077','282110','282152','282510','282773','282775','282935','283012','283203','283215','283435','283581','283584','283642','283648','283790','284170','284171','284172','284173','284238','284272','284352','284513','284856','285102','285186','285458','285464','285491','285534','285536','285537','285545','285546','285779','285882','285885','285886','285906','285910','285920','285932','285955','286088','286112','286203','286244','286293','286430','286431','286432','286586','286645','286652','286653','286664','286672','286673','286674','286675','286676','286677','286678','286679','286680','286681','286682','286683','286684','286685','286686','286687','286688','286689','286690','286691','286692','286693','286694','286695','286696','286697','286698','286699','286700','286701','286702','286703','286704','286705','286706','286707','286708','286709','286710','286711','286712','286713','286714','286715','286716','286717','286718','286719','286720','286721','286722','286723','286724','286725','286726','286727','286728','286729','286730','286731','286732','286733','286734','286735','286736','286737','286738','286739','286740','286741','286742','286743','286744','286745','286746','286747','286748','286749','286750','286751','286752','286753','286754','286755','286756','286757','286758','286759','286760','286761','286762','286763','286764','286765','286766','286767','286768','286769','286770','286771','286772','286773','286774','286775','286776','286777','286778','286779','286780','286832','286845','286851','286866','286887','287009','287032','287188','287982','288153','288253','288316','288442','288486','288492','288501','288513','288514','288577','288593','288866','288988','289118','289186','289476','291584','291614','291757','291758','291759','291834','291845','291875','291943','291981','292028','292030','292047','292065','292066','292250','292257','292271','292295','292323','292324','292331','292332','292345','292383','292489','292519','292522','292526','292568','292645','292782','293245','293249','293517','293532','293558','293594','293599','293620','293622','293623','293624','293625','293986','294065','294149','294223','294224','294296','294492','294540','294541','294542','294779','294882','294885','294930','294931','294932','295496','295499','295538','295542','295545','295609','295710','295711','295786','296205','296207','296208','296209','296211','296212','296280','297090','297182','297226','297265','297477','297565','297803','297831','298009','298023','298044','298135','298219','298278','298316','298475','298492','298503','298521','298551','298555','298556','298599','299032','299033','299037','299041','299087','299150','299151','299153','299154','299155','299169','299198','299387','299609','299672','299730','299752','299802','299878','300021','300189','300210','300211','300297','300299','300318','300370','300546','300671','300697','300923','301030','301058','301833','301884','301889','301916','301917','301943','302085','302196','303802','303816','141443','141448','141449','141577','141636','141637','141698','141699','141700','141701','141702','141703','141888','141889','141915','141927','141946','141947','142059','142060','142061','142182','142231','142900','142901','142921','143054','143176','143246','143247','143248','143272','143389','143445','143577','143681','144038','146553','147047','148034','148035','148166','148583','149703','149704','150596','150801','150916','151013','151095','151154','151312','151313','151431','151481','151797','151837','152536','153241','153621','153782','153808','153945','154126','154156','154257','154348','154466','154471','154472','154497','154499','154548','154610','154761','154768','154773','154872','154875','155187','155240','156263','156264','156265','156266','156268','156895','156896','156897','156898','156899','156900','156901','156902','156903','156904','156905','156906','156907','156908','156909','156910','156911','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156938','156939','156940','156941','156942','156943','156944','156945','156946','156947','156948','156949','156950','156951','156952','156954','156957','157604','157605','157606','157607','157608','157609','157610','157611','157612','157613','157614','157615','157616','157617','157618','157628','157629','157839','158031','158039','158040','158041','158042','158043','158044','158046','158047','158048','158049','158050','158063','158064','158065','158069','158074','158075','158076','158132','158133','158144','158173','158219','158550','158597','158598','158709','158738','159209','159217','159332','159559','159733','159878','159879','159880','159881','159882','159908','159990','159993','160001','160893','160957','160994','160999','161180','161294','161319','161646','161647','161648','161649','161650','161651','161652','161653','161654','161655','161656','161657','161658','161659','161660','161661','161662','161663','161664','161665','161666','161824','161825','161834','161931','162260','162391','162547','162548','162768','162787','163224','163515','163845','163846','163883','164010','164016','164049','164210','164270','164442','164498','164629','164703','164837','164925','164938','164939','164986','165586','165591','165690','165775','165903','166179','166550','166551','166564','166572','167058','167279','167621','167769','167859','167869','168055','168076','168159','168252','168368','169135','169136','169213','169750','169824','169889','170137','170140','170420','170589','170618','170640','201155','202768','202773','202835','211186','211187','211188','211189','211190','211191','211192','211193','211194','211195','211196','211197','211198','211199','211200','211201','211202','211203','211204','211205','215268','215283','215383','215424','215580','215825','215826','215827','215851','215906','216009','216010','216090','232546','232635','232711','232759','232762','232779','238033','238035','238036','238183','238336','238398','238406','238504','238547','238579','238629','238713','238714','238746','238747','238748','238749','238750','238751','238752','238753','238754','238755','238756','238757','238758','238759','238760','238761','238762','238763','238846','238847','239122','239141','239158','239170','239283','239312','239325','239414','239415','239416','239417','239418','239419','239420','239421','239422','239423','239424','239425','239426','239427','239428','239429','239430','239431','239432','239433','239434','239435','239436','239437','239438','239439','239440','239554','239909','239910','239911','239912','240093','240296','240411','240589','241042','241303','241304','241522','241523','241524','241525','241740','242005','242150','242205','242217','242446','243432','243806','243807','243808','243963','244171','244313','244330','244331','244332','244334','244335','244343','244360','244563','244948','245587','245651','245812','245813','245814','246017','246018','246228','246239','246252','246253','246612','246712','246980','247105','247146','247344','247519','247550','247963','247967','248007','248085','248456','248571','248810','248978','249109','249181','249348','249415','249706','249825','249856','250158','250159','251043','251351','251459','251495','251517','251518','251645','251747','251955','253506','253876','254327','254344','254538','254864','255236','255307','255611','255671','255862','256112','256148','256365','256517','256813','262377','262644','262769','263095','263507','263565','264429','264452','264453','264454','264678','264747','264877','265006','265143','265235','265370','265494','265522','265754','266172','266221','266895','267024','267052','267053','267087','267333','268353','268514','268517','268542','268845','268910','269211','269320','269366','269398','273498','274140','274158','274430','274476','274485','274607','274773','275243','275340','275524','275548','275554','276014','276060','276486','276540','276561','276804','276974','277222','277464','278307','278843','279592','280342','280368','280933','281489','281617','282143','282843','283313','283637','283666','284146','284206','284293','284644','285451','285489','285685','286000','286781','286782','286783','286784','286785','286786','286787','286788','286789','286790','286791','286792','286793','286794','291891','292087','292218','292613','292631','292904','293217','293621','294881','294892','295515','295536','297212','297562','297651','298045','298554','299228','299240','299407','299455','299889','299892','300222','300559','300569','300649','301817','301820','302346','148050','148146','151695','151696','153512','153513','153727','154221','154882','155013','157268','157269','157826','158194','158306','158414','158418','158806','158807','159506','159583','159781','159980','160189','160260','160375','160475','161360','162179','162359','162895','163656','164370','164418','164865','165087','165170','165353','165490','166232','166627','166991','167225','167366','167428','167504','167601','167675','168243','170461','215478','232553','232794','238219','238841','238842','238972','239792','240254','240255','240396','240410','240533','240724','240808','240952','240972','241439','241440','241476','242120','242514','242896','243797','243946','244318','244345','244679','244895','245296','245297','245457','245514','246270','248207','248235','248361','248770','248886','248956','249015','249016','249304','249592','249665','249838','249841','250129','250247','250588','251003','251133','251235','251238','251456','251490','251549','251618','251657','251731','251944','252051','253682','254892','255244','255460','255588','256484','256666','256799','256849','256855','256863','261739','262090','262401','263097','263109','263193','263566','263650','264720','264721','264722','264723','264724','264871','265025','265026','265110','265852','265983','266900','266969','267045','267160','267662','267825','267858','268107','268119','268588','269363','269400','273457','273476','273644','273712','273715','273892','275058','275475','275620','275838','275976','276209','276978','277201','277227','277791','277795','277932','278103','278412','280395','280396','280976','281316','281327','281582','282485','282544','282850','283333','284591','284600','284833','285075','285221','286341','286342','287548','288178','288216','288506','288586','291741','292585','292617','292770','293612','293994','294511','295377','295835','296213','296219','297020','297271','297575','297926','298203','300909','301778','302164','141806','151814','154890','158679','160313','160394','160462','161114','161483','161540','161572','162174','162467','162931','163168','163183','163294','163295','163492','163549','163708','164148','165079','165820','165960','166590','167285','167352','167355','167544','168037','170132','218999','238817','240121','240122','241272','241437','241438','242148','242390','242591','242944','243074','243433','243839','243920','244341','244649','245586','245685','245789','246075','246254','246290','246751','246752','246847','246948','247155','247813','248152','248153','248671','248816','251263','251304','251334','253473','253899','254386','254554','254795','254798','254834','254966','254980','254981','256717','256815','256973','262076','264483','264556','264839','265411','266359','266540','266994','267242','267401','268139','268842','269059','269505','269551','274086','274148','274232','274364','274509','274803','275111','275253','276057','276392','276539','276640','277378','278432','278781','278785','279208','279371','281825','281826','283643','283762','284223','285647','285909','285929','285930','285931','286219','287540','287778','287789','288665','289300','291603','291604','291605','291606','291607','291608','291609','291790','291817','292022','292023','292024','292285','293401','294008','294063','294172','294215','294216','294219','294677','294823','294886','294916','294917','294918','295516','295596','295652','297241','297595','298117','298119','298210','298254','298255','298256','298257','298289','299084','299104','299195','299202','299241','299242','299245','299247','299248','299249','299250','299684','299779','299780','299781','299782','299783','299784','299859','299860','299926','299927','300663','301958','301959','301960','301961','301962','301963','301964','301965','301966','301967','160187','160188','167280','251283','273767','275241','276593','278832','278833','280835','283496','285941','286392','296255','297826','299295','301861','302119') 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 ('141443','141448','141449','141577','141636','141637','141698','141699','141700','141701','141702','141703','141806','141888','141889','141915','141927','141946','141947','141989','141990','142059','142060','142061','142182','142231','142876','142900','142901','142921','143054','143155','143156','143176','143246','143247','143248','143272','143323','143359','143389','143445','143577','143618','143645','143659','143681','144038','144218','146553','147047','148034','148035','148050','148146','148166','148583','149615','149663','149703','149704','150596','150801','150819','150916','150962','150963','150964','151013','151093','151094','151095','151154','151312','151313','151431','151481','151569','151695','151696','151797','151814','151815','151837','151941','151955','152536','153241','153512','153513','153544','153621','153727','153782','153808','153815','153945','154126','154156','154221','154257','154348','154466','154471','154472','154497','154499','154548','154554','154575','154610','154722','154726','154750','154761','154768','154770','154771','154773','154832','154872','154875','154882','154890','154892','155013','155187','155202','155240','156263','156264','156265','156266','156268','156895','156896','156897','156898','156899','156900','156901','156902','156903','156904','156905','156906','156907','156908','156909','156910','156911','156912','156913','156914','156915','156916','156917','156918','156919','156920','156921','156922','156923','156924','156925','156926','156927','156928','156929','156930','156931','156932','156933','156934','156935','156936','156937','156938','156939','156940','156941','156942','156943','156944','156945','156946','156947','156948','156949','156950','156952','156953','156954','156955','156956','156957','156958','157268','157269','157604','157605','157606','157607','157608','157609','157610','157611','157612','157613','157614','157615','157616','157617','157618','157619','157620','157621','157628','157629','157826','157839','157926','157927','157958','157959','157960','158009','158017','158018','158031','158039','158040','158041','158042','158043','158044','158046','158047','158048','158049','158050','158063','158064','158065','158069','158074','158075','158076','158077','158132','158133','158144','158173','158194','158219','158284','158299','158306','158316','158342','158343','158344','158345','158414','158418','158499','158550','158597','158598','158650','158679','158682','158683','158684','158709','158738','158806','158807','158832','158870','158871','159046','159084','159085','159209','159217','159332','159334','159380','159444','159505','159506','159508','159559','159573','159574','159583','159733','159780','159781','159830','159878','159879','159880','159881','159882','159908','159968','159969','159980','159990','159993','160001','160167','160168','160187','160188','160189','160260','160282','160313','160375','160394','160426','160461','160462','160475','160502','160621','160633','160644','160663','160714','160804','160843','160883','160893','160913','160957','160978','160981','160987','160994','160999','161035','161053','161111','161114','161115','161149','161150','161180','161187','161188','161294','161310','161319','161360','161368','161378','161483','161540','161556','161572','161591','161646','161647','161648','161649','161650','161651','161652','161653','161654','161655','161656','161657','161658','161659','161660','161661','161662','161663','161664','161665','161666','161744','161745','161771','161790','161793','161811','161824','161825','161834','161900','161923','161931','161944','161969','161984','162004','162021','162038','162106','162126','162174','162179','162190','162260','162359','162391','162408','162467','162547','162548','162598','162599','162605','162607','162611','162703','162768','162787','162837','162890','162895','162912','162913','162930','162931','162975','162983','163007','163010','163021','163061','163077','163168','163169','163170','163171','163183','163224','163245','163246','163247','163248','163294','163295','163370','163414','163419','163433','163481','163491','163492','163496','163515','163549','163591','163656','163708','163753','163791','163836','163842','163845','163846','163883','163905','163994','164010','164014','164015','164016','164049','164067','164116','164148','164149','164150','164151','164152','164201','164210','164270','164370','164418','164442','164453','164462','164463','164490','164491','164498','164529','164531','164600','164629','164703','164740','164822','164837','164847','164865','164925','164938','164939','164986','164998','165041','165079','165087','165170','165241','165245','165285','165353','165419','165490','165586','165591','165603','165643','165690','165775','165820','165903','165960','165967','166114','166129','166179','166232','166279','166550','166551','166564','166572','166590','166593','166627','166683','166748','166751','166802','166982','166991','167000','167045','167058','167064','167065','167168','167172','167225','167275','167279','167280','167285','167306','167352','167355','167366','167368','167428','167439','167504','167535','167544','167588','167591','167595','167601','167621','167675','167682','167690','167692','167769','167798','167857','167859','167869','167870','167882','167885','168037','168055','168076','168159','168168','168171','168243','168247','168252','168298','168316','168317','168368','169135','169136','169213','169750','169824','169889','170132','170137','170140','170149','170242','170346','170420','170421','170422','170423','170425','170426','170427','170456','170461','170589','170618','170640','170699','170719','201153','201155','202582','202583','202768','202773','202810','202835','211173','211174','211175','211176','211177','211178','211179','211180','211181','211182','211183','211184','211185','211186','211187','211188','211189','211190','211191','211192','211193','211194','211195','211196','211197','211198','211199','211200','211201','211202','211203','211204','211205','213178','213179','213180','213181','213182','213183','213184','213185','213186','213187','213188','213189','213190','213191','213192','213193','215268','215282','215283','215316','215383','215424','215478','215484','215532','215580','215769','215825','215826','215827','215851','215906','216009','216010','216090','216102','218777','218999','232459','232546','232553','232634','232635','232688','232711','232759','232762','232779','232794','238033','238035','238036','238050','238091','238092','238151','238180','238183','238219','238324','238329','238336','238338','238340','238341','238398','238406','238444','238504','238547','238579','238628','238629','238713','238714','238746','238747','238748','238749','238750','238751','238752','238753','238754','238755','238756','238757','238758','238759','238760','238761','238762','238763','238817','238841','238842','238846','238847','238972','239032','239033','239120','239121','239122','239123','239124','239125','239126','239141','239158','239170','239272','239273','239281','239282','239283','239291','239292','239297','239308','239312','239320','239325','239350','239351','239352','239353','239395','239414','239415','239416','239417','239418','239419','239420','239421','239422','239423','239424','239425','239426','239427','239428','239429','239430','239431','239432','239433','239434','239435','239436','239437','239438','239439','239440','239452','239554','239729','239735','239792','239798','239799','239848','239909','239910','239911','239912','240022','240023','240024','240093','240121','240122','240254','240255','240296','240332','240352','240393','240396','240410','240411','240520','240533','240589','240631','240698','240724','240806','240808','240952','240972','241042','241097','241164','241192','241195','241211','241272','241303','241304','241321','241325','241411','241434','241437','241438','241439','241440','241447','241476','241506','241522','241523','241524','241525','241542','241543','241562','241676','241681','241701','241740','241804','242005','242106','242108','242120','242148','242150','242205','242217','242390','242446','242474','242484','242509','242514','242546','242591','242629','242664','242695','242697','242709','242710','242715','242730','242735','242770','242800','242810','242811','242815','242896','242914','242921','242944','243074','243141','243409','243432','243433','243438','243450','243499','243608','243655','243705','243797','243801','243806','243807','243808','243839','243919','243920','243933','243934','243946','243963','244171','244313','244318','244330','244331','244332','244334','244335','244341','244343','244345','244360','244374','244375','244376','244377','244539','244563','244649','244662','244679','244702','244772','244806','244895','244948','244983','245045','245046','245069','245076','245077','245078','245296','245297','245349','245413','245414','245457','245514','245561','245586','245587','245633','245645','245651','245657','245669','245678','245685','245789','245797','245812','245813','245814','245827','245828','245860','245861','245862','245863','245864','245865','245867','245868','245869','245871','245875','245876','245877','245905','245906','245940','245941','245985','246017','246018','246075','246079','246099','246105','246201','246221','246228','246235','246239','246252','246253','246254','246270','246290','246291','246304','246316','246317','246318','246319','246320','246321','246322','246323','246327','246332','246424','246489','246501','246528','246529','246531','246564','246611','246612','246625','246639','246642','246675','246712','246751','246752','246787','246788','246823','246844','246845','246846','246847','246884','246900','246948','246970','246980','247006','247007','247094','247105','247146','247155','247167','247177','247185','247309','247317','247344','247392','247398','247404','247415','247513','247519','247537','247538','247550','247571','247573','247654','247668','247672','247755','247756','247757','247812','247813','247849','247953','247963','247967','247969','248007','248013','248050','248085','248102','248152','248153','248207','248235','248307','248361','248363','248413','248456','248478','248521','248550','248571','248581','248671','248672','248673','248674','248706','248708','248710','248770','248810','248816','248822','248886','248914','248922','248933','248956','248978','249015','249016','249018','249046','249073','249074','249084','249085','249086','249089','249109','249119','249181','249197','249287','249304','249329','249348','249349','249413','249415','249417','249448','249450','249451','249490','249492','249516','249592','249665','249706','249816','249825','249838','249841','249856','249939','249940','249941','250059','250081','250107','250129','250158','250159','250173','250174','250196','250197','250209','250227','250247','250588','250760','250817','250825','250871','250872','250873','250876','250879','250975','250976','251003','251009','251043','251086','251103','251104','251126','251127','251128','251129','251133','251235','251238','251263','251283','251298','251304','251334','251351','251382','251419','251444','251456','251459','251464','251490','251495','251517','251518','251549','251618','251645','251657','251705','251711','251713','251722','251731','251747','251804','251903','251944','251955','251991','251992','252051','252078','252079','252136','252219','253017','253123','253124','253143','253276','253288','253320','253323','253337','253473','253506','253682','253716','253748','253838','253839','253840','253856','253866','253872','253876','253891','253895','253899','254327','254344','254386','254391','254527','254538','254554','254555','254683','254782','254795','254798','254833','254834','254864','254871','254892','254904','254966','254980','254981','254989','254993','255042','255043','255057','255066','255154','255178','255198','255201','255218','255236','255237','255244','255305','255307','255332','255338','255427','255460','255565','255588','255611','255635','255671','255729','255862','255871','256068','256112','256148','256158','256161','256186','256365','256484','256517','256666','256683','256689','256717','256736','256743','256778','256799','256813','256815','256849','256855','256863','256917','256973','257090','257091','257092','257094','257138','257164','257175','257234','261702','261704','261739','261946','262076','262089','262090','262114','262246','262249','262293','262336','262338','262356','262359','262376','262377','262401','262507','262509','262552','262644','262657','262698','262713','262769','263018','263026','263027','263093','263094','263095','263097','263109','263110','263132','263193','263455','263507','263515','263539','263562','263565','263566','263607','263650','263673','263701','264406','264411','264422','264428','264429','264452','264453','264454','264483','264556','264675','264678','264720','264721','264722','264723','264724','264745','264747','264802','264839','264871','264877','264919','264965','264997','264998','265006','265016','265025','265026','265046','265052','265053','265110','265143','265235','265337','265369','265370','265377','265411','265494','265516','265517','265522','265561','265564','265570','265596','265606','265620','265622','265676','265744','265754','265756','265777','265815','265852','265855','265902','265976','265983','265999','266055','266140','266172','266221','266243','266265','266269','266292','266296','266359','266380','266394','266435','266481','266487','266540','266541','266551','266661','266745','266754','266758','266879','266895','266900','266902','266969','266978','266994','267017','267024','267045','267052','267053','267061','267063','267087','267160','267165','267242','267333','267401','267423','267468','267662','267820','267825','267858','267983','268067','268107','268119','268139','268283','268315','268353','268514','268517','268540','268542','268548','268551','268552','268573','268588','268609','268626','268664','268735','268750','268752','268761','268842','268845','268910','269059','269123','269211','269230','269320','269363','269366','269398','269400','269505','269551','269564','269751','273336','273394','273436','273454','273457','273476','273483','273498','273542','273562','273644','273712','273715','273767','273870','273872','273884','273892','273998','274086','274140','274144','274148','274158','274232','274357','274363','274364','274368','274369','274430','274476','274484','274485','274502','274509','274607','274665','274670','274699','274710','274715','274721','274771','274773','274776','274803','274848','274885','275002','275058','275111','275195','275197','275198','275207','275208','275210','275241','275243','275253','275340','275475','275524','275544','275548','275554','275567','275620','275641','275688','275812','275838','275844','275845','275949','275973','275975','275976','276014','276035','276057','276060','276086','276101','276157','276209','276286','276287','276352','276353','276354','276362','276392','276486','276527','276539','276540','276561','276593','276640','276804','276814','276815','276818','276949','276950','276954','276956','276969','276970','276974','276978','276987','277201','277222','277227','277257','277309','277378','277395','277464','277490','277518','277519','277538','277583','277791','277795','277796','277896','277932','277966','278020','278023','278103','278126','278146','278213','278266','278302','278307','278412','278432','278465','278485','278593','278594','278597','278598','278758','278781','278785','278832','278833','278843','278845','278850','278851','279147','279165','279171','279208','279254','279255','279265','279310','279311','279312','279313','279371','279391','279429','279462','279533','279592','279662','279672','279673','279682','279695','279765','280342','280368','280395','280396','280418','280450','280534','280536','280569','280605','280607','280608','280835','280919','280933','280938','280976','280997','281020','281070','281197','281316','281327','281420','281489','281582','281594','281617','281622','281784','281785','281789','281825','281826','282073','282077','282110','282143','282152','282485','282510','282544','282773','282775','282843','282850','282935','283012','283203','283215','283313','283333','283435','283496','283581','283584','283637','283642','283643','283648','283666','283762','283790','284146','284170','284171','284172','284173','284206','284223','284238','284272','284293','284352','284513','284591','284600','284644','284833','284856','285075','285102','285186','285221','285451','285458','285464','285489','285491','285534','285536','285537','285545','285546','285647','285685','285779','285882','285885','285886','285906','285909','285910','285920','285929','285930','285931','285932','285941','285955','286000','286088','286112','286203','286219','286244','286293','286341','286342','286392','286430','286431','286432','286586','286645','286652','286653','286664','286672','286673','286674','286675','286676','286677','286678','286679','286680','286681','286682','286683','286684','286685','286686','286687','286688','286689','286690','286691','286692','286693','286694','286695','286696','286697','286698','286699','286700','286701','286702','286703','286704','286705','286706','286707','286708','286709','286710','286711','286712','286713','286714','286715','286716','286717','286718','286719','286720','286721','286722','286723','286724','286725','286726','286727','286728','286729','286730','286731','286732','286733','286734','286735','286736','286737','286738','286739','286740','286741','286742','286743','286744','286745','286746','286747','286748','286749','286750','286751','286752','286753','286754','286755','286756','286757','286758','286759','286760','286761','286762','286763','286764','286765','286766','286767','286768','286769','286770','286771','286772','286773','286774','286775','286776','286777','286778','286779','286780','286781','286782','286783','286784','286785','286786','286787','286788','286789','286790','286791','286792','286793','286794','286832','286845','286851','286866','286887','287009','287032','287188','287540','287548','287778','287789','287982','288153','288178','288216','288253','288316','288442','288486','288492','288501','288506','288513','288514','288577','288586','288593','288665','288866','288988','289118','289186','289300','289476','291584','291603','291604','291605','291606','291607','291608','291609','291614','291741','291757','291758','291759','291790','291817','291834','291845','291875','291891','291943','291981','292022','292023','292024','292028','292030','292047','292065','292066','292087','292218','292250','292257','292271','292285','292295','292323','292324','292331','292332','292345','292383','292489','292519','292522','292526','292568','292585','292613','292617','292631','292645','292770','292782','292904','293217','293245','293249','293401','293517','293532','293558','293594','293599','293612','293620','293621','293622','293623','293624','293625','293986','293994','294008','294063','294065','294149','294172','294215','294216','294219','294223','294224','294296','294492','294511','294540','294541','294542','294677','294779','294823','294881','294882','294885','294886','294892','294916','294917','294918','294930','294931','294932','295377','295496','295499','295515','295516','295536','295538','295542','295545','295596','295609','295652','295710','295711','295786','295835','296205','296207','296208','296209','296211','296212','296213','296219','296255','296280','297020','297090','297182','297212','297226','297241','297265','297271','297477','297562','297565','297575','297595','297651','297803','297826','297831','297926','298009','298023','298044','298045','298117','298119','298135','298203','298210','298219','298254','298255','298256','298257','298278','298289','298316','298475','298492','298503','298521','298551','298554','298555','298556','298599','299032','299033','299037','299041','299084','299087','299104','299150','299151','299153','299154','299155','299169','299195','299198','299202','299228','299240','299241','299242','299245','299247','299248','299249','299250','299295','299387','299407','299455','299609','299672','299684','299730','299752','299779','299780','299781','299782','299783','299784','299802','299859','299860','299878','299889','299892','299926','299927','300021','300189','300210','300211','300222','300297','300299','300318','300370','300546','300559','300569','300649','300663','300671','300697','300909','300923','301030','301058','301778','301817','301820','301833','301861','301884','301889','301916','301917','301943','301958','301959','301960','301961','301962','301963','301964','301965','301966','301967','302085','302119','302164','302196','302346','303802','303816') GROUP BY `manuf` ORDER BY `manuf` ASC