г.Тюмень, Олимпийская д.6 (ТЦ «Метелица»-3 этаж)
Заказать звонок
Общество с ограниченной ответственностью Фейерверк-Центр Мы работаем, чтобы вы красиво отдыхали +7-3452 33-68-71, +7-3452 90-53-77
+7-922-477-30-07
Exception: Query error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN shop_item_discount_table ON (shop_items_catalog_table.shop_items_catal' at line 5. 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`.`rambler_pokupki` AS `shop_items_catalog_rambler_pokupki_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_discount_table.shop_discount_percent, IF (shop_items_catalog_table.shop_currency_id = 1, IF (shop_discount_table.shop_discount_percent, shop_items_catalog_price * (100 - shop_discount_table.shop_discount_percent) * 1 / 100, shop_items_catalog_table.shop_items_catalog_price * 1), shop_items_catalog_price) AS item_price_absolute FROM `shop_items`, LEFT JOIN shop_item_discount_table ON (shop_items_catalog_table.shop_items_catalog_item_id = shop_item_discount_table.shop_items_catalog_item_id) LEFT JOIN shop_discount_table ON (shop_item_discount_table.shop_discount_id = shop_discount_table.shop_discount_id AND (shop_discount_table.shop_discount_to >= '2021-04-13 17:25:02' OR shop_discount_table.shop_discount_to ='0000-00-00 00:00:00') AND shop_discount_table.shop_discount_from <= '2021-04-13 17:25:02') 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` = 783 AND ( `shop_items`.`end_datetime` >= '2021-04-13 17:25:02' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`start_datetime` <= '2021-04-13 17:25:02' AND `shop_items`.`modification_id` = 0 HAVING 1 ORDER BY `item_price_absolute` ASC LIMIT 30 OFFSET 0
29 modules/core/exception.php
635 modules/core/database/mysql.php
62 modules/core/querybuilder/statement.php
4831 modules/hostcms5/shop/shop.class.php
14924 modules/hostcms5/shop/shop.class.php
17522 modules/hostcms5/shop/shop.class.php
828 hostcmsfiles/lib/lib_6/lib_6.php
209 modules/lib/model.php
100 modules/core/page.php
1048 modules/hostcms5/Kernel/Kernel.class.php
121 templates/template10/template.htm
73 modules/template/model.php
100 modules/core/page.php
363 modules/core/command/controller/default.php
97 modules/core/command/controller/hostcms5/default.php
171 modules/core/router/route.php
205 index.php