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 ('16','47','94','303','291727','153109','154488','155370','157260','157873','158480','158481','158819','158963','160065','160090','160439','160609','161232','161436','161437','161668','162125','162253','162367','162434','162566','163316','163317','163351','163517','163721','163761','163921','163944','164097','164119','164766','165037','165232','165354','165528','165618','165908','165940','166100','166107','166145','166212','166527','166640','167223','167269','167578','167753','167817','167850','167854','168040','168072','168081','168392','238394','239468','239791','239851','240430','241265','241266','241452','241673','241674','242411','242473','242781','243890','244095','244461','245021','245776','245831','245939','246194','246207','246208','246638','246646','246783','246986','247064','247401','247539','247554','248117','248489','248681','248682','248721','248765','248986','249020','249083','249088','249183','249193','249682','249779','250178','250624','250634','250958','250973','251325','251361','251394','251449','251467','251760','251892','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254660','254863','255005','255183','255222','255330','255953','256273','256499','256690','256822','256937','256938','257062','257230','261986','261988','262355','262362','262563','262615','263100','263487','264631','264632','265380','265446','265534','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','279110','279111','279122','279304','279410','279832','280328','280361','280413','280510','280511','280545','280991','281421','281621','281726','281808','281809','282081','282090','282201','282802','282803','282907','283616','283773','284239','284240','284242','284243','284249','284338','284339','284345','284361','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284401','284423','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','285308','285317','285488','285525','285757','285791','285916','285971','286022','286294','286357','286409','286611','286936','287105','287127','287228','287514','287515','288000','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','291892','292221','292596','292661','293495','294365','294567','294846','295424','295425','295498','295569','295570','295571','295589','295592','295734','295736','295932','297144','297155','297192','297316','297337','297434','297732','298042','298225','298313','298407','299049','299257','299370','299408','299410','299785','301024','303840','303942','154455','157272','157273','157274','157275','157276','157876','157877','157878','157880','157881','157912','157957','158301','158939','159048','159267','159610','160066','160334','160438','160996','161444','161445','161457','161505','162299','162661','163486','163687','164063','164431','164510','165601','166414','166549','166614','166629','167367','232493','239029','239488','239593','239637','240006','241288','241299','242883','243124','243440','243515','243670','244071','244180','244525','244639','244685','244795','245135','245275','245336','245887','246019','246382','246459','246765','246821','246964','247637','248107','248605','248814','249848','250269','250715','250780','250782','250897','250972','251335','251819','251868','251969','254617','255365','255995','256087','256436','256962','257161','262184','262930','263567','263682','263698','264466','264500','264886','265054','265145','265661','266578','266589','267385','267500','267626','268285','268383','269222','273475','273527','273629','273736','273737','274059','274064','274514','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274919','275045','275516','275801','276020','276400','276627','277322','277777','279042','279043','279109','280306','281283','281824','282065','282066','282067','282079','282766','283498','284148','284241','284244','284245','284246','284247','284248','284362','284363','284366','284367','284425','284999','285292','285390','285787','285902','285903','285905','285953','286079','286080','286401','286410','286853','286856','286972','287194','287195','288027','288187','288188','288189','288190','288191','288203','288204','288206','288207','288557','288558','288672','288673','288982','289100','289497','292387','293235','293236','293559','294173','294402','294618','294619','294736','295378','295568','295750','297476','297706','298005','298272','299640','300053','300274','301012','302216','303789','303941','161513','167754','167755','247190','251634','252032','262382','266737','269550','274561','274564','274566','274568','275269','275270','279204','284396','284399','284427','284428','288192','288193','288194','288195','291975','294891','297238','297524','297525','299285','157508','158768','160620','163792','164846','167082','168336','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','152977','160568','239028','240217','240697','242436','243699','244134','261748','292637') 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 ('152977','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160568','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','232493','238394','239028','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240217','240430','240697','241265','241266','241288','241299','241452','241673','241674','242411','242436','242473','242781','242883','243124','243440','243515','243670','243699','243890','244071','244095','244134','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261748','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284396','284399','284401','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288395','288518','288557','288558','288581','288583','288630','288644','288672','288673','288707','288853','288859','288982','289100','289397','289497','289507','289508','289509','291581','291892','291975','292221','292387','292596','292637','292661','293235','293236','293495','293559','294173','294365','294402','294567','294618','294619','294736','294846','294891','295378','295424','295425','295498','295568','295569','295570','295571','295589','295592','295734','295736','295750','295932','297144','297155','297192','297238','297316','297337','297434','297476','297524','297525','297706','297732','298005','298042','298225','298272','298313','298407','299049','299257','299285','299370','299408','299410','299640','299785','300053','300274','301012','301024','302216','303789','303840','303941','303942') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: parent
SELECT `parent`,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 `parent` !='' AND `modx_site_content`.`id` IN ('16','47','94','303','291727','153109','154488','155370','157260','157873','158480','158481','158819','158963','160065','160090','160439','160609','161232','161436','161437','161668','162125','162253','162367','162434','162566','163316','163317','163351','163517','163721','163761','163921','163944','164097','164119','164766','165037','165232','165354','165528','165618','165908','165940','166100','166107','166145','166212','166527','166640','167223','167269','167578','167753','167817','167850','167854','168040','168072','168081','168392','238394','239468','239791','239851','240430','241265','241266','241452','241673','241674','242411','242473','242781','243890','244095','244461','245021','245776','245831','245939','246194','246207','246208','246638','246646','246783','246986','247064','247401','247539','247554','248117','248489','248681','248682','248721','248765','248986','249020','249083','249088','249183','249193','249682','249779','250178','250624','250634','250958','250973','251325','251361','251394','251449','251467','251760','251892','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254660','254863','255005','255183','255222','255330','255953','256273','256499','256690','256822','256937','256938','257062','257230','261986','261988','262355','262362','262563','262615','263100','263487','264631','264632','265380','265446','265534','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','279110','279111','279122','279304','279410','279832','280328','280361','280413','280510','280511','280545','280991','281421','281621','281726','281808','281809','282081','282090','282201','282802','282803','282907','283616','283773','284239','284240','284242','284243','284249','284338','284339','284345','284361','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284401','284423','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','285308','285317','285488','285525','285757','285791','285916','285971','286022','286294','286357','286409','286611','286936','287105','287127','287228','287514','287515','288000','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','291892','292221','292596','292661','293495','294365','294567','294846','295424','295425','295498','295569','295570','295571','295589','295592','295734','295736','295932','297144','297155','297192','297316','297337','297434','297732','298042','298225','298313','298407','299049','299257','299370','299408','299410','299785','301024','303840','303942','154455','157272','157273','157274','157275','157276','157876','157877','157878','157880','157881','157912','157957','158301','158939','159048','159267','159610','160066','160334','160438','160996','161444','161445','161457','161505','162299','162661','163486','163687','164063','164431','164510','165601','166414','166549','166614','166629','167367','232493','239029','239488','239593','239637','240006','241288','241299','242883','243124','243440','243515','243670','244071','244180','244525','244639','244685','244795','245135','245275','245336','245887','246019','246382','246459','246765','246821','246964','247637','248107','248605','248814','249848','250269','250715','250780','250782','250897','250972','251335','251819','251868','251969','254617','255365','255995','256087','256436','256962','257161','262184','262930','263567','263682','263698','264466','264500','264886','265054','265145','265661','266578','266589','267385','267500','267626','268285','268383','269222','273475','273527','273629','273736','273737','274059','274064','274514','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274919','275045','275516','275801','276020','276400','276627','277322','277777','279042','279043','279109','280306','281283','281824','282065','282066','282067','282079','282766','283498','284148','284241','284244','284245','284246','284247','284248','284362','284363','284366','284367','284425','284999','285292','285390','285787','285902','285903','285905','285953','286079','286080','286401','286410','286853','286856','286972','287194','287195','288027','288187','288188','288189','288190','288191','288203','288204','288206','288207','288557','288558','288672','288673','288982','289100','289497','292387','293235','293236','293559','294173','294402','294618','294619','294736','295378','295568','295750','297476','297706','298005','298272','299640','300053','300274','301012','302216','303789','303941','161513','167754','167755','247190','251634','252032','262382','266737','269550','274561','274564','274566','274568','275269','275270','279204','284396','284399','284427','284428','288192','288193','288194','288195','291975','294891','297238','297524','297525','299285','157508','158768','160620','163792','164846','167082','168336','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','152977','160568','239028','240217','240697','242436','243699','244134','261748','292637') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke1: parent
SELECT `parent`,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 `parent` !='' AND `modx_site_content`.`id` IN ('152977','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160568','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','232493','238394','239028','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240217','240430','240697','241265','241266','241288','241299','241452','241673','241674','242411','242436','242473','242781','242883','243124','243440','243515','243670','243699','243890','244071','244095','244134','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261748','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284396','284399','284401','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288395','288518','288557','288558','288581','288583','288630','288644','288672','288673','288707','288853','288859','288982','289100','289397','289497','289507','289508','289509','291581','291892','291975','292221','292387','292596','292637','292661','293235','293236','293495','293559','294173','294365','294402','294567','294618','294619','294736','294846','294891','295378','295424','295425','295498','295568','295569','295570','295571','295589','295592','295734','295736','295750','295932','297144','297155','297192','297238','297316','297337','297434','297476','297524','297525','297706','297732','298005','298042','298225','298272','298313','298407','299049','299257','299285','299370','299408','299410','299640','299785','300053','300274','301012','301024','302216','303789','303840','303941','303942') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke: freq_mhz
SELECT `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 `freq_mhz` !='' AND `modx_site_content`.`id` IN ('16','47','94','303','291727','153109','154488','155370','157260','157873','158480','158481','158819','158963','160065','160090','160439','160609','161232','161436','161437','161668','162125','162253','162367','162434','162566','163316','163317','163351','163517','163721','163761','163921','163944','164097','164119','164766','165037','165232','165354','165528','165618','165908','165940','166100','166107','166145','166212','166527','166640','167223','167269','167578','167753','167817','167850','167854','168040','168072','168081','168392','238394','239468','239791','239851','240430','241265','241266','241452','241673','241674','242411','242473','242781','243890','244095','244461','245021','245776','245831','245939','246194','246207','246208','246638','246646','246783','246986','247064','247401','247539','247554','248117','248489','248681','248682','248721','248765','248986','249020','249083','249088','249183','249193','249682','249779','250178','250624','250634','250958','250973','251325','251361','251394','251449','251467','251760','251892','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254660','254863','255005','255183','255222','255330','255953','256273','256499','256690','256822','256937','256938','257062','257230','261986','261988','262355','262362','262563','262615','263100','263487','264631','264632','265380','265446','265534','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','279110','279111','279122','279304','279410','279832','280328','280361','280413','280510','280511','280545','280991','281421','281621','281726','281808','281809','282081','282090','282201','282802','282803','282907','283616','283773','284239','284240','284242','284243','284249','284338','284339','284345','284361','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284401','284423','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','285308','285317','285488','285525','285757','285791','285916','285971','286022','286294','286357','286409','286611','286936','287105','287127','287228','287514','287515','288000','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','291892','292221','292596','292661','293495','294365','294567','294846','295424','295425','295498','295569','295570','295571','295589','295592','295734','295736','295932','297144','297155','297192','297316','297337','297434','297732','298042','298225','298313','298407','299049','299257','299370','299408','299410','299785','301024','303840','303942','154455','157272','157273','157274','157275','157276','157876','157877','157878','157880','157881','157912','157957','158301','158939','159048','159267','159610','160066','160334','160438','160996','161444','161445','161457','161505','162299','162661','163486','163687','164063','164431','164510','165601','166414','166549','166614','166629','167367','232493','239029','239488','239593','239637','240006','241288','241299','242883','243124','243440','243515','243670','244071','244180','244525','244639','244685','244795','245135','245275','245336','245887','246019','246382','246459','246765','246821','246964','247637','248107','248605','248814','249848','250269','250715','250780','250782','250897','250972','251335','251819','251868','251969','254617','255365','255995','256087','256436','256962','257161','262184','262930','263567','263682','263698','264466','264500','264886','265054','265145','265661','266578','266589','267385','267500','267626','268285','268383','269222','273475','273527','273629','273736','273737','274059','274064','274514','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274919','275045','275516','275801','276020','276400','276627','277322','277777','279042','279043','279109','280306','281283','281824','282065','282066','282067','282079','282766','283498','284148','284241','284244','284245','284246','284247','284248','284362','284363','284366','284367','284425','284999','285292','285390','285787','285902','285903','285905','285953','286079','286080','286401','286410','286853','286856','286972','287194','287195','288027','288187','288188','288189','288190','288191','288203','288204','288206','288207','288557','288558','288672','288673','288982','289100','289497','292387','293235','293236','293559','294173','294402','294618','294619','294736','295378','295568','295750','297476','297706','298005','298272','299640','300053','300274','301012','302216','303789','303941','161513','167754','167755','247190','251634','252032','262382','266737','269550','274561','274564','274566','274568','275269','275270','279204','284396','284399','284427','284428','288192','288193','288194','288195','291975','294891','297238','297524','297525','299285','157508','158768','160620','163792','164846','167082','168336','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','152977','160568','239028','240217','240697','242436','243699','244134','261748','292637') GROUP BY `freq_mhz` ORDER BY `freq_mhz` ASC
childsstroke1: freq_mhz
SELECT `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 `freq_mhz` !='' AND `modx_site_content`.`id` IN ('152977','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160568','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','232493','238394','239028','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240217','240430','240697','241265','241266','241288','241299','241452','241673','241674','242411','242436','242473','242781','242883','243124','243440','243515','243670','243699','243890','244071','244095','244134','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261748','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284396','284399','284401','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288395','288518','288557','288558','288581','288583','288630','288644','288672','288673','288707','288853','288859','288982','289100','289397','289497','289507','289508','289509','291581','291892','291975','292221','292387','292596','292637','292661','293235','293236','293495','293559','294173','294365','294402','294567','294618','294619','294736','294846','294891','295378','295424','295425','295498','295568','295569','295570','295571','295589','295592','295734','295736','295750','295932','297144','297155','297192','297238','297316','297337','297434','297476','297524','297525','297706','297732','298005','298042','298225','298272','298313','298407','299049','299257','299285','299370','299408','299410','299640','299785','300053','300274','301012','301024','302216','303789','303840','303941','303942') GROUP BY `freq_mhz` ORDER BY `freq_mhz` 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 ('16','47','94','303','291727','153109','154488','155370','157260','157873','158480','158481','158819','158963','160065','160090','160439','160609','161232','161436','161437','161668','162125','162253','162367','162434','162566','163316','163317','163351','163517','163721','163761','163921','163944','164097','164119','164766','165037','165232','165354','165528','165618','165908','165940','166100','166107','166145','166212','166527','166640','167223','167269','167578','167753','167817','167850','167854','168040','168072','168081','168392','238394','239468','239791','239851','240430','241265','241266','241452','241673','241674','242411','242473','242781','243890','244095','244461','245021','245776','245831','245939','246194','246207','246208','246638','246646','246783','246986','247064','247401','247539','247554','248117','248489','248681','248682','248721','248765','248986','249020','249083','249088','249183','249193','249682','249779','250178','250624','250634','250958','250973','251325','251361','251394','251449','251467','251760','251892','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254660','254863','255005','255183','255222','255330','255953','256273','256499','256690','256822','256937','256938','257062','257230','261986','261988','262355','262362','262563','262615','263100','263487','264631','264632','265380','265446','265534','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','279110','279111','279122','279304','279410','279832','280328','280361','280413','280510','280511','280545','280991','281421','281621','281726','281808','281809','282081','282090','282201','282802','282803','282907','283616','283773','284239','284240','284242','284243','284249','284338','284339','284345','284361','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284401','284423','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','285308','285317','285488','285525','285757','285791','285916','285971','286022','286294','286357','286409','286611','286936','287105','287127','287228','287514','287515','288000','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','291892','292221','292596','292661','293495','294365','294567','294846','295424','295425','295498','295569','295570','295571','295589','295592','295734','295736','295932','297144','297155','297192','297316','297337','297434','297732','298042','298225','298313','298407','299049','299257','299370','299408','299410','299785','301024','303840','303942','154455','157272','157273','157274','157275','157276','157876','157877','157878','157880','157881','157912','157957','158301','158939','159048','159267','159610','160066','160334','160438','160996','161444','161445','161457','161505','162299','162661','163486','163687','164063','164431','164510','165601','166414','166549','166614','166629','167367','232493','239029','239488','239593','239637','240006','241288','241299','242883','243124','243440','243515','243670','244071','244180','244525','244639','244685','244795','245135','245275','245336','245887','246019','246382','246459','246765','246821','246964','247637','248107','248605','248814','249848','250269','250715','250780','250782','250897','250972','251335','251819','251868','251969','254617','255365','255995','256087','256436','256962','257161','262184','262930','263567','263682','263698','264466','264500','264886','265054','265145','265661','266578','266589','267385','267500','267626','268285','268383','269222','273475','273527','273629','273736','273737','274059','274064','274514','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274919','275045','275516','275801','276020','276400','276627','277322','277777','279042','279043','279109','280306','281283','281824','282065','282066','282067','282079','282766','283498','284148','284241','284244','284245','284246','284247','284248','284362','284363','284366','284367','284425','284999','285292','285390','285787','285902','285903','285905','285953','286079','286080','286401','286410','286853','286856','286972','287194','287195','288027','288187','288188','288189','288190','288191','288203','288204','288206','288207','288557','288558','288672','288673','288982','289100','289497','292387','293235','293236','293559','294173','294402','294618','294619','294736','295378','295568','295750','297476','297706','298005','298272','299640','300053','300274','301012','302216','303789','303941','161513','167754','167755','247190','251634','252032','262382','266737','269550','274561','274564','274566','274568','275269','275270','279204','284396','284399','284427','284428','288192','288193','288194','288195','291975','294891','297238','297524','297525','299285','157508','158768','160620','163792','164846','167082','168336','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','152977','160568','239028','240217','240697','242436','243699','244134','261748','292637') 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 ('152977','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160568','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','232493','238394','239028','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240217','240430','240697','241265','241266','241288','241299','241452','241673','241674','242411','242436','242473','242781','242883','243124','243440','243515','243670','243699','243890','244071','244095','244134','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261748','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284396','284399','284401','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288395','288518','288557','288558','288581','288583','288630','288644','288672','288673','288707','288853','288859','288982','289100','289397','289497','289507','289508','289509','291581','291892','291975','292221','292387','292596','292637','292661','293235','293236','293495','293559','294173','294365','294402','294567','294618','294619','294736','294846','294891','295378','295424','295425','295498','295568','295569','295570','295571','295589','295592','295734','295736','295750','295932','297144','297155','297192','297238','297316','297337','297434','297476','297524','297525','297706','297732','298005','298042','298225','298272','298313','298407','299049','299257','299285','299370','299408','299410','299640','299785','300053','300274','301012','301024','302216','303789','303840','303941','303942') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke: montage
SELECT `montage`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `montage` !='' AND `modx_site_content`.`id` IN ('16','47','94','303','291727','153109','154488','155370','157260','157873','158480','158481','158819','158963','160065','160090','160439','160609','161232','161436','161437','161668','162125','162253','162367','162434','162566','163316','163317','163351','163517','163721','163761','163921','163944','164097','164119','164766','165037','165232','165354','165528','165618','165908','165940','166100','166107','166145','166212','166527','166640','167223','167269','167578','167753','167817','167850','167854','168040','168072','168081','168392','238394','239468','239791','239851','240430','241265','241266','241452','241673','241674','242411','242473','242781','243890','244095','244461','245021','245776','245831','245939','246194','246207','246208','246638','246646','246783','246986','247064','247401','247539','247554','248117','248489','248681','248682','248721','248765','248986','249020','249083','249088','249183','249193','249682','249779','250178','250624','250634','250958','250973','251325','251361','251394','251449','251467','251760','251892','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254660','254863','255005','255183','255222','255330','255953','256273','256499','256690','256822','256937','256938','257062','257230','261986','261988','262355','262362','262563','262615','263100','263487','264631','264632','265380','265446','265534','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','279110','279111','279122','279304','279410','279832','280328','280361','280413','280510','280511','280545','280991','281421','281621','281726','281808','281809','282081','282090','282201','282802','282803','282907','283616','283773','284239','284240','284242','284243','284249','284338','284339','284345','284361','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284401','284423','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','285308','285317','285488','285525','285757','285791','285916','285971','286022','286294','286357','286409','286611','286936','287105','287127','287228','287514','287515','288000','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','291892','292221','292596','292661','293495','294365','294567','294846','295424','295425','295498','295569','295570','295571','295589','295592','295734','295736','295932','297144','297155','297192','297316','297337','297434','297732','298042','298225','298313','298407','299049','299257','299370','299408','299410','299785','301024','303840','303942','154455','157272','157273','157274','157275','157276','157876','157877','157878','157880','157881','157912','157957','158301','158939','159048','159267','159610','160066','160334','160438','160996','161444','161445','161457','161505','162299','162661','163486','163687','164063','164431','164510','165601','166414','166549','166614','166629','167367','232493','239029','239488','239593','239637','240006','241288','241299','242883','243124','243440','243515','243670','244071','244180','244525','244639','244685','244795','245135','245275','245336','245887','246019','246382','246459','246765','246821','246964','247637','248107','248605','248814','249848','250269','250715','250780','250782','250897','250972','251335','251819','251868','251969','254617','255365','255995','256087','256436','256962','257161','262184','262930','263567','263682','263698','264466','264500','264886','265054','265145','265661','266578','266589','267385','267500','267626','268285','268383','269222','273475','273527','273629','273736','273737','274059','274064','274514','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274919','275045','275516','275801','276020','276400','276627','277322','277777','279042','279043','279109','280306','281283','281824','282065','282066','282067','282079','282766','283498','284148','284241','284244','284245','284246','284247','284248','284362','284363','284366','284367','284425','284999','285292','285390','285787','285902','285903','285905','285953','286079','286080','286401','286410','286853','286856','286972','287194','287195','288027','288187','288188','288189','288190','288191','288203','288204','288206','288207','288557','288558','288672','288673','288982','289100','289497','292387','293235','293236','293559','294173','294402','294618','294619','294736','295378','295568','295750','297476','297706','298005','298272','299640','300053','300274','301012','302216','303789','303941','161513','167754','167755','247190','251634','252032','262382','266737','269550','274561','274564','274566','274568','275269','275270','279204','284396','284399','284427','284428','288192','288193','288194','288195','291975','294891','297238','297524','297525','299285','157508','158768','160620','163792','164846','167082','168336','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','152977','160568','239028','240217','240697','242436','243699','244134','261748','292637') GROUP BY `montage` ORDER BY `montage` ASC
childsstroke1: montage
SELECT `montage`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `montage` !='' AND `modx_site_content`.`id` IN ('152977','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160568','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','232493','238394','239028','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240217','240430','240697','241265','241266','241288','241299','241452','241673','241674','242411','242436','242473','242781','242883','243124','243440','243515','243670','243699','243890','244071','244095','244134','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261748','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284396','284399','284401','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288395','288518','288557','288558','288581','288583','288630','288644','288672','288673','288707','288853','288859','288982','289100','289397','289497','289507','289508','289509','291581','291892','291975','292221','292387','292596','292637','292661','293235','293236','293495','293559','294173','294365','294402','294567','294618','294619','294736','294846','294891','295378','295424','295425','295498','295568','295569','295570','295571','295589','295592','295734','295736','295750','295932','297144','297155','297192','297238','297316','297337','297434','297476','297524','297525','297706','297732','298005','298042','298225','298272','298313','298407','299049','299257','299285','299370','299408','299410','299640','299785','300053','300274','301012','301024','302216','303789','303840','303941','303942') GROUP BY `montage` ORDER BY `montage` ASC
childsstroke: load_capacity
SELECT `load_capacity`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `load_capacity` !='' AND `modx_site_content`.`id` IN ('16','47','94','303','291727','153109','154488','155370','157260','157873','158480','158481','158819','158963','160065','160090','160439','160609','161232','161436','161437','161668','162125','162253','162367','162434','162566','163316','163317','163351','163517','163721','163761','163921','163944','164097','164119','164766','165037','165232','165354','165528','165618','165908','165940','166100','166107','166145','166212','166527','166640','167223','167269','167578','167753','167817','167850','167854','168040','168072','168081','168392','238394','239468','239791','239851','240430','241265','241266','241452','241673','241674','242411','242473','242781','243890','244095','244461','245021','245776','245831','245939','246194','246207','246208','246638','246646','246783','246986','247064','247401','247539','247554','248117','248489','248681','248682','248721','248765','248986','249020','249083','249088','249183','249193','249682','249779','250178','250624','250634','250958','250973','251325','251361','251394','251449','251467','251760','251892','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254660','254863','255005','255183','255222','255330','255953','256273','256499','256690','256822','256937','256938','257062','257230','261986','261988','262355','262362','262563','262615','263100','263487','264631','264632','265380','265446','265534','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','279110','279111','279122','279304','279410','279832','280328','280361','280413','280510','280511','280545','280991','281421','281621','281726','281808','281809','282081','282090','282201','282802','282803','282907','283616','283773','284239','284240','284242','284243','284249','284338','284339','284345','284361','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284401','284423','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','285308','285317','285488','285525','285757','285791','285916','285971','286022','286294','286357','286409','286611','286936','287105','287127','287228','287514','287515','288000','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','291892','292221','292596','292661','293495','294365','294567','294846','295424','295425','295498','295569','295570','295571','295589','295592','295734','295736','295932','297144','297155','297192','297316','297337','297434','297732','298042','298225','298313','298407','299049','299257','299370','299408','299410','299785','301024','303840','303942','154455','157272','157273','157274','157275','157276','157876','157877','157878','157880','157881','157912','157957','158301','158939','159048','159267','159610','160066','160334','160438','160996','161444','161445','161457','161505','162299','162661','163486','163687','164063','164431','164510','165601','166414','166549','166614','166629','167367','232493','239029','239488','239593','239637','240006','241288','241299','242883','243124','243440','243515','243670','244071','244180','244525','244639','244685','244795','245135','245275','245336','245887','246019','246382','246459','246765','246821','246964','247637','248107','248605','248814','249848','250269','250715','250780','250782','250897','250972','251335','251819','251868','251969','254617','255365','255995','256087','256436','256962','257161','262184','262930','263567','263682','263698','264466','264500','264886','265054','265145','265661','266578','266589','267385','267500','267626','268285','268383','269222','273475','273527','273629','273736','273737','274059','274064','274514','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274919','275045','275516','275801','276020','276400','276627','277322','277777','279042','279043','279109','280306','281283','281824','282065','282066','282067','282079','282766','283498','284148','284241','284244','284245','284246','284247','284248','284362','284363','284366','284367','284425','284999','285292','285390','285787','285902','285903','285905','285953','286079','286080','286401','286410','286853','286856','286972','287194','287195','288027','288187','288188','288189','288190','288191','288203','288204','288206','288207','288557','288558','288672','288673','288982','289100','289497','292387','293235','293236','293559','294173','294402','294618','294619','294736','295378','295568','295750','297476','297706','298005','298272','299640','300053','300274','301012','302216','303789','303941','161513','167754','167755','247190','251634','252032','262382','266737','269550','274561','274564','274566','274568','275269','275270','279204','284396','284399','284427','284428','288192','288193','288194','288195','291975','294891','297238','297524','297525','299285','157508','158768','160620','163792','164846','167082','168336','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','152977','160568','239028','240217','240697','242436','243699','244134','261748','292637') GROUP BY `load_capacity` ORDER BY `load_capacity` ASC
childsstroke1: load_capacity
SELECT `load_capacity`,count(*) as `c` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id` = `modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `template`= 3 AND `published`=1 AND `load_capacity` !='' AND `modx_site_content`.`id` IN ('152977','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160568','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','232493','238394','239028','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240217','240430','240697','241265','241266','241288','241299','241452','241673','241674','242411','242436','242473','242781','242883','243124','243440','243515','243670','243699','243890','244071','244095','244134','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261748','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284396','284399','284401','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288395','288518','288557','288558','288581','288583','288630','288644','288672','288673','288707','288853','288859','288982','289100','289397','289497','289507','289508','289509','291581','291892','291975','292221','292387','292596','292637','292661','293235','293236','293495','293559','294173','294365','294402','294567','294618','294619','294736','294846','294891','295378','295424','295425','295498','295568','295569','295570','295571','295589','295592','295734','295736','295750','295932','297144','297155','297192','297238','297316','297337','297434','297476','297524','297525','297706','297732','298005','298042','298225','298272','298313','298407','299049','299257','299285','299370','299408','299410','299640','299785','300053','300274','301012','301024','302216','303789','303840','303941','303942') GROUP BY `load_capacity` ORDER BY `load_capacity` ASC
childsstroke: esr
SELECT `esr`,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 `esr` !='' AND `modx_site_content`.`id` IN ('16','47','94','303','291727','153109','154488','155370','157260','157873','158480','158481','158819','158963','160065','160090','160439','160609','161232','161436','161437','161668','162125','162253','162367','162434','162566','163316','163317','163351','163517','163721','163761','163921','163944','164097','164119','164766','165037','165232','165354','165528','165618','165908','165940','166100','166107','166145','166212','166527','166640','167223','167269','167578','167753','167817','167850','167854','168040','168072','168081','168392','238394','239468','239791','239851','240430','241265','241266','241452','241673','241674','242411','242473','242781','243890','244095','244461','245021','245776','245831','245939','246194','246207','246208','246638','246646','246783','246986','247064','247401','247539','247554','248117','248489','248681','248682','248721','248765','248986','249020','249083','249088','249183','249193','249682','249779','250178','250624','250634','250958','250973','251325','251361','251394','251449','251467','251760','251892','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254660','254863','255005','255183','255222','255330','255953','256273','256499','256690','256822','256937','256938','257062','257230','261986','261988','262355','262362','262563','262615','263100','263487','264631','264632','265380','265446','265534','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','279110','279111','279122','279304','279410','279832','280328','280361','280413','280510','280511','280545','280991','281421','281621','281726','281808','281809','282081','282090','282201','282802','282803','282907','283616','283773','284239','284240','284242','284243','284249','284338','284339','284345','284361','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284401','284423','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','285308','285317','285488','285525','285757','285791','285916','285971','286022','286294','286357','286409','286611','286936','287105','287127','287228','287514','287515','288000','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','291892','292221','292596','292661','293495','294365','294567','294846','295424','295425','295498','295569','295570','295571','295589','295592','295734','295736','295932','297144','297155','297192','297316','297337','297434','297732','298042','298225','298313','298407','299049','299257','299370','299408','299410','299785','301024','303840','303942','154455','157272','157273','157274','157275','157276','157876','157877','157878','157880','157881','157912','157957','158301','158939','159048','159267','159610','160066','160334','160438','160996','161444','161445','161457','161505','162299','162661','163486','163687','164063','164431','164510','165601','166414','166549','166614','166629','167367','232493','239029','239488','239593','239637','240006','241288','241299','242883','243124','243440','243515','243670','244071','244180','244525','244639','244685','244795','245135','245275','245336','245887','246019','246382','246459','246765','246821','246964','247637','248107','248605','248814','249848','250269','250715','250780','250782','250897','250972','251335','251819','251868','251969','254617','255365','255995','256087','256436','256962','257161','262184','262930','263567','263682','263698','264466','264500','264886','265054','265145','265661','266578','266589','267385','267500','267626','268285','268383','269222','273475','273527','273629','273736','273737','274059','274064','274514','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274919','275045','275516','275801','276020','276400','276627','277322','277777','279042','279043','279109','280306','281283','281824','282065','282066','282067','282079','282766','283498','284148','284241','284244','284245','284246','284247','284248','284362','284363','284366','284367','284425','284999','285292','285390','285787','285902','285903','285905','285953','286079','286080','286401','286410','286853','286856','286972','287194','287195','288027','288187','288188','288189','288190','288191','288203','288204','288206','288207','288557','288558','288672','288673','288982','289100','289497','292387','293235','293236','293559','294173','294402','294618','294619','294736','295378','295568','295750','297476','297706','298005','298272','299640','300053','300274','301012','302216','303789','303941','161513','167754','167755','247190','251634','252032','262382','266737','269550','274561','274564','274566','274568','275269','275270','279204','284396','284399','284427','284428','288192','288193','288194','288195','291975','294891','297238','297524','297525','299285','157508','158768','160620','163792','164846','167082','168336','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','152977','160568','239028','240217','240697','242436','243699','244134','261748','292637') GROUP BY `esr` ORDER BY `esr` ASC
childsstroke1: esr
SELECT `esr`,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 `esr` !='' AND `modx_site_content`.`id` IN ('152977','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160568','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','232493','238394','239028','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240217','240430','240697','241265','241266','241288','241299','241452','241673','241674','242411','242436','242473','242781','242883','243124','243440','243515','243670','243699','243890','244071','244095','244134','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261748','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284396','284399','284401','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288395','288518','288557','288558','288581','288583','288630','288644','288672','288673','288707','288853','288859','288982','289100','289397','289497','289507','289508','289509','291581','291892','291975','292221','292387','292596','292637','292661','293235','293236','293495','293559','294173','294365','294402','294567','294618','294619','294736','294846','294891','295378','295424','295425','295498','295568','295569','295570','295571','295589','295592','295734','295736','295750','295932','297144','297155','297192','297238','297316','297337','297434','297476','297524','297525','297706','297732','298005','298042','298225','298272','298313','298407','299049','299257','299285','299370','299408','299410','299640','299785','300053','300274','301012','301024','302216','303789','303840','303941','303942') GROUP BY `esr` ORDER BY `esr` 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 ('16','47','94','303','291727','153109','154488','155370','157260','157873','158480','158481','158819','158963','160065','160090','160439','160609','161232','161436','161437','161668','162125','162253','162367','162434','162566','163316','163317','163351','163517','163721','163761','163921','163944','164097','164119','164766','165037','165232','165354','165528','165618','165908','165940','166100','166107','166145','166212','166527','166640','167223','167269','167578','167753','167817','167850','167854','168040','168072','168081','168392','238394','239468','239791','239851','240430','241265','241266','241452','241673','241674','242411','242473','242781','243890','244095','244461','245021','245776','245831','245939','246194','246207','246208','246638','246646','246783','246986','247064','247401','247539','247554','248117','248489','248681','248682','248721','248765','248986','249020','249083','249088','249183','249193','249682','249779','250178','250624','250634','250958','250973','251325','251361','251394','251449','251467','251760','251892','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254660','254863','255005','255183','255222','255330','255953','256273','256499','256690','256822','256937','256938','257062','257230','261986','261988','262355','262362','262563','262615','263100','263487','264631','264632','265380','265446','265534','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','279110','279111','279122','279304','279410','279832','280328','280361','280413','280510','280511','280545','280991','281421','281621','281726','281808','281809','282081','282090','282201','282802','282803','282907','283616','283773','284239','284240','284242','284243','284249','284338','284339','284345','284361','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284401','284423','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','285308','285317','285488','285525','285757','285791','285916','285971','286022','286294','286357','286409','286611','286936','287105','287127','287228','287514','287515','288000','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','291892','292221','292596','292661','293495','294365','294567','294846','295424','295425','295498','295569','295570','295571','295589','295592','295734','295736','295932','297144','297155','297192','297316','297337','297434','297732','298042','298225','298313','298407','299049','299257','299370','299408','299410','299785','301024','303840','303942','154455','157272','157273','157274','157275','157276','157876','157877','157878','157880','157881','157912','157957','158301','158939','159048','159267','159610','160066','160334','160438','160996','161444','161445','161457','161505','162299','162661','163486','163687','164063','164431','164510','165601','166414','166549','166614','166629','167367','232493','239029','239488','239593','239637','240006','241288','241299','242883','243124','243440','243515','243670','244071','244180','244525','244639','244685','244795','245135','245275','245336','245887','246019','246382','246459','246765','246821','246964','247637','248107','248605','248814','249848','250269','250715','250780','250782','250897','250972','251335','251819','251868','251969','254617','255365','255995','256087','256436','256962','257161','262184','262930','263567','263682','263698','264466','264500','264886','265054','265145','265661','266578','266589','267385','267500','267626','268285','268383','269222','273475','273527','273629','273736','273737','274059','274064','274514','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274919','275045','275516','275801','276020','276400','276627','277322','277777','279042','279043','279109','280306','281283','281824','282065','282066','282067','282079','282766','283498','284148','284241','284244','284245','284246','284247','284248','284362','284363','284366','284367','284425','284999','285292','285390','285787','285902','285903','285905','285953','286079','286080','286401','286410','286853','286856','286972','287194','287195','288027','288187','288188','288189','288190','288191','288203','288204','288206','288207','288557','288558','288672','288673','288982','289100','289497','292387','293235','293236','293559','294173','294402','294618','294619','294736','295378','295568','295750','297476','297706','298005','298272','299640','300053','300274','301012','302216','303789','303941','161513','167754','167755','247190','251634','252032','262382','266737','269550','274561','274564','274566','274568','275269','275270','279204','284396','284399','284427','284428','288192','288193','288194','288195','291975','294891','297238','297524','297525','299285','157508','158768','160620','163792','164846','167082','168336','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','152977','160568','239028','240217','240697','242436','243699','244134','261748','292637') 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 ('152977','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160568','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','232493','238394','239028','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240217','240430','240697','241265','241266','241288','241299','241452','241673','241674','242411','242436','242473','242781','242883','243124','243440','243515','243670','243699','243890','244071','244095','244134','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261748','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284368','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284393','284394','284395','284396','284399','284401','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288395','288518','288557','288558','288581','288583','288630','288644','288672','288673','288707','288853','288859','288982','289100','289397','289497','289507','289508','289509','291581','291892','291975','292221','292387','292596','292637','292661','293235','293236','293495','293559','294173','294365','294402','294567','294618','294619','294736','294846','294891','295378','295424','295425','295498','295568','295569','295570','295571','295589','295592','295734','295736','295750','295932','297144','297155','297192','297238','297316','297337','297434','297476','297524','297525','297706','297732','298005','298042','298225','298272','298313','298407','299049','299257','299285','299370','299408','299410','299640','299785','300053','300274','301012','301024','302216','303789','303840','303941','303942') GROUP BY `stock_status` ORDER BY `stock_status` ASC
