Антивандальные индикаторы

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 ('294711','294712','294713','294714','286286','286287') ORDER BY `stock_status` ASC LIMIT 32 OFFSET 0

Антивандальный индикатор GQ12WF-G

RUICHI

арт. 141800

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`=286286

Под заказ

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`=286286

В сравнение