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 ('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','284389','284391','284392','284393','284394','284395','284396','284399','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','287228','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','293235','293236','294618','294619','295424','295425','295568','295569','295570','295571','297238') 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 ('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','284389','284391','284392','284393','284394','284395','284396','284399','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','287228','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','293235','293236','294618','294619','295424','295425','295568','295569','295570','295571','297238') 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 ('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','284389','284391','284392','284393','284394','284395','284396','284399','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','287228','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','293235','293236','294618','294619','295424','295425','295568','295569','295570','295571','297238') 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 ('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','284389','284391','284392','284393','284394','284395','284396','284399','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','287228','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','293235','293236','294618','294619','295424','295425','295568','295569','295570','295571','297238') 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 ('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','284389','284391','284392','284393','284394','284395','284396','284399','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','287228','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','293235','293236','294618','294619','295424','295425','295568','295569','295570','295571','297238') 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 ('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','284389','284391','284392','284393','284394','284395','284396','284399','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','287228','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','293235','293236','294618','294619','295424','295425','295568','295569','295570','295571','297238') 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 ('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','284389','284391','284392','284393','284394','284395','284396','284399','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','287228','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','293235','293236','294618','294619','295424','295425','295568','295569','295570','295571','297238') 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 ('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','284389','284391','284392','284393','284394','284395','284396','284399','284423','284425','284427','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284439','287228','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288204','288206','288207','288208','288209','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','293235','293236','294618','294619','295424','295425','295568','295569','295570','295571','297238') GROUP BY `stock_status` ORDER BY `stock_status` ASC