Exception: Query error 1054: Unknown column 'shop_discounts.percent' in 'field list'. Query: SELECT
DISTINCT
SQL_CALC_FOUND_ROWS
`shop_items`.`id`, `shop_items`.`shortcut_id` AS `shop_items_catalog_shortcut_id`, `shop_items`.`shop_tax_id`, `shop_items`.`shop_seller_id` AS `shop_sallers_id`, `shop_items`.`shop_group_id` AS `shop_groups_id`, `shop_items`.`shop_currency_id`, `shop_items`.`shop_id` AS `shop_shops_id`, `shop_items`.`shop_producer_id` AS `shop_producers_list_id`, `shop_items`.`shop_measure_id` AS `shop_mesures_id`, `shop_items`.`type` AS `shop_items_catalog_type`, `shop_items`.`name` AS `shop_items_catalog_name`, `shop_items`.`marking` AS `shop_items_catalog_marking`, `shop_items`.`vendorcode` AS `shop_vendorcode`, `shop_items`.`description` AS `shop_items_catalog_description`, `shop_items`.`text` AS `shop_items_catalog_text`, `shop_items`.`image_large` AS `shop_items_catalog_image`, `shop_items`.`image_small` AS `shop_items_catalog_small_image`, `shop_items`.`weight` AS `shop_items_catalog_weight`, `shop_items`.`price` AS `shop_items_catalog_price`, `shop_items`.`active` AS `shop_items_catalog_is_active`, `shop_items`.`siteuser_group_id` AS `shop_items_catalog_access`, `shop_items`.`sorting` AS `shop_items_catalog_order`, `shop_items`.`path` AS `shop_items_catalog_path`, `shop_items`.`seo_title` AS `shop_items_catalog_seo_title`, `shop_items`.`seo_description` AS `shop_items_catalog_seo_description`, `shop_items`.`seo_keywords` AS `shop_items_catalog_seo_keywords`, `shop_items`.`indexing` AS `shop_items_catalog_indexation`, `shop_items`.`image_small_height` AS `shop_items_catalog_small_image_height`, `shop_items`.`image_small_width` AS `shop_items_catalog_small_image_width`, `shop_items`.`image_large_height` AS `shop_items_catalog_big_image_height`, `shop_items`.`image_large_width` AS `shop_items_catalog_big_image_width`, `shop_items`.`yandex_market` AS `shop_items_catalog_yandex_market_allow`, `shop_items`.`yandex_market_bid` AS `shop_items_catalog_yandex_market_bid`, `shop_items`.`yandex_market_cid` AS `shop_items_catalog_yandex_market_cid`, `shop_items`.`yandex_market_sales_notes` AS `shop_items_catalog_yandex_market_sales_notes`, `shop_items`.`siteuser_id` AS `site_users_id`, `shop_items`.`datetime` AS `shop_items_catalog_date_time`, `shop_items`.`modification_id` AS `shop_items_catalog_modification_id`, `shop_items`.`guid` AS `shop_items_cml_id`, `shop_items`.`start_datetime` AS `shop_items_catalog_putoff_date`, `shop_items`.`end_datetime` AS `shop_items_catalog_putend_date`, `shop_items`.`showed` AS `shop_items_catalog_show_count`, shop_discounts.percent, 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 item_price_absolute
FROM `shop_items`
LEFT OUTER JOIN shop_item_discounts on (shop_items.id = shop_item_discounts.id) left join shop_discounts on (shop_item_discounts.id = shop_discounts.id and (shop_discounts.end_datetime >= '2024-12-11 21:17:48' or shop_discounts.end_datetime ='0000-00-00 00:00:00') and shop_discounts.start_datetime <= '2024-12-11 21:17:48')
WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`shop_id` = 1 AND `shop_items`.`active` = 1 AND `shop_items`.`shop_group_id` = 592 AND ( `shop_items`.`end_datetime` >= '2024-12-11 21:17:48' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`start_datetime` <= '2024-12-11 21:17:48' AND `shop_items`.`modification_id` = 0
HAVING 1
ORDER BY `item_price_absolute` DESC
LIMIT 20
OFFSET 0
36 modules/core/exception.php
615 modules/core/database/mysql.php
80 modules/core/querybuilder/statement.php
4876 modules/hostcms5/shop/shop.class.php
14962 modules/hostcms5/shop/shop.class.php
17565 modules/hostcms5/shop/shop.class.php
822 hostcmsfiles/lib/lib_6/lib_6.php
271 modules/lib/model.php
166 modules/core/page.php
4 templates/template11/template.htm
96 modules/template/model.php
166 modules/core/page.php
329 templates/template1/template.htm
96 modules/template/model.php
166 modules/core/page.php
511 modules/core/command/controller/default.php
109 modules/core/command/controller/hostcms5/default.php
195 modules/core/router/route.php
239 index.php
36 modules/core/exception.php
615 modules/core/database/mysql.php
80 modules/core/querybuilder/statement.php
4876 modules/hostcms5/shop/shop.class.php
14962 modules/hostcms5/shop/shop.class.php
17565 modules/hostcms5/shop/shop.class.php
822 hostcmsfiles/lib/lib_6/lib_6.php
271 modules/lib/model.php
166 modules/core/page.php
4 templates/template11/template.htm
96 modules/template/model.php
166 modules/core/page.php
329 templates/template1/template.htm
96 modules/template/model.php
166 modules/core/page.php
511 modules/core/command/controller/default.php
109 modules/core/command/controller/hostcms5/default.php
195 modules/core/router/route.php
239 index.php