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 ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') 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 ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') GROUP BY `manuf` ORDER BY `manuf` 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 ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') 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 ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') GROUP BY `out_voltage` ORDER BY `out_voltage` 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 ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') 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 ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') GROUP BY `out_current` ORDER BY `out_current` 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 ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') GROUP BY `power` ORDER BY `power` ASC
childsstroke: tip_razema
SELECT `tip_razema`,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 `tip_razema` !='' AND `modx_site_content`.`id` IN ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') GROUP BY `tip_razema` ORDER BY `tip_razema` ASC
childsstroke1: tip_razema
SELECT `tip_razema`,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 `tip_razema` !='' AND `modx_site_content`.`id` IN ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') GROUP BY `tip_razema` ORDER BY `tip_razema` ASC
childsstroke: wire_len
SELECT `wire_len`,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 `wire_len` !='' AND `modx_site_content`.`id` IN ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') GROUP BY `wire_len` ORDER BY `wire_len` ASC
childsstroke1: wire_len
SELECT `wire_len`,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 `wire_len` !='' AND `modx_site_content`.`id` IN ('153063','153941','154246','157943','158098','159673','160337','160532','161547','162064','163584','163675','163734','163999','164182','164242','164424','164436','167883','168111','168146','232686','238642','240334','240613','241775','242606','242822','244601','244692','245266','245274','245350','246811','247176','247260','248248','250341','250798','251138','252057','252156','253008','253009','253010','253011','253012','253013','253014','253015','253238','253385','253570','253571','253959','253960','253961','253962','253963','253964','253965','253966','253967','253968','253969','253970','253971','253972','253973','253974','253975','253976','253977','253978','253979','253980','253981','253982','253983','253984','253985','253986','253987','253988','253989','253990','253991','253992','253993','253994','253995','253996','253997','253998','253999','254000','254001','254002','254003','254004','254005','254006','254007','254008','254009','254010','254011','254012','254013','254014','254015','254016','254017','254018','254019','254020','254021','254022','254023','254024','254025','254026','254027','254028','254029','254030','254031','254032','254033','254034','254035','254036','254037','254038','254039','254040','254041','254042','254043','254044','254045','254046','254047','254048','254049','254050','254051','254052','254053','254054','254055','254056','254057','254058','254059','254060','254061','254062','254063','254064','254065','254066','254067','254068','254069','254070','254071','254072','254073','254074','254075','254076','254077','254078','254079','254080','254081','254082','254083','254084','254085','254086','254087','254088','254089','254090','254091','254092','254093','254094','254095','254096','254097','254098','254099','254100','254101','254102','254103','254104','254105','254106','254107','254108','254109','254110','254111','254112','254113','254114','254115','254116','254117','254118','254119','254120','254121','254122','254123','254124','254125','254126','254127','254128','254129','254130','254131','254132','254133','254134','254135','254136','254137','254138','254139','254140','254141','254142','254143','254144','254145','254146','254147','254148','254149','254150','254151','254152','254153','254154','254155','254156','254157','254158','254159','254160','254161','254162','254163','254164','254165','254166','254167','254168','254169','254170','254171','254172','254173','254174','254175','254176','254177','254178','254179','254180','254181','254182','254183','254184','254185','254186','254187','254188','254189','254190','254191','254194','254308','254638','254639','254640','254641','254642','255030','255116','255147','255334','255411','255414','255616','256171','263649','265506','266120','266799','267114','267442','268719','268802','269391','273499','274350','274868','274869','275309','277367','277639','277870','278313','279603','279604','279605','279606','279607','279608','279609','279610','279611','279612','279613','279614','279615','279616','279617','279618','279619','279620','279621','279622','279623','279624','279625','279626','279627','279628','279629','279630','279631','279632','279633','279940','279941','279942','279943','279944','279945','279946','279947','279948','279949','279950','279951','279952','279953','279954','279955','279956','279957','279958','279959','279960','279961','279962','279963','279964','279965','279966','279967','279968','279969','279970','279971','279972','279973','279974','279975','279976','279977','279978','279979','279980','279981','279982','279983','279984','279985','279986','279987','279988','279989','279990','279991','279992','279993','279994','279995','279996','279997','279998','279999','280000','280001','280002','280003','280004','280005','280006','280007','280008','280009','280174','280175','280176','280177','280178','280179','280728','282542','282553','283510','283586','283587','285086','285454','285623','286466','286467','286468','286469','286470','286471','286472','286473','286474','286475','286476','286477','286478','286479','286480','286481','286482','286483','286484','286485','286486','286487','286488','286489','286490','286491','286492','286493','286494','286495','286496','286497','286498','286499','286500','286501','286502','286503','286504','286505','286506','286507','286508','286509','286510','286511','286512','286513','286514','286515','286516','286517','286518','286519','286520','286521','286522','286523','286524','286525','286526','286527','286528','286529','286530','286531','286532','286533','286534','286535','286536','286537','286538','286539','286540','286541','286542','286543','286544','286545','286546','286547','286548','286549','286550','286551','286552','286553','286554','286555','286556','286557','286558','286559','286560','286561','286562','286563','286564','286580','286581','286582','286583','286584','291894','292071','292074','292075','292377','292850','293652','293870','293871','293872','293873','293874','295526','296137','296138','296139','296140','296141','296142','296143','296144','296145','296146','296147','296148','296149','296150','296151','296152','296153','296154','296155','296156','296157','296158','296159','296160','296161','296162','296163','296164','296165','296166','296167','296168','296169','296170','296171','296172','296173','296174','296175','296176','296324','296325','296326','296327','296328','296329','298101','298214','298251','299602','301903','303907') GROUP BY `wire_len` ORDER BY `wire_len` ASC