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 `modx_site_content_tmc`.`resource` IN ('169315','208173','215627','215628','215629','215631','215632','215633','215754','215755','215756','215757','215758','215777','238059','238142','238143','238144','238185','238502','239251','239252','240116','240139','240140','240450','241027','242104','242105','242175','242282','242498','243079','244640','244655','244656','245472','249026','249027','249198','249199','249200','249201','249202','249218','250656','251649','255782','256918','266080','266411','269397','269625','278123','278124','284551','284552','284553','284554','285201','285202','285203','285204','141707','142033','142046','142047','142048','142049','142857','143536','148669','150462','151238','151426','153060','153882','153883','153884','154424','155287','155452','155823','155824','158700','159242','159644','160592','161751','161753','161754','161755','163016','163801','164103','164642','168124') ORDER BY `stock_status` ASC LIMIT 32 OFFSET 96
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`pod_ost`,`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`,`modx_site_content_sklad`.`qty_msk`,`modx_site_content_sklad`.`rez_msk`,`modx_site_content_sklad`.`qty`,`modx_site_content_sklad`.`rez_minsk` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=285204
SELECT `modx_site_content_tmc`.`manuf`,`modx_site_content_tmc`.`raspr`,`modx_site_content_tmc`.`will`,`modx_site_content_tmc`.`pod_ost`,`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`,`modx_site_content_sklad`.`qty_msk`,`modx_site_content_sklad`.`rez_msk`,`modx_site_content_sklad`.`qty`,`modx_site_content_sklad`.`rez_minsk` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` WHERE `resource`=285204
Под заказ
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`=285204
Удаленное рабочее место «Radiodetali», предназначено для резервирования, заказа,
оформления счета на оплату и получения электронных компонентов, хранящихся на складах и удаленных складах поставщиков.
