childsstroke: color
SELECT `color`,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 `color` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141565','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141724','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','142859','143662','143736','143737','144940','146497','146532','146943','146945','148372','148373','148741','149121','150597','150674','151014','151198','151247','151253','151633','152546','153068','153089','153095','153136','153376','153377','153378','153581','153928','154239','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238824','238835','238906','238909','239059','239060','239451','241718','241888','242237','242964','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','254285','273882','280359','283530') GROUP BY `color` ORDER BY `color` ASC
childsstroke1: color
SELECT `color`,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 `color` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','143662','143736','143737','144940','146497','146945','148372','148373','148741','149121','150597','151014','151198','151247','151253','151633','153068','153089','153095','153136','153376','153377','153378','153581','153928','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238835','238906','238909','239060','239451','241718','241888','242237','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','273882','283530') GROUP BY `color` ORDER BY `color` ASC
childsstroke: leddiam
SELECT `leddiam`,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 `leddiam` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141565','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141724','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','142859','143662','143736','143737','144940','146497','146532','146943','146945','148372','148373','148741','149121','150597','150674','151014','151198','151247','151253','151633','152546','153068','153089','153095','153136','153376','153377','153378','153581','153928','154239','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238824','238835','238906','238909','239059','239060','239451','241718','241888','242237','242964','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','254285','273882','280359','283530') GROUP BY `leddiam` ORDER BY `leddiam` ASC
childsstroke1: leddiam
SELECT `leddiam`,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 `leddiam` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','143662','143736','143737','144940','146497','146945','148372','148373','148741','149121','150597','151014','151198','151247','151253','151633','153068','153089','153095','153136','153376','153377','153378','153581','153928','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238835','238906','238909','239060','239451','241718','241888','242237','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','273882','283530') GROUP BY `leddiam` ORDER BY `leddiam` ASC
childsstroke: lens_color
SELECT `lens_color`,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 `lens_color` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141565','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141724','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','142859','143662','143736','143737','144940','146497','146532','146943','146945','148372','148373','148741','149121','150597','150674','151014','151198','151247','151253','151633','152546','153068','153089','153095','153136','153376','153377','153378','153581','153928','154239','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238824','238835','238906','238909','239059','239060','239451','241718','241888','242237','242964','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','254285','273882','280359','283530') GROUP BY `lens_color` ORDER BY `lens_color` ASC
childsstroke1: lens_color
SELECT `lens_color`,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 `lens_color` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','143662','143736','143737','144940','146497','146945','148372','148373','148741','149121','150597','151014','151198','151247','151253','151633','153068','153089','153095','153136','153376','153377','153378','153581','153928','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238835','238906','238909','239060','239451','241718','241888','242237','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','273882','283530') GROUP BY `lens_color` ORDER BY `lens_color` ASC
childsstroke: wavelength
SELECT `wavelength`,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 `wavelength` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141565','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141724','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','142859','143662','143736','143737','144940','146497','146532','146943','146945','148372','148373','148741','149121','150597','150674','151014','151198','151247','151253','151633','152546','153068','153089','153095','153136','153376','153377','153378','153581','153928','154239','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238824','238835','238906','238909','239059','239060','239451','241718','241888','242237','242964','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','254285','273882','280359','283530') GROUP BY `wavelength` ORDER BY `wavelength` ASC
childsstroke1: wavelength
SELECT `wavelength`,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 `wavelength` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','143662','143736','143737','144940','146497','146945','148372','148373','148741','149121','150597','151014','151198','151247','151253','151633','153068','153089','153095','153136','153376','153377','153378','153581','153928','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238835','238906','238909','239060','239451','241718','241888','242237','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','273882','283530') GROUP BY `wavelength` ORDER BY `wavelength` ASC
childsstroke: forw_volt
SELECT `forw_volt`,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 `forw_volt` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141565','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141724','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','142859','143662','143736','143737','144940','146497','146532','146943','146945','148372','148373','148741','149121','150597','150674','151014','151198','151247','151253','151633','152546','153068','153089','153095','153136','153376','153377','153378','153581','153928','154239','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238824','238835','238906','238909','239059','239060','239451','241718','241888','242237','242964','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','254285','273882','280359','283530') GROUP BY `forw_volt` ORDER BY `forw_volt` ASC
childsstroke1: forw_volt
SELECT `forw_volt`,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 `forw_volt` !='' AND `modx_site_content`.`id` IN ('141341','141360','141361','141362','141363','141386','141387','141463','141467','141468','141469','141517','141543','141564','141566','141584','141585','141586','141587','141596','141620','141621','141622','141623','141688','141689','141690','141708','141722','141723','141761','141805','141855','141885','141948','141949','141950','142053','142130','142146','142771','143662','143736','143737','144940','146497','146945','148372','148373','148741','149121','150597','151014','151198','151247','151253','151633','153068','153089','153095','153136','153376','153377','153378','153581','153928','154269','154410','154688','154784','154851','154857','154891','155076','155650','155651','155919','155920','155921','155922','155923','156094','156095','156096','156097','156098','156099','156100','156101','156102','156103','156104','156105','156106','156107','156108','156109','156110','156111','156112','156113','156114','156115','156116','156117','156118','156119','156120','156121','156122','156123','156124','156125','156126','156127','156128','156129','156130','156131','156132','156133','156134','156135','156136','156137','156138','156139','156140','156141','156142','156143','156144','156145','156146','157072','157545','158147','158477','159260','159526','159642','159948','160043','160407','161002','161258','161553','161981','162293','163519','167777','169095','169145','169158','169169','169172','169180','169290','169291','169300','169331','169332','169973','169974','170306','170666','207570','215385','215464','215654','215655','216000','216055','219728','232719','238116','238274','238408','238527','238570','238695','238696','238697','238781','238782','238783','238794','238795','238796','238797','238798','238835','238906','238909','239060','239451','241718','241888','242237','243618','243671','244311','244965','245197','245222','245768','249552','250147','251594','273882','283530') GROUP BY `forw_volt` ORDER BY `forw_volt` ASC
