Интернет-магазин стабильной техники 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` <= '16:07:11' AND `shop_discounts`.`end_time` >= '16:07:11' AND `shop_discounts`.`start_datetime` <= '2021-04-14 16:07:11' AND ( `shop_discounts`.`end_datetime` >= '2021-04-14 16:07:11' 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
10 950
10950.00 UAH
19 220
19220.00 UAH
14 810
14810.00 UAH
12 630
12630.00 UAH
10 630
10630.00 UAH
18 240
18240.00 UAH
14 030
14030.00 UAH
12 210
12210.00 UAH
8 830
8830.00 UAH
15 470
15470.00 UAH
12 980
12980.00 UAH
9 970
9970.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)