интернет-магазин

косметологического оборудования

Телефоны:

8 800 500-74-36
8 495 226-54-55
Каталог
Поиск:
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 >= '2018-04-22 04:47:59' or shop_discounts.end_datetime ='0000-00-00 00:00:00') and shop_discounts.start_datetime <= '2018-04-22 04:47:59') WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`shop_id` = 3 AND `shop_items`.`active` = 1 AND `shop_items`.`shop_group_id` = 760 AND ( `shop_items`.`end_datetime` >= '2018-04-22 04:47:59' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`start_datetime` <= '2018-04-22 04:47:59' AND `shop_items`.`modification_id` = 0 HAVING 1 ORDER BY `item_price_absolute` DESC LIMIT 10 OFFSET 0
35 modules/core/exception.php
636 modules/core/database/mysql.php
60 modules/core/querybuilder/statement.php
4872 modules/hostcms5/shop/shop.class.php
14958 modules/hostcms5/shop/shop.class.php
17561 modules/hostcms5/shop/shop.class.php
854 hostcmsfiles/lib/lib_6/lib_6.php
271 modules/lib/model.php
138 modules/core/page.php
93 templates/template10/template.htm
86 modules/template/model.php
138 modules/core/page.php
195 templates/template7/template.htm
86 modules/template/model.php
138 modules/core/page.php
417 modules/core/command/controller/default.php
108 modules/core/command/controller/hostcms5/default.php
190 modules/core/router/route.php
242 index.php