Кварцевые резонаторы KSE

childsstroke: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('47','16','303','94','96','97','170068','170146','170609','202815','211509','211510','211511','211512','211513','211514','211515','211516','211517','211518','211519','211520','211521','211522','211523','211524','211525','211526','211527','211528','211529','211530','211531','211532','211533','211534','211535','211536','211537','211538','211539','211540','211541','215398','215850','215921','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','267871','268285','268383','269222','273314','273475','273527','273629','273736','273737','274059','274064','274486','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','142025','142222','142223','142228','142768','143051','143080','143134','143281','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','150075','150076','150077','150078','150079','150080','150081','150082','150083','150084','150811','150851','150862','150863','150864','150865','150868','150869','150875','150876','150879','150885','150919','150920','150921','150922','150923','150924','150925','150926','150927','150928','150929','150971','150982','150985','151109','151302','151314','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','201160','201257','202618','202651','202652','210525','210526','210527','210528','210529','210530','210531','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','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267850','267870','267872','267873','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273805','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274569','274570','274571','274572','274575','274576','274577','274578','274579','274580','274581','274582','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','266256','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','288084','286022','288165','286294','288172','286357','288173','286409','288174','286611','288175','286936','288176','287105','288000','288177','287127','288180','287228','288181','287514','288182','287515','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','143356','149740','149741','149742','149743','150930','150931','150932','151057','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','215922','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','141848','142854','157508','158768','160620','163792','164846','167082','168336','247190','249328','251634','252032','257158','266737','269550','275269','215884','275270','279204','262382','288192','288193','288194','288195','274560','274561','274562','274564','274565','274566','274567','274568','284396','284399','284400','284427','284428','161513','167754','167755') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke1: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `manuf` !='' AND `modx_site_content`.`id` IN ('284393','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284383','284384','284385','284391','284392','284394','284395','284396','284399','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','287228') GROUP BY `manuf` ORDER BY `manuf` ASC
childsstroke: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `parent` !='' AND `modx_site_content`.`id` IN ('47','16','303','94','96','97','170068','170146','170609','202815','211509','211510','211511','211512','211513','211514','211515','211516','211517','211518','211519','211520','211521','211522','211523','211524','211525','211526','211527','211528','211529','211530','211531','211532','211533','211534','211535','211536','211537','211538','211539','211540','211541','215398','215850','215921','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','267871','268285','268383','269222','273314','273475','273527','273629','273736','273737','274059','274064','274486','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','142025','142222','142223','142228','142768','143051','143080','143134','143281','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','150075','150076','150077','150078','150079','150080','150081','150082','150083','150084','150811','150851','150862','150863','150864','150865','150868','150869','150875','150876','150879','150885','150919','150920','150921','150922','150923','150924','150925','150926','150927','150928','150929','150971','150982','150985','151109','151302','151314','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','201160','201257','202618','202651','202652','210525','210526','210527','210528','210529','210530','210531','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','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267850','267870','267872','267873','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273805','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274569','274570','274571','274572','274575','274576','274577','274578','274579','274580','274581','274582','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','266256','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','288084','286022','288165','286294','288172','286357','288173','286409','288174','286611','288175','286936','288176','287105','288000','288177','287127','288180','287228','288181','287514','288182','287515','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','143356','149740','149741','149742','149743','150930','150931','150932','151057','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','215922','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','141848','142854','157508','158768','160620','163792','164846','167082','168336','247190','249328','251634','252032','257158','266737','269550','275269','215884','275270','279204','262382','288192','288193','288194','288195','274560','274561','274562','274564','274565','274566','274567','274568','284396','284399','284400','284427','284428','161513','167754','167755') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke1: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `parent` !='' AND `modx_site_content`.`id` IN ('284393','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284383','284384','284385','284391','284392','284394','284395','284396','284399','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','287228') GROUP BY `parent` ORDER BY `parent` ASC
childsstroke: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `freq_mhz` !='' AND `modx_site_content`.`id` IN ('47','16','303','94','96','97','170068','170146','170609','202815','211509','211510','211511','211512','211513','211514','211515','211516','211517','211518','211519','211520','211521','211522','211523','211524','211525','211526','211527','211528','211529','211530','211531','211532','211533','211534','211535','211536','211537','211538','211539','211540','211541','215398','215850','215921','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','267871','268285','268383','269222','273314','273475','273527','273629','273736','273737','274059','274064','274486','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','142025','142222','142223','142228','142768','143051','143080','143134','143281','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','150075','150076','150077','150078','150079','150080','150081','150082','150083','150084','150811','150851','150862','150863','150864','150865','150868','150869','150875','150876','150879','150885','150919','150920','150921','150922','150923','150924','150925','150926','150927','150928','150929','150971','150982','150985','151109','151302','151314','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','201160','201257','202618','202651','202652','210525','210526','210527','210528','210529','210530','210531','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','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267850','267870','267872','267873','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273805','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274569','274570','274571','274572','274575','274576','274577','274578','274579','274580','274581','274582','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','266256','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','288084','286022','288165','286294','288172','286357','288173','286409','288174','286611','288175','286936','288176','287105','288000','288177','287127','288180','287228','288181','287514','288182','287515','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','143356','149740','149741','149742','149743','150930','150931','150932','151057','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','215922','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','141848','142854','157508','158768','160620','163792','164846','167082','168336','247190','249328','251634','252032','257158','266737','269550','275269','215884','275270','279204','262382','288192','288193','288194','288195','274560','274561','274562','274564','274565','274566','274567','274568','284396','284399','284400','284427','284428','161513','167754','167755') GROUP BY `freq_mhz` ORDER BY `freq_mhz` ASC
childsstroke1: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `freq_mhz` !='' AND `modx_site_content`.`id` IN ('284393','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284383','284384','284385','284391','284392','284394','284395','284396','284399','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','287228') GROUP BY `freq_mhz` ORDER BY `freq_mhz` ASC
childsstroke: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `packages` !='' AND `modx_site_content`.`id` IN ('47','16','303','94','96','97','170068','170146','170609','202815','211509','211510','211511','211512','211513','211514','211515','211516','211517','211518','211519','211520','211521','211522','211523','211524','211525','211526','211527','211528','211529','211530','211531','211532','211533','211534','211535','211536','211537','211538','211539','211540','211541','215398','215850','215921','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','267871','268285','268383','269222','273314','273475','273527','273629','273736','273737','274059','274064','274486','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','142025','142222','142223','142228','142768','143051','143080','143134','143281','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','150075','150076','150077','150078','150079','150080','150081','150082','150083','150084','150811','150851','150862','150863','150864','150865','150868','150869','150875','150876','150879','150885','150919','150920','150921','150922','150923','150924','150925','150926','150927','150928','150929','150971','150982','150985','151109','151302','151314','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','201160','201257','202618','202651','202652','210525','210526','210527','210528','210529','210530','210531','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','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267850','267870','267872','267873','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273805','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274569','274570','274571','274572','274575','274576','274577','274578','274579','274580','274581','274582','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','266256','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','288084','286022','288165','286294','288172','286357','288173','286409','288174','286611','288175','286936','288176','287105','288000','288177','287127','288180','287228','288181','287514','288182','287515','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','143356','149740','149741','149742','149743','150930','150931','150932','151057','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','215922','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','141848','142854','157508','158768','160620','163792','164846','167082','168336','247190','249328','251634','252032','257158','266737','269550','275269','215884','275270','279204','262382','288192','288193','288194','288195','274560','274561','274562','274564','274565','274566','274567','274568','284396','284399','284400','284427','284428','161513','167754','167755') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke1: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `packages` !='' AND `modx_site_content`.`id` IN ('284393','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284383','284384','284385','284391','284392','284394','284395','284396','284399','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','287228') GROUP BY `packages` ORDER BY `packages` ASC
childsstroke: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `montage` !='' AND `modx_site_content`.`id` IN ('47','16','303','94','96','97','170068','170146','170609','202815','211509','211510','211511','211512','211513','211514','211515','211516','211517','211518','211519','211520','211521','211522','211523','211524','211525','211526','211527','211528','211529','211530','211531','211532','211533','211534','211535','211536','211537','211538','211539','211540','211541','215398','215850','215921','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','267871','268285','268383','269222','273314','273475','273527','273629','273736','273737','274059','274064','274486','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','142025','142222','142223','142228','142768','143051','143080','143134','143281','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','150075','150076','150077','150078','150079','150080','150081','150082','150083','150084','150811','150851','150862','150863','150864','150865','150868','150869','150875','150876','150879','150885','150919','150920','150921','150922','150923','150924','150925','150926','150927','150928','150929','150971','150982','150985','151109','151302','151314','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','201160','201257','202618','202651','202652','210525','210526','210527','210528','210529','210530','210531','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','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267850','267870','267872','267873','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273805','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274569','274570','274571','274572','274575','274576','274577','274578','274579','274580','274581','274582','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','266256','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','288084','286022','288165','286294','288172','286357','288173','286409','288174','286611','288175','286936','288176','287105','288000','288177','287127','288180','287228','288181','287514','288182','287515','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','143356','149740','149741','149742','149743','150930','150931','150932','151057','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','215922','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','141848','142854','157508','158768','160620','163792','164846','167082','168336','247190','249328','251634','252032','257158','266737','269550','275269','215884','275270','279204','262382','288192','288193','288194','288195','274560','274561','274562','274564','274565','274566','274567','274568','284396','284399','284400','284427','284428','161513','167754','167755') GROUP BY `montage` ORDER BY `montage` ASC
childsstroke1: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `montage` !='' AND `modx_site_content`.`id` IN ('284393','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284383','284384','284385','284391','284392','284394','284395','284396','284399','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','287228') GROUP BY `montage` ORDER BY `montage` ASC
childsstroke: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `load_capacity` !='' AND `modx_site_content`.`id` IN ('47','16','303','94','96','97','170068','170146','170609','202815','211509','211510','211511','211512','211513','211514','211515','211516','211517','211518','211519','211520','211521','211522','211523','211524','211525','211526','211527','211528','211529','211530','211531','211532','211533','211534','211535','211536','211537','211538','211539','211540','211541','215398','215850','215921','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','267871','268285','268383','269222','273314','273475','273527','273629','273736','273737','274059','274064','274486','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','142025','142222','142223','142228','142768','143051','143080','143134','143281','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','150075','150076','150077','150078','150079','150080','150081','150082','150083','150084','150811','150851','150862','150863','150864','150865','150868','150869','150875','150876','150879','150885','150919','150920','150921','150922','150923','150924','150925','150926','150927','150928','150929','150971','150982','150985','151109','151302','151314','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','201160','201257','202618','202651','202652','210525','210526','210527','210528','210529','210530','210531','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','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267850','267870','267872','267873','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273805','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274569','274570','274571','274572','274575','274576','274577','274578','274579','274580','274581','274582','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','266256','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','288084','286022','288165','286294','288172','286357','288173','286409','288174','286611','288175','286936','288176','287105','288000','288177','287127','288180','287228','288181','287514','288182','287515','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','143356','149740','149741','149742','149743','150930','150931','150932','151057','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','215922','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','141848','142854','157508','158768','160620','163792','164846','167082','168336','247190','249328','251634','252032','257158','266737','269550','275269','215884','275270','279204','262382','288192','288193','288194','288195','274560','274561','274562','274564','274565','274566','274567','274568','284396','284399','284400','284427','284428','161513','167754','167755') GROUP BY `load_capacity` ORDER BY `load_capacity` ASC
childsstroke1: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `load_capacity` !='' AND `modx_site_content`.`id` IN ('284393','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284383','284384','284385','284391','284392','284394','284395','284396','284399','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','287228') GROUP BY `load_capacity` ORDER BY `load_capacity` ASC
childsstroke: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `esr` !='' AND `modx_site_content`.`id` IN ('47','16','303','94','96','97','170068','170146','170609','202815','211509','211510','211511','211512','211513','211514','211515','211516','211517','211518','211519','211520','211521','211522','211523','211524','211525','211526','211527','211528','211529','211530','211531','211532','211533','211534','211535','211536','211537','211538','211539','211540','211541','215398','215850','215921','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','267871','268285','268383','269222','273314','273475','273527','273629','273736','273737','274059','274064','274486','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','142025','142222','142223','142228','142768','143051','143080','143134','143281','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','150075','150076','150077','150078','150079','150080','150081','150082','150083','150084','150811','150851','150862','150863','150864','150865','150868','150869','150875','150876','150879','150885','150919','150920','150921','150922','150923','150924','150925','150926','150927','150928','150929','150971','150982','150985','151109','151302','151314','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','201160','201257','202618','202651','202652','210525','210526','210527','210528','210529','210530','210531','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','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267850','267870','267872','267873','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273805','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274569','274570','274571','274572','274575','274576','274577','274578','274579','274580','274581','274582','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','266256','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','288084','286022','288165','286294','288172','286357','288173','286409','288174','286611','288175','286936','288176','287105','288000','288177','287127','288180','287228','288181','287514','288182','287515','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','143356','149740','149741','149742','149743','150930','150931','150932','151057','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','215922','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','141848','142854','157508','158768','160620','163792','164846','167082','168336','247190','249328','251634','252032','257158','266737','269550','275269','215884','275270','279204','262382','288192','288193','288194','288195','274560','274561','274562','274564','274565','274566','274567','274568','284396','284399','284400','284427','284428','161513','167754','167755') GROUP BY `esr` ORDER BY `esr` ASC
childsstroke1: 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` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `template`= 3 AND `published`=1 AND `esr` !='' AND `modx_site_content`.`id` IN ('284393','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284383','284384','284385','284391','284392','284394','284395','284396','284399','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','287228') GROUP BY `esr` ORDER BY `esr` ASC
SELECT `modx_site_content_tmc`.*,`modx_site_content`.`pagetitle`,`modx_site_content`.`introtext` 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_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `modx_site_content`.`published` AND `manuf` IN ('KSE') AND (`qty_msk`-`rez_msk` > 0) AND `modx_site_content_tmc`.`resource` IN ('47','16','303','94','96','97','170068','170146','170609','202815','211509','211510','211511','211512','211513','211514','211515','211516','211517','211518','211519','211520','211521','211522','211523','211524','211525','211526','211527','211528','211529','211530','211531','211532','211533','211534','211535','211536','211537','211538','211539','211540','211541','215398','215850','215921','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','267871','268285','268383','269222','273314','273475','273527','273629','273736','273737','274059','274064','274486','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','142025','142222','142223','142228','142768','143051','143080','143134','143281','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','150075','150076','150077','150078','150079','150080','150081','150082','150083','150084','150811','150851','150862','150863','150864','150865','150868','150869','150875','150876','150879','150885','150919','150920','150921','150922','150923','150924','150925','150926','150927','150928','150929','150971','150982','150985','151109','151302','151314','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','201160','201257','202618','202651','202652','210525','210526','210527','210528','210529','210530','210531','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','266266','266288','266453','266488','266590','266600','266640','266792','266805','267101','267134','267139','267167','267461','267645','267710','267740','267850','267870','267872','267873','267923','268702','268770','268857','269099','269237','269240','269339','269356','269500','269761','273451','273802','273803','273804','273805','273806','273807','273936','273985','273986','274518','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274569','274570','274571','274572','274575','274576','274577','274578','274579','274580','274581','274582','274583','274584','274585','275233','275680','276755','277277','277392','278428','279010','279078','279103','279104','279105','279106','279107','279108','266256','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','288084','286022','288165','286294','288172','286357','288173','286409','288174','286611','288175','286936','288176','287105','288000','288177','287127','288180','287228','288181','287514','288182','287515','288183','288184','288185','288208','288209','288210','288395','288518','288583','288630','288644','288707','288853','288859','289397','289507','289508','289509','291581','143356','149740','149741','149742','149743','150930','150931','150932','151057','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','215922','239904','240008','244406','248569','250777','250781','251826','256574','262788','262791','265741','266652','267048','267605','269490','274694','274784','284885','288581','141848','142854','157508','158768','160620','163792','164846','167082','168336','247190','249328','251634','252032','257158','266737','269550','275269','215884','275270','279204','262382','288192','288193','288194','288195','274560','274561','274562','274564','274565','274566','274567','274568','284396','284399','284400','284427','284428','161513','167754','167755') ORDER BY `stock_status` ASC LIMIT 32 OFFSET 0