Интернет-магазин стабильной техники OSF 49000 Днепр +380 95 2919213 +380 98 2814589 stabilizators.net@gmail.com Алексей Степаненко
Шкафы учета, автоматика, низковольтное оборудования
В корзине нет ни одного товара
Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shop_discounts.day3' in 'on clause'. Query: SELECT MIN(t.price_absolute) AS `min`, MAX(t.price_absolute) AS `max` FROM (SELECT IF (`shop_items`.`shop_currency_id` = '3', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 28.2 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 28.2), IF (`shop_items`.`shop_currency_id` = '2', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 34.49 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 34.49), IF (`shop_items`.`shop_currency_id` = '4', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 1 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 1), IF (`shop_items`.`shop_currency_id` = '1', IF (COUNT(`shop_discounts`.`id`), ((`shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100)) * (1 - SUM(DISTINCT IF(`shop_discounts`.`type` = 0, `shop_discounts`.`value`, 0)) / 100)) * 1 - SUM(DISTINCT IF(`shop_discounts`.`type`, `shop_discounts`.`value`, 0)), (`shop_items`.`price`) * 1), `shop_items`.`price` + IF(`shop_taxes`.`tax_is_included` IS NULL OR `shop_taxes`.`tax_is_included` = 1, 0, `shop_items`.`price` * `shop_taxes`.`rate` / 100))))) AS `price_absolute` FROM `shop_items` LEFT OUTER JOIN `shop_item_discounts` ON `shop_items`.`id` = `shop_item_discounts`.`shop_item_id` LEFT OUTER JOIN `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` AND `shop_discounts`.`active` = 1 AND `shop_discounts`.`deleted` = 0 AND `shop_discounts`.`day3` = 1 AND `shop_discounts`.`start_time` <= '15:53:18' AND `shop_discounts`.`end_time` >= '15:53:18' AND `shop_discounts`.`start_datetime` <= '2021-04-14 15:53:18' AND ( `shop_discounts`.`end_datetime` >= '2021-04-14 15:53:18' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' ) LEFT OUTER JOIN `shop_taxes` ON `shop_taxes`.`id` = `shop_items`.`shop_tax_id` WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`shop_id` = '3' AND `shop_items`.`active` = 1 AND `shop_items`.`shortcut_id` = 0 AND `shop_items`.`shop_group_id` = 0 GROUP BY `shop_items`.`id`) AS `t`
modules/core/database/pdo.php:604 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query
modules/shop/controller/show.php:3619 Core_QueryBuilder_Statement->execute
hostcmsfiles/lib/lib_90/lib_90.php:234 Shop_Controller_Show->addMinMaxPrice
modules/lib/model.php:278 include
modules/template/section/lib/model.php:167 Lib_Model->execute
modules/template/model.php:801 Template_Section_Lib_Model->execute
templates/template19/template.htm:6 Template_Model->showSection
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template13/template.htm:94 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:583 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:238 Core_Router_Route->execute

Метка — стабилизатор симисторный .

7 480
7480.00 UAH
6 920
6920.00 UAH
10 560
10560.00 UAH
8 600
8600.00 UAH
21 500
21500.00 UAH
19 590
19590.00 UAH
16 075
16075.00 UAH
13 925
13925.00 UAH
13 360
13360.00 UAH
11 860
11860.00 UAH
18 500
18500.00 UAH
15 655
15655.00 UAH
13 175
13175.00 UAH
10 740
10740.00 UAH
9 800
9800.00 UAH
8 720
8720.00 UAH
Показать по: 20 50 100
TOP Предупреждение: Declaration of Core_Compress::_getCssCompressed() should be compatible with Core_Page::_getCssCompressed($bExternal = true) в файле /home/xela/web/shop.osf.com.ua/public_shtml/modules/core/compress.php (строка 0)