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` WHERE `modx_site_content`.`published` AND `manuf` = "YAGEO (PHYCOMP)" AND `modx_site_content_tmc`.`resource` IN ('160601','161600','162882','162883','162884','162886','163857','167782','167950','167990','168311','242748','242762','244688','246294','247275','247483','248738','250839','251005','251345','254773','265428','266604','274684','275372','276599','278619','281819') ORDER BY `stock_status` ASC LIMIT 32 OFFSET 0
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=281819
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=167950
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=168311
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=251005
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=160601
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=247483
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=276599
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=244688
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=251345
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=250839
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=247275
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=163857
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=254773
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=246294
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=266604
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=275372
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=167990
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=242748
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=161600
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=162882
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=162883
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=162884
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=162886
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=242762
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=167782
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=274684
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=265428
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=278619
SELECT `qty`+`qty_msk`-`rez_minsk`-`rez_msk` as `qt`,`qty`-`rez_minsk` as `qt_minsk`, `qty_msk`-`rez_msk` as `qt_msk`,`modx_site_content_tmc`.`unit`,`modx_site_content_tmc`.`stock_status`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`status_tov`,`packing` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `modx_site_content_tmc`.`resource`=248738
Удаленное рабочее место «Radiodetali», предназначено для резервирования, заказа,
оформления счета на оплату и получения электронных компонентов, хранящихся на складах и удаленных складах поставщиков.