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 ('284368','284393','284427','284439','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288206','288207','288208','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','141848','142025','142222','142223','142228','142768','142854','143051','143080','143134','143281','143356','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','149740','149741','149742','149743','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','150930','150931','150932','150971','150982','150985','151057','151109','151302','151314','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','170068','170146','170609','201160','201257','202618','202651','202652','202815','210525','210526','210527','210528','210529','210530','210531','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','215884','215921','215922','232493','238394','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240430','241265','241266','241288','241299','241452','241673','241674','242411','242473','242781','242883','243124','243440','243515','243670','243890','244071','244095','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284394','284395','284396','284399','284401','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288204','288209','288395','288518','288581','288583','288630','288644','288853','288859','288982','289100','289497') 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 ('284368','284393','284427','284439','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288206','288207','288208','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','141848','142025','142222','142223','142228','142768','142854','143051','143080','143134','143281','143356','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','149740','149741','149742','149743','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','150930','150931','150932','150971','150982','150985','151057','151109','151302','151314','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','170068','170146','170609','201160','201257','202618','202651','202652','202815','210525','210526','210527','210528','210529','210530','210531','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','215884','215921','215922','232493','238394','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240430','241265','241266','241288','241299','241452','241673','241674','242411','242473','242781','242883','243124','243440','243515','243670','243890','244071','244095','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284394','284395','284396','284399','284401','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288204','288209','288395','288518','288581','288583','288630','288644','288853','288859','288982','289100','289497') 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 ('284368','284393','284427','284439','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288206','288207','288208','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','141848','142025','142222','142223','142228','142768','142854','143051','143080','143134','143281','143356','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','149740','149741','149742','149743','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','150930','150931','150932','150971','150982','150985','151057','151109','151302','151314','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','170068','170146','170609','201160','201257','202618','202651','202652','202815','210525','210526','210527','210528','210529','210530','210531','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','215884','215921','215922','232493','238394','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240430','241265','241266','241288','241299','241452','241673','241674','242411','242473','242781','242883','243124','243440','243515','243670','243890','244071','244095','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284394','284395','284396','284399','284401','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288204','288209','288395','288518','288581','288583','288630','288644','288853','288859','288982','289100','289497') 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 ('284368','284393','284427','284439','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288206','288207','288208','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','141848','142025','142222','142223','142228','142768','142854','143051','143080','143134','143281','143356','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','149740','149741','149742','149743','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','150930','150931','150932','150971','150982','150985','151057','151109','151302','151314','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','170068','170146','170609','201160','201257','202618','202651','202652','202815','210525','210526','210527','210528','210529','210530','210531','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','215884','215921','215922','232493','238394','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240430','241265','241266','241288','241299','241452','241673','241674','242411','242473','242781','242883','243124','243440','243515','243670','243890','244071','244095','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284394','284395','284396','284399','284401','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288204','288209','288395','288518','288581','288583','288630','288644','288853','288859','288982','289100','289497') 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 ('284368','284393','284427','284439','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288206','288207','288208','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','141848','142025','142222','142223','142228','142768','142854','143051','143080','143134','143281','143356','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','149740','149741','149742','149743','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','150930','150931','150932','150971','150982','150985','151057','151109','151302','151314','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','170068','170146','170609','201160','201257','202618','202651','202652','202815','210525','210526','210527','210528','210529','210530','210531','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','215884','215921','215922','232493','238394','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240430','241265','241266','241288','241299','241452','241673','241674','242411','242473','242781','242883','243124','243440','243515','243670','243890','244071','244095','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284394','284395','284396','284399','284401','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288204','288209','288395','288518','288581','288583','288630','288644','288853','288859','288982','289100','289497') 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 ('284368','284393','284427','284439','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288206','288207','288208','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','141848','142025','142222','142223','142228','142768','142854','143051','143080','143134','143281','143356','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','149740','149741','149742','149743','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','150930','150931','150932','150971','150982','150985','151057','151109','151302','151314','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','170068','170146','170609','201160','201257','202618','202651','202652','202815','210525','210526','210527','210528','210529','210530','210531','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','215884','215921','215922','232493','238394','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240430','241265','241266','241288','241299','241452','241673','241674','242411','242473','242781','242883','243124','243440','243515','243670','243890','244071','244095','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284394','284395','284396','284399','284401','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288204','288209','288395','288518','288581','288583','288630','288644','288853','288859','288982','289100','289497') 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 ('284368','284393','284427','284439','288180','288181','288182','288183','288184','288185','288187','288188','288189','288190','288191','288192','288193','288194','288195','288203','288206','288207','288208','288210','288557','288558','288672','288673','288707','289397','289507','289508','289509','291581','141848','142025','142222','142223','142228','142768','142854','143051','143080','143134','143281','143356','143837','143839','144224','146561','147731','147874','147895','147896','147897','148025','148409','148683','149740','149741','149742','149743','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','150930','150931','150932','150971','150982','150985','151057','151109','151302','151314','153109','154455','154488','155370','157260','157272','157273','157274','157275','157276','157508','157873','157876','157877','157878','157880','157881','157912','157957','158301','158480','158481','158768','158819','158939','158963','159048','159267','159610','160065','160066','160090','160334','160438','160439','160609','160620','160996','161232','161436','161437','161444','161445','161457','161505','161513','161668','162125','162253','162299','162367','162434','162566','162661','163316','163317','163351','163486','163517','163687','163721','163761','163792','163921','163944','164063','164097','164119','164431','164510','164766','164846','165037','165232','165354','165528','165601','165618','165908','165940','166100','166107','166145','166212','166414','166527','166549','166614','166629','166640','167082','167223','167269','167367','167578','167753','167754','167755','167817','167850','167854','168040','168072','168081','168336','168392','170068','170146','170609','201160','201257','202618','202651','202652','202815','210525','210526','210527','210528','210529','210530','210531','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','215884','215921','215922','232493','238394','239029','239468','239488','239593','239637','239791','239851','239904','240006','240008','240430','241265','241266','241288','241299','241452','241673','241674','242411','242473','242781','242883','243124','243440','243515','243670','243890','244071','244095','244180','244406','244461','244525','244639','244685','244795','245021','245135','245275','245336','245776','245831','245887','245939','246019','246194','246207','246208','246382','246459','246638','246646','246765','246783','246821','246964','246986','247064','247190','247401','247539','247554','247637','248107','248117','248489','248569','248605','248681','248682','248721','248765','248814','248986','249020','249083','249088','249183','249193','249682','249779','249848','250178','250269','250624','250634','250715','250777','250780','250781','250782','250897','250958','250972','250973','251325','251335','251361','251394','251449','251467','251634','251760','251819','251826','251868','251892','251969','252032','253032','253034','253414','253484','253637','253822','253900','254335','254355','254434','254617','254660','254863','255005','255183','255222','255330','255365','255953','255995','256087','256273','256436','256499','256574','256690','256822','256937','256938','256962','257062','257161','257230','261986','261988','262184','262355','262362','262382','262563','262615','262788','262791','262930','263100','263487','263567','263682','263698','264466','264500','264631','264632','264886','265054','265145','265380','265446','265534','265661','265741','265883','265913','265964','265974','266189','266201','266256','266266','266288','266453','266488','266578','266589','266590','266600','266640','266652','266737','266792','266805','267048','267101','267134','267139','267167','267385','267461','267500','267605','267626','267645','267710','267740','267923','268285','268383','268702','268770','268857','269099','269222','269237','269240','269339','269356','269490','269500','269550','269761','273451','273475','273527','273629','273736','273737','273802','273803','273804','273806','273807','273936','273985','273986','274059','274064','274514','274518','274519','274520','274521','274523','274524','274525','274526','274527','274528','274529','274530','274531','274532','274533','274534','274535','274536','274537','274538','274541','274543','274545','274546','274549','274550','274551','274552','274561','274564','274566','274568','274571','274572','274576','274577','274579','274580','274581','274583','274584','274585','274694','274784','274919','275045','275233','275269','275270','275516','275680','275801','276020','276400','276627','276755','277277','277322','277392','277777','278428','279010','279042','279043','279078','279103','279104','279105','279106','279107','279108','279109','279110','279111','279122','279204','279304','279410','279832','280306','280328','280361','280413','280510','280511','280545','280991','281283','281421','281621','281726','281808','281809','281824','282065','282066','282067','282079','282081','282090','282201','282766','282802','282803','282907','283498','283616','283773','284148','284239','284240','284241','284242','284243','284244','284245','284246','284247','284248','284249','284338','284339','284345','284361','284362','284363','284366','284367','284369','284370','284371','284372','284375','284379','284381','284382','284383','284384','284385','284386','284387','284389','284390','284391','284392','284394','284395','284396','284399','284401','284423','284425','284428','284430','284431','284432','284433','284434','284435','284436','284437','284438','284498','284575','284603','284885','284999','285292','285308','285317','285390','285488','285525','285757','285787','285791','285902','285903','285905','285916','285953','285971','286022','286079','286080','286294','286357','286401','286409','286410','286611','286853','286856','286936','286972','287105','287127','287194','287195','287228','287514','287515','288000','288027','288084','288165','288172','288173','288174','288175','288176','288177','288204','288209','288395','288518','288581','288583','288630','288644','288853','288859','288982','289100','289497') 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 `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
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=284393
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=143839
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=143839
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=144224
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=144224
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=147874
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=147874
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=147895
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=147895
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=147896
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=147896
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=148409
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=148683
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=148683
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150076
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150076
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150080
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150081
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150081
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150083
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150864
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150864
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150865
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150865
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150868
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150869
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150869
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150875
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150919
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150919
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150920
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150920
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150923
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150927
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150927
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150929
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150929
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150971
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150971
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150982
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150982
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=150985
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=153109
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=154488
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=155370
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=157260
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=157260
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=157273
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=157273
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=157873
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=157873
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_sklad`.`nelikvid`,`modx_site_content_sklad`.`price`,`modx_site_content_sklad`.`price2`,`modx_site_content_sklad`.`price3`,`modx_site_content_sklad`.`price4`,`modx_site_content_sklad`.`interval`,`modx_site_content_sklad`.`interval2`,`modx_site_content_sklad`.`interval3`,`modx_site_content_sklad`.`interval4`,`modx_site_content_sklad`.`packing`,`modx_site_content_tmc`.`unit`,`qty_msk`-`rez_msk` + `qty`-`rez_minsk` as `qt` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=157878
Удаленное рабочее место «Radiodetali», предназначено для резервирования, заказа,
оформления счета на оплату и получения электронных компонентов, хранящихся на складах и удаленных складах поставщиков.
