Exception: Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shop_discounts.percent' in 'field list'. Query: SELECT
SQL_CALC_FOUND_ROWS
`shop_items`.*, IF (`shop_items`.`shop_currency_id` = '3', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 23.639664 / 100, shop_items.price * 23.639664), IF (`shop_items`.`shop_currency_id` = '2', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 36.889479 / 100, shop_items.price * 36.889479), IF (`shop_items`.`shop_currency_id` = '1', IF (shop_discounts.percent, price * (100 - shop_discounts.percent) * 1 / 100, shop_items.price * 1), price))) AS `absolute_price`
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`.`end_datetime` >= '2024-11-14 01:10:39' OR `shop_discounts`.`end_datetime` = '0000-00-00 00:00:00' AND `shop_discounts`.`start_datetime` <= '2024-11-14 01:10:39' )
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = property_value_strings.property_id
WHERE `shop_items`.`shop_id` = '1' AND ( `shop_items`.`start_datetime` < '2024-11-14 01:10:39' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-11-14 01:10:39' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND ( `shop_item_properties`.`property_id` = '68' AND `property_value_strings`.`value` LIKE '%Черно-белый%' ) AND `shop_items`.`active` = 1 AND `shop_items`.`shop_group_id` = '25' AND `shop_items`.`modification_id` = 0 AND `shop_items`.`deleted` = 0
GROUP BY `shop_items`.`id`
HAVING COUNT(DISTINCT `shop_item_properties`.`property_id`) = 1
ORDER BY `absolute_price` ASC
LIMIT 1000
OFFSET 0
modules/core/database/pdo.php:675 Core_Exception->__construct
modules/core/querybuilder/statement.php:78 Core_DataBase_Pdo->query
modules/core/orm.php:522 Core_QueryBuilder_Statement->execute
modules/core/entity.php:581 Core_ORM->findAll
modules/shop/controller/show.php:1184 Core_Entity->findAll
hostcmsfiles/lib/lib_6/lib_6.php:563 Shop_Controller_Show->show
modules/lib/model.php:284 include
modules/core/page.php:166 Lib_Model->execute
templates/template9/template.htm:7 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template1/template.htm:73 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:594 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:237 Core_Router_Route->execute