childsstroke: fuse_size
SELECT `fuse_size`,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 `fuse_size` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149057','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151397','151475','153773','154231','154571','154661','154679','154730','154791','154944','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157824','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162134','162135','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168122','168152','169179','169317','169328','169337','169734','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206673','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245044','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','250790','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253626','253627','253628','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263124','263514','263660','264449','264789','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277193','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277646','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294465','294466','294467','294468','294469','294470','294471','294472','294473','294474','294475','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','295802','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `fuse_size` ORDER BY `fuse_size` ASC
childsstroke1: fuse_size
SELECT `fuse_size`,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 `fuse_size` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151475','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','169179','169317','169328','169337','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `fuse_size` ORDER BY `fuse_size` ASC
childsstroke: max_current
SELECT `max_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 `max_current` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149057','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151397','151475','153773','154231','154571','154661','154679','154730','154791','154944','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157824','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162134','162135','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168122','168152','169179','169317','169328','169337','169734','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206673','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245044','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','250790','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253626','253627','253628','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263124','263514','263660','264449','264789','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277193','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277646','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294465','294466','294467','294468','294469','294470','294471','294472','294473','294474','294475','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','295802','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `max_current` ORDER BY `max_current` ASC
childsstroke1: max_current
SELECT `max_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 `max_current` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151475','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','169179','169317','169328','169337','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `max_current` ORDER BY `max_current` ASC
childsstroke: material
SELECT `material`,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 `material` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149057','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151397','151475','153773','154231','154571','154661','154679','154730','154791','154944','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157824','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162134','162135','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168122','168152','169179','169317','169328','169337','169734','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206673','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245044','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','250790','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253626','253627','253628','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263124','263514','263660','264449','264789','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277193','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277646','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294465','294466','294467','294468','294469','294470','294471','294472','294473','294474','294475','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','295802','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `material` ORDER BY `material` ASC
childsstroke1: material
SELECT `material`,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 `material` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151475','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','169179','169317','169328','169337','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `material` ORDER BY `material` ASC
childsstroke: fuse_type
SELECT `fuse_type`,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 `fuse_type` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149057','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151397','151475','153773','154231','154571','154661','154679','154730','154791','154944','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157824','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162134','162135','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168122','168152','169179','169317','169328','169337','169734','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206673','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245044','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','250790','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253626','253627','253628','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263124','263514','263660','264449','264789','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277193','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277646','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294465','294466','294467','294468','294469','294470','294471','294472','294473','294474','294475','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','295802','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `fuse_type` ORDER BY `fuse_type` ASC
childsstroke1: fuse_type
SELECT `fuse_type`,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 `fuse_type` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151475','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','169179','169317','169328','169337','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `fuse_type` ORDER BY `fuse_type` ASC
childsstroke: manuf
SELECT `manuf`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149057','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151397','151475','153773','154231','154571','154661','154679','154730','154791','154944','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157824','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162134','162135','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168122','168152','169179','169317','169328','169337','169734','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206673','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245044','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','250790','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253626','253627','253628','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263124','263514','263660','264449','264789','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277193','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277646','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294465','294466','294467','294468','294469','294470','294471','294472','294473','294474','294475','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','295802','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') 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 ('141452','141504','141539','141540','141592','141593','141606','141607','141608','141609','141691','142013','142050','142051','142057','142058','142068','142069','142073','142074','142075','142076','142097','142202','142203','142204','142205','142206','142207','142208','142234','142235','142523','142724','142733','142734','142817','142875','143315','143410','143497','144036','144037','144215','145003','146950','147203','147207','147210','147211','147212','147213','147747','148145','148591','149049','149050','149051','149052','149053','149054','149055','149056','149058','149059','149060','149061','149643','149691','149692','150534','150739','150911','151029','151208','151209','151274','151305','151306','151307','151361','151362','151475','153773','154231','154571','154661','154679','154730','154791','155367','157423','157424','157425','157426','157427','157432','157433','157437','157438','157439','157440','157441','157442','157443','157444','157445','157446','157447','157448','157449','157450','157451','157452','157453','157454','157455','157456','157457','157665','157853','157865','157867','157869','157895','157896','157897','157899','157902','157903','157917','158339','158341','158485','158486','158685','158757','158810','158811','158813','159097','159098','159253','159259','159340','159341','159369','159552','159916','160098','160132','160157','160158','160316','160384','161137','161182','161326','161327','161423','161467','161468','161469','161470','161471','161472','161473','161474','161475','161476','161590','161809','161933','161934','161935','162029','162030','162031','162032','162080','162379','162421','162479','162480','162481','162555','162556','162557','162558','162559','162560','163542','163607','163694','163695','164070','164271','164771','165094','165195','165331','165332','165363','165379','165395','165574','165652','165731','165840','165841','165969','166344','166642','166735','166835','166883','166983','167118','167245','167790','167900','168031','168032','168084','168152','169179','169317','169328','169337','170280','170428','170619','170753','201297','201298','201299','202572','202785','202819','206640','206641','206642','206643','206644','206645','206646','206647','206648','206649','206650','206651','206652','206653','206654','206655','206656','206657','206658','206659','206660','206661','206662','206663','206664','206665','206666','206667','206668','206669','206670','206671','206672','206674','206675','206676','206677','206678','206679','206680','206681','206682','206683','206684','206685','206686','206687','206688','206689','206690','206691','206692','206693','206694','206695','206696','206697','206698','206699','206700','206701','206702','206703','206704','206705','206706','206707','206708','206709','206710','206711','206712','206713','206714','206715','206716','206717','206718','206719','206720','206721','206722','206723','206724','206725','206726','206727','206728','206729','206730','206731','206732','206733','206734','206735','206736','206737','206738','206739','206740','206741','206742','206743','206744','206745','206746','206747','206748','206749','206750','206751','206752','206753','206754','206755','206756','206757','206758','206759','206760','206761','206762','206763','206764','206765','206766','206767','206768','206769','206770','206771','206772','206773','206774','206775','206776','206777','206778','206779','206780','206781','206782','206783','206784','206785','206786','206787','206788','206789','206790','206791','206792','206793','206794','206795','206796','206797','206798','206799','206800','206801','206802','206803','206804','206805','206806','206807','206808','206809','206810','206811','206812','206813','206814','206815','206816','206817','206818','206819','206820','206821','206822','206823','206824','206825','206826','206827','206828','206829','206830','206831','206832','206833','206834','206835','206836','206837','206838','206839','206840','206841','206842','206843','206844','206845','206846','206847','206848','210489','210490','215301','215610','216038','232445','232720','238025','238042','238179','238809','239110','239111','239112','239113','239114','239115','239116','239117','239310','239356','239453','239616','239713','239714','239818','240051','240114','240200','240286','240307','240586','240786','240787','240936','240989','240990','240991','240992','241734','241735','241787','241798','241850','241851','241864','241962','241963','241964','241965','242101','242334','242341','242489','242589','242706','242927','243186','243316','243724','243725','243744','243829','244195','244223','244224','244538','244591','244755','244798','244861','244865','245534','245811','246129','246172','246285','246679','246719','246756','246934','246962','247107','247442','247543','247930','248081','248533','248761','248809','248954','249001','249002','249003','249004','249005','249354','249392','249764','249842','249893','249894','249982','249984','249985','249986','249987','250004','250005','250595','250677','251175','251217','251218','251219','251220','251288','251463','251548','251817','253376','253511','253627','253736','253846','253865','253902','254196','254326','254378','254379','254394','254771','254937','255216','255306','255458','255838','255850','256219','256223','256267','256508','256771','256782','256783','256784','256840','261757','261777','262383','262576','262754','262823','263514','263660','264449','264866','265051','265079','265152','265164','265192','265194','265195','265270','265356','265421','265536','265889','265892','265915','266095','266138','266139','266245','266322','266623','266684','266685','266686','266755','266756','266864','266880','266936','267178','267251','267289','267682','267703','268000','268066','268217','268234','268265','268600','268769','269402','269549','269597','269598','273335','273466','273613','273695','273724','274298','274411','274593','274790','274792','274842','274991','275600','275655','276130','276145','276250','276438','276532','276768','276780','276807','276941','276942','277014','277333','277359','277385','277423','277424','277524','277525','277526','277527','277528','277529','277530','277531','277633','277645','277647','277648','277689','278114','278134','278135','278188','278477','278871','279017','279061','279074','279299','279404','279698','279756','279801','280403','280538','280780','280880','280930','280931','281011','281112','281330','281685','281741','281859','282144','282356','282421','282777','282912','282923','283058','283059','283330','283792','284152','284153','284994','285035','285182','285244','285302','285338','285514','286322','286323','287130','287506','287780','287969','288197','288198','288199','288200','288201','288212','288260','288531','288573','288611','288664','288709','288718','288719','288755','288994','289495','289496','289503','291857','291859','291860','292245','292304','292718','292779','292873','292874','293393','293435','293436','293437','293438','293439','293440','293441','293442','293443','293444','293445','293446','293447','293448','293449','294227','294318','294358','294502','294603','294604','294634','294635','294755','295364','295365','295366','295406','295662','295732','296234','296276','297012','297138','297921','297974','297975','297978','298056','298208','298287','298288','298365','299030','299234','299409','299439','299493','299655','299755','299756','299934','299959','300259','300260','300434','300515','300620','302204','302263','302264','302289') GROUP BY `manuf` ORDER BY `manuf` ASC