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 ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142198','142199','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143086','143087','143088','143089','143090','143091','143092','143570','144164','145119','145120','145121','145122','145123','145124','145125','145126','145127','145128','145129','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146513','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148742','148990','150422','150423','150424','150593','151099','151100','151101','151102','151103','151104','151105','151106','151110','151632','151873','151874','152508','153548','154505','154506','154507','154508','154509','154644','157121','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157133','157134','157135','157136','157137','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158664','158674','158715','158988','158989','159161','159162','159358','159359','159360','159398','159581','159585','159633','159634','159635','159636','159867','160094','160133','160261','160262','160263','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161021','161022','161023','161024','161025','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162186','162187','162188','162189','162277','162281','162461','162634','162733','162744','162855','162887','162892','162951','163200','163201','163202','163203','163204','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169346','169733','201239','201240','202857','202858','202859','215203','215469','215470','215471','215472','215473','215474','215475','215476','215759','216086','219751','232623','238139','238186','238412','238581','238582','238927','238928','238929','238930','238931','238932','239870','239966','240073','240141','240224','241008','242056','242075','242076','242077','242078','242079','242080','242081','242082','242083','242084','242085','242086','242087','242088','242089','242157','242223','242224','242225','242226','242227','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245074','245582','246276','246277','246278','246741','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') 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 ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143089','143090','143091','145119','145121','145122','145123','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148990','150423','150424','150593','151099','151100','151101','151102','151103','151874','152508','153548','154509','154644','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158715','159162','159358','159359','159360','159581','159585','159867','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162461','162634','162733','162744','162855','162887','162951','163200','163202','163203','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169733','201239','201240','202857','202858','202859','216086','219751','232623','238139','238186','238412','238581','238582','239870','239966','240141','241008','242056','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245582','246276','246277','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `manuf` ORDER BY `manuf` ASC
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 ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142198','142199','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143086','143087','143088','143089','143090','143091','143092','143570','144164','145119','145120','145121','145122','145123','145124','145125','145126','145127','145128','145129','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146513','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148742','148990','150422','150423','150424','150593','151099','151100','151101','151102','151103','151104','151105','151106','151110','151632','151873','151874','152508','153548','154505','154506','154507','154508','154509','154644','157121','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157133','157134','157135','157136','157137','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158664','158674','158715','158988','158989','159161','159162','159358','159359','159360','159398','159581','159585','159633','159634','159635','159636','159867','160094','160133','160261','160262','160263','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161021','161022','161023','161024','161025','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162186','162187','162188','162189','162277','162281','162461','162634','162733','162744','162855','162887','162892','162951','163200','163201','163202','163203','163204','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169346','169733','201239','201240','202857','202858','202859','215203','215469','215470','215471','215472','215473','215474','215475','215476','215759','216086','219751','232623','238139','238186','238412','238581','238582','238927','238928','238929','238930','238931','238932','239870','239966','240073','240141','240224','241008','242056','242075','242076','242077','242078','242079','242080','242081','242082','242083','242084','242085','242086','242087','242088','242089','242157','242223','242224','242225','242226','242227','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245074','245582','246276','246277','246278','246741','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') 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 ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143089','143090','143091','145119','145121','145122','145123','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148990','150423','150424','150593','151099','151100','151101','151102','151103','151874','152508','153548','154509','154644','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158715','159162','159358','159359','159360','159581','159585','159867','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162461','162634','162733','162744','162855','162887','162951','163200','163202','163203','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169733','201239','201240','202857','202858','202859','216086','219751','232623','238139','238186','238412','238581','238582','239870','239966','240141','241008','242056','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245582','246276','246277','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `color` ORDER BY `color` ASC
childsstroke: color_temp
SELECT `color_temp`,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_temp` !='' AND `modx_site_content`.`id` IN ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142198','142199','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143086','143087','143088','143089','143090','143091','143092','143570','144164','145119','145120','145121','145122','145123','145124','145125','145126','145127','145128','145129','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146513','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148742','148990','150422','150423','150424','150593','151099','151100','151101','151102','151103','151104','151105','151106','151110','151632','151873','151874','152508','153548','154505','154506','154507','154508','154509','154644','157121','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157133','157134','157135','157136','157137','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158664','158674','158715','158988','158989','159161','159162','159358','159359','159360','159398','159581','159585','159633','159634','159635','159636','159867','160094','160133','160261','160262','160263','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161021','161022','161023','161024','161025','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162186','162187','162188','162189','162277','162281','162461','162634','162733','162744','162855','162887','162892','162951','163200','163201','163202','163203','163204','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169346','169733','201239','201240','202857','202858','202859','215203','215469','215470','215471','215472','215473','215474','215475','215476','215759','216086','219751','232623','238139','238186','238412','238581','238582','238927','238928','238929','238930','238931','238932','239870','239966','240073','240141','240224','241008','242056','242075','242076','242077','242078','242079','242080','242081','242082','242083','242084','242085','242086','242087','242088','242089','242157','242223','242224','242225','242226','242227','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245074','245582','246276','246277','246278','246741','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `color_temp` ORDER BY `color_temp` ASC
childsstroke1: color_temp
SELECT `color_temp`,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_temp` !='' AND `modx_site_content`.`id` IN ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143089','143090','143091','145119','145121','145122','145123','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148990','150423','150424','150593','151099','151100','151101','151102','151103','151874','152508','153548','154509','154644','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158715','159162','159358','159359','159360','159581','159585','159867','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162461','162634','162733','162744','162855','162887','162951','163200','163202','163203','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169733','201239','201240','202857','202858','202859','216086','219751','232623','238139','238186','238412','238581','238582','239870','239966','240141','241008','242056','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245582','246276','246277','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `color_temp` ORDER BY `color_temp` 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 ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142198','142199','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143086','143087','143088','143089','143090','143091','143092','143570','144164','145119','145120','145121','145122','145123','145124','145125','145126','145127','145128','145129','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146513','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148742','148990','150422','150423','150424','150593','151099','151100','151101','151102','151103','151104','151105','151106','151110','151632','151873','151874','152508','153548','154505','154506','154507','154508','154509','154644','157121','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157133','157134','157135','157136','157137','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158664','158674','158715','158988','158989','159161','159162','159358','159359','159360','159398','159581','159585','159633','159634','159635','159636','159867','160094','160133','160261','160262','160263','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161021','161022','161023','161024','161025','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162186','162187','162188','162189','162277','162281','162461','162634','162733','162744','162855','162887','162892','162951','163200','163201','163202','163203','163204','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169346','169733','201239','201240','202857','202858','202859','215203','215469','215470','215471','215472','215473','215474','215475','215476','215759','216086','219751','232623','238139','238186','238412','238581','238582','238927','238928','238929','238930','238931','238932','239870','239966','240073','240141','240224','241008','242056','242075','242076','242077','242078','242079','242080','242081','242082','242083','242084','242085','242086','242087','242088','242089','242157','242223','242224','242225','242226','242227','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245074','245582','246276','246277','246278','246741','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') 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 ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143089','143090','143091','145119','145121','145122','145123','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148990','150423','150424','150593','151099','151100','151101','151102','151103','151874','152508','153548','154509','154644','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158715','159162','159358','159359','159360','159581','159585','159867','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162461','162634','162733','162744','162855','162887','162951','163200','163202','163203','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169733','201239','201240','202857','202858','202859','216086','219751','232623','238139','238186','238412','238581','238582','239870','239966','240141','241008','242056','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245582','246276','246277','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `voltage` ORDER BY `voltage` ASC
childsstroke: ip
SELECT `ip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `ip` !='' AND `modx_site_content`.`id` IN ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142198','142199','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143086','143087','143088','143089','143090','143091','143092','143570','144164','145119','145120','145121','145122','145123','145124','145125','145126','145127','145128','145129','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146513','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148742','148990','150422','150423','150424','150593','151099','151100','151101','151102','151103','151104','151105','151106','151110','151632','151873','151874','152508','153548','154505','154506','154507','154508','154509','154644','157121','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157133','157134','157135','157136','157137','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158664','158674','158715','158988','158989','159161','159162','159358','159359','159360','159398','159581','159585','159633','159634','159635','159636','159867','160094','160133','160261','160262','160263','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161021','161022','161023','161024','161025','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162186','162187','162188','162189','162277','162281','162461','162634','162733','162744','162855','162887','162892','162951','163200','163201','163202','163203','163204','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169346','169733','201239','201240','202857','202858','202859','215203','215469','215470','215471','215472','215473','215474','215475','215476','215759','216086','219751','232623','238139','238186','238412','238581','238582','238927','238928','238929','238930','238931','238932','239870','239966','240073','240141','240224','241008','242056','242075','242076','242077','242078','242079','242080','242081','242082','242083','242084','242085','242086','242087','242088','242089','242157','242223','242224','242225','242226','242227','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245074','245582','246276','246277','246278','246741','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `ip` ORDER BY `ip` ASC
childsstroke1: ip
SELECT `ip`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `ip` !='' AND `modx_site_content`.`id` IN ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143089','143090','143091','145119','145121','145122','145123','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148990','150423','150424','150593','151099','151100','151101','151102','151103','151874','152508','153548','154509','154644','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158715','159162','159358','159359','159360','159581','159585','159867','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162461','162634','162733','162744','162855','162887','162951','163200','163202','163203','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169733','201239','201240','202857','202858','202859','216086','219751','232623','238139','238186','238412','238581','238582','239870','239966','240141','241008','242056','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245582','246276','246277','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `ip` ORDER BY `ip` ASC
childsstroke: kol_diodov
SELECT `kol_diodov`,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 `kol_diodov` !='' AND `modx_site_content`.`id` IN ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142198','142199','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143086','143087','143088','143089','143090','143091','143092','143570','144164','145119','145120','145121','145122','145123','145124','145125','145126','145127','145128','145129','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146513','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148742','148990','150422','150423','150424','150593','151099','151100','151101','151102','151103','151104','151105','151106','151110','151632','151873','151874','152508','153548','154505','154506','154507','154508','154509','154644','157121','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157133','157134','157135','157136','157137','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158664','158674','158715','158988','158989','159161','159162','159358','159359','159360','159398','159581','159585','159633','159634','159635','159636','159867','160094','160133','160261','160262','160263','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161021','161022','161023','161024','161025','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162186','162187','162188','162189','162277','162281','162461','162634','162733','162744','162855','162887','162892','162951','163200','163201','163202','163203','163204','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169346','169733','201239','201240','202857','202858','202859','215203','215469','215470','215471','215472','215473','215474','215475','215476','215759','216086','219751','232623','238139','238186','238412','238581','238582','238927','238928','238929','238930','238931','238932','239870','239966','240073','240141','240224','241008','242056','242075','242076','242077','242078','242079','242080','242081','242082','242083','242084','242085','242086','242087','242088','242089','242157','242223','242224','242225','242226','242227','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245074','245582','246276','246277','246278','246741','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `kol_diodov` ORDER BY `kol_diodov` ASC
childsstroke1: kol_diodov
SELECT `kol_diodov`,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 `kol_diodov` !='' AND `modx_site_content`.`id` IN ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143089','143090','143091','145119','145121','145122','145123','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148990','150423','150424','150593','151099','151100','151101','151102','151103','151874','152508','153548','154509','154644','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158715','159162','159358','159359','159360','159581','159585','159867','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162461','162634','162733','162744','162855','162887','162951','163200','163202','163203','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169733','201239','201240','202857','202858','202859','216086','219751','232623','238139','238186','238412','238581','238582','239870','239966','240141','241008','242056','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245582','246276','246277','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `kol_diodov` ORDER BY `kol_diodov` ASC
childsstroke1: SELECT `lumen`,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 `lumen` !='' AND `modx_site_content`.`id` IN ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143089','143090','143091','145119','145121','145122','145123','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148990','150423','150424','150593','151099','151100','151101','151102','151103','151874','152508','153548','154509','154644','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158715','159162','159358','159359','159360','159581','159585','159867','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162461','162634','162733','162744','162855','162887','162951','163200','163202','163203','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169733','201239','201240','202857','202858','202859','216086','219751','232623','238139','238186','238412','238581','238582','239870','239966','240141','241008','242056','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245582','246276','246277','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `lumen` ORDER BY `lumen` ASC
childsstroke1: SELECT `power`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `power` !='' AND `modx_site_content`.`id` IN ('141656','141669','141706','141727','141732','141735','142109','142110','142138','142139','142641','142642','142643','142644','142645','142692','142693','142694','142695','142701','142866','142867','142868','142869','142870','142871','142872','142873','142874','143085','143089','143090','143091','145119','145121','145122','145123','146491','146494','146495','146496','146499','146500','146501','146502','146503','146504','146505','146511','146522','146525','146527','146530','146569','147044','147884','148172','148363','148395','148400','148401','148402','148704','148990','150423','150424','150593','151099','151100','151101','151102','151103','151874','152508','153548','154509','154644','157122','157123','157124','157125','157126','157127','157128','157129','157130','157131','157132','157135','157136','157138','157139','157140','157141','157142','157143','157144','157145','157146','157147','157148','157149','157150','157151','157152','157153','157154','157155','157156','157157','157158','157159','157160','157161','157162','157164','157165','157166','157580','157846','158035','158036','158037','158038','158067','158068','158272','158356','158387','158513','158514','158580','158602','158715','159162','159358','159359','159360','159581','159585','159867','160487','160717','160774','161013','161014','161015','161016','161018','161019','161020','161022','161023','161024','161081','161082','161083','161212','161213','161284','161439','161688','161749','161911','162008','162152','162167','162168','162461','162634','162733','162744','162855','162887','162951','163200','163202','163203','163211','163706','163885','164320','164321','164351','165212','165213','165214','165429','165430','165476','165554','165985','165986','165987','165988','165998','166435','166565','167115','167307','167967','167968','168153','168405','169143','169211','169733','201239','201240','202857','202858','202859','216086','219751','232623','238139','238186','238412','238581','238582','239870','239966','240141','241008','242056','242633','242898','243082','243092','243126','243369','243415','243416','243522','243697','245582','246276','246277','248649','249204','250076','250077','250078','251072','251181','251182','251183','251479','251480','251708','252102','255391','255989','255990','256583','256595','267921','268414','274823','274824','280664','282757','283488','286162','292234','298413','298414','298415','298416','302112','302113','302114','302115','302116','302117','302118') GROUP BY `power` ORDER BY `power` ASC
