childsstroke: core
SELECT `core`,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 `core` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `core` ORDER BY `core` ASC
childsstroke1: core
SELECT `core`,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 `core` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `core` ORDER BY `core` ASC
childsstroke: bit_depth
SELECT `bit_depth`,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 `bit_depth` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `bit_depth` ORDER BY `bit_depth` ASC
childsstroke1: bit_depth
SELECT `bit_depth`,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 `bit_depth` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `bit_depth` ORDER BY `bit_depth` ASC
childsstroke: max_freq_mhz
SELECT `max_freq_mhz`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `max_freq_mhz` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `max_freq_mhz` ORDER BY `max_freq_mhz` ASC
childsstroke1: max_freq_mhz
SELECT `max_freq_mhz`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `max_freq_mhz` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `max_freq_mhz` ORDER BY `max_freq_mhz` ASC
childsstroke: flash
SELECT `flash`,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 `flash` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `flash` ORDER BY `flash` ASC
childsstroke1: flash
SELECT `flash`,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 `flash` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `flash` ORDER BY `flash` ASC
childsstroke: ram
SELECT `ram`,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 `ram` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `ram` ORDER BY `ram` ASC
childsstroke1: ram
SELECT `ram`,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 `ram` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `ram` ORDER BY `ram` ASC
childsstroke: gpio
SELECT `gpio`,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 `gpio` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `gpio` ORDER BY `gpio` ASC
childsstroke1: gpio
SELECT `gpio`,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 `gpio` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `gpio` ORDER BY `gpio` 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 ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') 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 ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke: ethernet
SELECT `ethernet`,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 `ethernet` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `ethernet` ORDER BY `ethernet` ASC
childsstroke1: ethernet
SELECT `ethernet`,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 `ethernet` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `ethernet` ORDER BY `ethernet` ASC
childsstroke: bluetooth
SELECT `bluetooth`,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 `bluetooth` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `bluetooth` ORDER BY `bluetooth` ASC
childsstroke1: bluetooth
SELECT `bluetooth`,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 `bluetooth` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `bluetooth` ORDER BY `bluetooth` ASC
childsstroke: work_temp
SELECT `work_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 `work_temp` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `work_temp` ORDER BY `work_temp` ASC
childsstroke1: work_temp
SELECT `work_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 `work_temp` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `work_temp` ORDER BY `work_temp` ASC
childsstroke: stock_status
SELECT `stock_status`,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 `stock_status` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `stock_status` ORDER BY `stock_status` ASC
childsstroke1: stock_status
SELECT `stock_status`,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 `stock_status` !='' AND `modx_site_content`.`id` IN ('279384','282118','282119','282120','282121','282122','282123','282124','282125','282126','282127','282128','282129','282130','282131','282132','282133','282134','282135','282136','282137','282214','282215','282216','282217','282218','282219','282220','282221','282222','282223','282224','282225','282226','282227','282228','282229','282230','282231','282232','282233','282235','282236','282237','282238','282239','282240','282241','282242','282243','282244','283547','284968','284974','284975','284976','284977','284978','284979','284980','284981','284982','284983','284984','284985','284986','284988','284989','284990','284991','285090','285091','285092','285093','285112','285113','285114','285165','285372','285373','285374','285453','285460','285461','293551','293926','295399') GROUP BY `stock_status` ORDER BY `stock_status` ASC