Интернет-магазин стабильной техники 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` <= '17:22:43' AND `shop_discounts`.`end_time` >= '17:22:43' AND `shop_discounts`.`start_datetime` <= '2021-04-14 17:22:43' AND ( `shop_discounts`.`end_datetime` >= '2021-04-14 17:22:43' 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

Метка — аккумулятор .

3 948
3948.00 UAH
3 469
3468.60 UAH
2 792
2791.80 UAH
2 157
2157.30 UAH
1 497
1497.42 UAH
11 111
11110.80 UAH
6 965
6965.40 UAH
5 640
5640.00 UAH
5 443
5442.60 UAH
4 625
4624.80 UAH
2 792
2791.80 UAH
13 113
13113.00 UAH
9 701
9700.80 UAH
6 458
6457.80 UAH
4 794
4794.00 UAH
6 937
6937.20 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)