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 ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') 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 ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: ip
SELECT `ip`,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 `ip` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `ip` ORDER BY `ip` ASC
childsstroke1: ip
SELECT `ip`,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 `ip` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `ip` ORDER BY `ip` ASC
childsstroke: regul
SELECT `regul`,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 `regul` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `regul` ORDER BY `regul` ASC
childsstroke1: regul
SELECT `regul`,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 `regul` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `regul` ORDER BY `regul` ASC
childsstroke: out_voltage
SELECT `out_voltage`,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 `out_voltage` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `out_voltage` ORDER BY `out_voltage` ASC
childsstroke1: out_voltage
SELECT `out_voltage`,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 `out_voltage` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `out_voltage` ORDER BY `out_voltage` ASC
childsstroke1: SELECT `power`,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 `power` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `power` ORDER BY `power` ASC
childsstroke: out_current
SELECT `out_current`,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 `out_current` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `out_current` ORDER BY `out_current` ASC
childsstroke1: out_current
SELECT `out_current`,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 `out_current` !='' AND `modx_site_content`.`id` IN ('153058','153623','153757','154538','154539','154543','154662','154663','155602','156858','157669','158259','158589','158590','158610','158888','158889','158890','158891','158892','158893','158894','158895','158896','158897','158898','158899','158900','158901','158902','158903','158904','158957','159446','159538','159539','159540','159594','159891','159892','159893','159894','160599','160662','160766','160831','160938','160939','160942','160943','160945','160946','161154','161286','161287','161288','161289','161290','161291','161292','161399','162014','162240','162759','162760','162809','162811','163002','163044','163147','163436','163566','163593','163595','163596','163606','163686','163894','163925','163967','164025','164114','164273','164274','164287','164288','164479','164480','164481','164482','164483','164694','164741','164821','164961','164994','165191','165393','165470','165880','165946','165947','166033','166034','166393','166394','166502','166503','166504','166506','166507','166508','166613','166682','166782','166897','166948','167006','167007','167008','167009','167010','167011','167013','167014','167066','167220','167362','167422','167423','167603','167705','167718','167719','167846','168138','168262','168305','238216','238298','238332','238598','238667','238668','238741','238742','238870','238951','239096','239235','239236','239237','239238','239239','239240','239241','239242','239243','239244','239245','239246','239247','239501','239641','239701','240091','240094','240534','240535','240536','240537','240538','240539','240540','240541','240542','240543','240544','240545','240546','240547','241483','241484','241485','241486','241487','242304','242576','242856','242899','243043','243168','243524','243559','243675','243684','243727','243957','243958','244104','244370','244749','245113','245838','246028','246037','246131','246177','246468','246498','246604','246649','246655','246692','246825','247396','247414','247746','247867','248451','249039','249040','249041','249043','249044','249139','249389','249814','250228','250229','250230','250231','250232','250336','250600','250957','251004','251134','251157','251413','251414','251424','251506','251513','251635','251664','251768','251797','251831','251853','252056','252106','252107','252143','252207','252251','252252','252253','252254','252255','252256','252257','252258','252259','252260','253121','253190','253270','253280','253281','253282','253458','253465','253603','253650','253752','253798','253799','253836','254406','254408','254649','254708','255115','255149','255184','255221','255335','255455','255485','255486','255490','255491','255492','255602','255625','255628','255647','255709','255725','256121','256215','256252','256661','256715','256871','257150','257240','257241','257242','257243','257244','257245','257246','257247','257248','257249','257250','257251','257252','257253','257254','257255','257256','257257','257258','257259','257260','257261','257262','257263','257264','257265','257266','257267','257268','257269','257270','257271','257272','257273','257274','257275','257276','257277','257278','257279','262252','262392','262413','262534','262642','262795','262814','262868','263509','264368','264390','264907','264920','264944','264954','265108','265113','265139','265162','265301','265310','265338','265486','265487','265492','265664','265665','265667','265958','266157','266378','266574','266736','266807','266808','266809','266840','266882','267025','267185','267489','267498','267548','267940','267989','268126','268131','268155','268195','268351','268411','268446','268495','268597','268644','268801','268803','269085','269092','269611','269757','273576','273593','273842','273973','274316','274798','275054','275088','276046','276102','276355','276397','276965','276966','276967','277505','277670','277774','278003','278077','278078','278770','279116','279206','279303','279476','279521','279540','279838','279839','279840','279841','279842','279843','279844','279845','279846','279847','279848','279849','279850','279851','279852','279853','279854','279855','279856','279857','279858','279859','279860','279861','279862','279863','279864','279865','279866','279867','279868','279869','279870','279871','279872','279873','279874','279875','279876','279877','279878','279879','280039','280040','280041','280042','280043','280044','280045','280046','280047','280170','280171','280172','280173','280181','280182','280183','280184','280185','280186','280187','280188','280189','280190','280191','280192','280193','280194','280195','280196','280197','280198','280199','280200','280201','280202','280203','280204','280235','280904','281413','281650','281711','281722','282061','282396','282520','282568','282822','282905','282939','283009','283564','284421','285011','285013','285311','285425','285492','285570','285618','285823','285966','286284','286429','286565','286566','286567','286568','286569','286570','286571','286572','286573','286574','286575','286576','286577','286578','286579','287104','288151','288170','288440','288662','289207','289302','289442','291893','292011','292013','292274','292397','292582','292785','292907','292908','292909','292910','292911','292912','292913','292914','292915','292916','292917','292918','292919','292920','292921','292922','292923','292924','292925','292926','292948','292949','292950','292951','292952','292953','292954','292955','292956','292957','292958','292959','292960','292961','292962','292963','292964','292965','292966','292967','292968','292969','292970','292971','292972','292995','292996','292997','292998','292999','293000','293001','293002','293003','293004','293005','293006','293007','293008','293009','293010','293011','293012','293013','293014','293035','293036','293037','293038','293039','293040','293041','293042','293043','293044','293067','293068','293069','293070','293071','293072','293073','293074','293075','293076','293077','293078','293079','293080','293081','293082','293083','293084','293085','293086','293087','293112','293113','293114','293115','293116','293117','293118','293119','293124','293125','293126','293127','293128','293132','293133','293134','293135','293136','293149','293150','293151','293152','293153','293154','293160','293161','293162','293163','293164','293165','293166','293167','293168','293171','293172','293173','293174','293175','293176','293177','293178','293179','293180','293181','293182','293185','293187','293246','293299','293301','293302','293304','293309','293311','293312','293313','293315','293316','293317','293318','293319','293524','293852','293853','293854','293855','293858','293860','293943','293944','293945','293946','293947','293948','293949','293950','293951','293952','293953','293954','293955','293956','293957','293958','293959','293960','293961','293962','293963','293964','293965','293966','293967','293968','293969','293970','293971','293972','293973','293974','293975','293976','293977','293978','293979','293980','294336','294366','294640','294810','295405','295415','295435','295617','295638','296021','296022','296023','296024','296025','296026','296027','296028','296029','296030','296031','296032','296033','296034','296035','296036','296037','296038','296039','296040','296041','296042','296043','296044','296045','296046','296047','296048','296049','296050','296051','296052','296053','296054','296055','296056','296057','296058','296059','296060','296061','296062','296063','296064','296065','296066','296067','296068','296069','296070','296071','296072','296073','296074','296075','296076','296077','296078','296079','296080','296081','296082','296083','296084','296085','296086','296087','296088','296089','296090','296091','296092','296093','296094','296095','296096','296097','296098','296099','296100','296101','296102','296107','296108','296110','296111','296113','296114','296116','296117','296119','296120','296121','296123','296124','296125','296127','296128','296130','296131','296133','296134','296135','296177','296178','296179','296180','296304','296305','296306','296307','296308','296309','296310','296311','296312','296313','296314','296315','296316','296317','296318','296319','296320','296321','296322','296323','296404','296405','296406','296407','296408','296409','296410','296411','296412','296413','296414','296415','296416','296417','296418','296419','296420','296421','296422','296423','296424','296425','296426','296427','296428','296429','296430','296431','296432','296433','296434','296435','296436','296437','296438','296439','296440','296441','296442','296443','296444','296445','296446','296447','296448','296449','296450','296451','296452','296453','296454','296455','296456','296457','296458','296459','296460','296461','296479','296480','296481','296482','296483','296484','296485','296486','296487','296488','296489','296490','296491','296492','296493','296494','296495','296496','296497','296498','296499','296500','296501','296502','296503','296504','296505','296506','296507','296508','296509','296510','296511','296512','296513','296514','296515','296516','296517','296518','296519','296520','296521','296522','296523','296524','296525','296526','296527','296528','296529','296530','296531','296532','296533','296534','296535','296536','296537','296538','296539','296540','296541','296542','296543','296544','296545','296546','296547','296548','296549','296564','296565','296566','296567','296568','296569','296570','296571','296572','296573','296574','296575','296576','296577','296578','296579','296580','296581','296582','296583','296584','296585','296586','296587','296588','296589','296590','296591','296592','296593','296594','296595','296596','296597','296598','296599','296600','296601','296602','296603','296604','296605','296606','296607','296608','296609','296610','296611','296612','296613','296614','296615','296616','296617','296618','296619','296620','296621','296622','296623','296624','296625','296626','296627','296629','296630','296631','296632','296633','296634','296635','296636','296637','296638','296639','296640','296641','296642','296643','296644','296645','296646','296647','296648','296649','296650','296651','296652','296653','296654','296655','296656','296657','296658','296659','296660','296661','296662','296663','296664','296665','296666','296667','296668','296669','296670','296671','296672','296673','296674','296675','296676','296677','296678','296679','296680','296681','296682','296683','296684','296685','296686','296687','296688','296689','296690','296691','296692','296693','296694','296695','296696','296697','296698','296699','296824','296825','296826','296827','296828','296829','296830','296831','296832','296833','296834','296835','296836','296837','296838','296839','296840','296841','296842','296843','296844','296845','296846','296847','296848','296849','296850','296851','296852','296853','296854','296855','296856','296857','296858','296859','296860','296861','296862','296863','296864','296865','296866','296867','296868','296869','296870','296871','296872','296873','296874','296875','296876','296877','296878','296879','296880','296881','296882','296883','296884','296885','296886','296887','296888','296889','296890','296891','296892','296893','296894','296926','296927','296928','296929','296930','296931','296932','296933','296934','296935','296936','296937','296938','296939','296940','296941','296942','296943','296944','296945','296946','296947','296948','296949','296950','296951','296952','296953','296954','296955','296956','296957','296958','296959','296960','296961','296962','296963','296964','296965','296969','296970','296971','296972','296973','296974','296975','296976','296977','296978','296979','296980','296981','296982','296983','296984','296985','296986','296987','296988','296989','296990','296991','296992','296993','296994','296995','296996','296997','296998','296999','297000','297001','297002','297003','297004','297005','297006','297007','297008','297049','297050','297051','297053','297054','297055','297056','297057','297058','297059','297060','297061','297075','297076','297077','297079','297080','297081','297570','298076','298726','298727','298728','298729','298730','298731','298732','298733','298734','298735','298736','298737','298738','298739','298740','298743','298744','298745','298746','298747','298748','298783','298784','298785','298786','298787','298788','298789','298790','298871','298889','298890','298891','298892','298893','298906','298920','298921','298922','298923','298924','298925','298952','298953','298954','298955','298956','298957','298958','298959','298960','298984','298985','298986','298987','298988','298989','298990','298991','298992','298993','298994','298995','298996','298997','298998','298999','299000','299001','299002','299003','299004','299005','299006','299007','299008','299009','299010','299011','299012','299013','299014','299015','299016','299017','299018','299019','299020','299021','299022','299023','299024','299025','299026','299027','299028','299467','299710','299945','300394','300403','301022','301069','301070','301071','301072','301073','301074','301075','301076','301077','301078','301079','301080','301081','301082','301083','301084','301085','301086','301087','301088','301089','301090','301091','301092','301093','301094','301095','301096','301097','301098','301099','301100','301101','301102','301103','301104','301105','301106','301107','301108','301109','301110','301111','301112','301113','301114','301115','301116','301117','301118','301119','301120','301121','301122','301123','301124','301125','301126','301127','301128','301129','301130','301131','301132','301133','301134','301135','301136','301137','301138','301139','301140','301141','301142','301143','301144','301145','301146','301147','301148','301149','301150','301151','301152','301153','301154','301155','301156','301157','301158','301159','301160','301161','301162','301163','301164','301165','301166','301167','301168','301169','301170','301171','301172','301173','301174','301175','301176','301177','301178','301179','301180','301181','301182','301183','301184','301185','301186','301187','301188','301189','301190','301191','301192','301193','301194','301195','301196','301197','301198','301199','301200','301201','301202','301203','301204','301205','301206','301207','301208','301209','301210','301211','301212','301213','301214','301215','301216','301217','301218','301219','301220','301221','301222','301223','301224','301225','301226','301227','301228','301229','301230','301231','301232','301233','301234','301679','301680','301681','301682','301683','301684','301685','301686','301687','301748','301749','301750','301751','301752','301753','301754','301755') GROUP BY `out_current` ORDER BY `out_current` ASC
