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 ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') 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 ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: montage
SELECT `montage`,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 `montage` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `montage` ORDER BY `montage` ASC
childsstroke1: montage
SELECT `montage`,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 `montage` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `montage` ORDER BY `montage` ASC
childsstroke: packages
SELECT `packages`,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 `packages` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke1: packages
SELECT `packages`,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 `packages` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke: capacity
SELECT `capacity`,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 `capacity` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `capacity` ORDER BY `capacity` ASC
childsstroke1: capacity
SELECT `capacity`,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 `capacity` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `capacity` ORDER BY `capacity` ASC
childsstroke: capacity_unit
SELECT `capacity_unit`,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 `capacity_unit` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `capacity_unit` ORDER BY `capacity_unit` ASC
childsstroke1: capacity_unit
SELECT `capacity_unit`,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 `capacity_unit` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `capacity_unit` ORDER BY `capacity_unit` ASC
childsstroke: voltage
SELECT `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 `voltage` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `voltage` ORDER BY `voltage` ASC
childsstroke1: voltage
SELECT `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 `voltage` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `voltage` ORDER BY `voltage` ASC
childsstroke: deviation
SELECT `deviation`,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 `deviation` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `deviation` ORDER BY `deviation` ASC
childsstroke1: deviation
SELECT `deviation`,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 `deviation` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `deviation` ORDER BY `deviation` ASC
childsstroke: tip
SELECT `tip`,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` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `tip` ORDER BY `tip` ASC
childsstroke1: tip
SELECT `tip`,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` !='' AND `modx_site_content`.`id` IN ('152643','152645','152646','152647','152648','152663','153085','153150','153151','153208','153219','153221','153232','153243','153246','153247','153248','153254','153255','153258','153262','153267','153268','153269','153270','153271','153272','153273','153339','153433','153434','153435','153436','153437','153438','153439','153440','153441','153442','153443','153444','153449','153450','153463','153464','153465','153466','153590','153600','153602','153603','153656','153659','153660','153661','153662','153663','153666','153715','153717','153719','153720','153721','153722','153728','153729','153744','153745','153746','153747','153764','153770','153789','153814','154169','154170','154504','154520','154522','154523','154640','154692','154693','156584','156585','156586','156587','156591','156592','156593','156594','156595','156596','156597','156645','156646','156647','156648','156649','156650','156651','156783','156784','156785','156786','156866','156867','156868','156869','156870','156871','156872','157556','157557','157559','157560','157561','157562','157563','157564','157565','157566','157567','157568','157569','157570','157688','158234','158294','158391','158533','158625','158712','159034','159136','159137','159503','159509','160138','160139','160151','160190','160195','160325','160358','160359','160478','160485','160486','160593','160594','160608','160733','160937','161121','161477','161538','162553','162741','162889','162900','163015','163058','163847','163933','164744','164891','164896','165412','165546','165556','165726','165788','165995','166211','166949','167208','167387','167581','167680','168048','168369','168404','232455','232456','232466','232476','232477','232478','232480','232481','232482','232483','232559','232560','232580','232612','232654','232657','232667','232668','232670','232724','232725','232740','238021','238063','238146','238229','238287','238288','238292','238319','238420','238818','238834','239171','239172','239173','239336','239779','239781','239782','239969','239970','240243','240502','240890','241389','241572','242133','242147','242278','242340','242424','242535','242539','242678','243105','243716','244552','244553','245485','246542','246782','246902','246903','247110','247111','247791','248147','248151','248344','249101','249134','249224','249265','249353','249514','249973','250006','250161','250340','250451','250496','250826','251028','251303','251849','252050','252191','253300','253358','253507','254395','254405','254432','254740','254930','255300','255598','255790','256440','256468','256471','256665','256682','256728','256729','256797','256854','257065','262785','262799','263024','263054','263529','263536','263537','263538','263545','263549','263724','263725','264497','264706','265104','265140','265154','265417','266570','266955','267096','267097','267098','267126','267315','267316','267669','268083','268084','268093','268236','268483','268538','268539','268746','268902','268903','269016','269070','269100','269191','269225','269357','269396','273423','273463','273473','273548','273558','273732','273899','274403','274487','274678','274756','274846','274847','274900','275014','275103','275847','275849','276272','276427','276482','276551','276595','276702','277005','277188','277232','277272','277380','277486','277581','277787','277871','277872','278255','278308','278447','278896','279200','279302','279315','279494','279498','279499','279576','279590','279738','279739','280278','280325','280416','280774','281653','281738','282299','282513','282547','282903','283237','283573','283579','283658','283718','283723','284419','284840','285343','285347','285348','285369','285697','285767','286001','286048','286140','286278','286279','286459','286878','286910','286954','286955','287054','287094','287233','287508','288005','288160','288161','288162','288219','288382','288658','288725','288728','289499','291823','291824','291903','292390','292395','292789','292905','293465','293545','294143','294204','294375','294388','294491','294557','294558','294641','294672','294883','295303','295391','295561','295562','295563','295564','295565','295585','295701','295828','297332','297430','297616','297693','297931','297982','298071','298207','298264','298275','298277','298502','299078','299489','299490','299909','299955','299991','300023','300041','300062','300371','300520','300521','300524','300563','300669','300695','300914','301845','301938','302069','302103','302194','302354','302355','303792','303821','303830') GROUP BY `tip` ORDER BY `tip` ASC
