Вариант - производство мебели в Йошкар-Оле
г. Йошкар-Ола, ул. Чапаева, 73
Заказать обратный звонок
Undefined error: Function ereg() is deprecated в файле /var/www/user706/data/www/variant-12.ru/hostcmsfiles/lib/lib_6/lib_6.php (строка 252)Exception: Query error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LEFT JOIN shop_item_discounts ON (shop_items.id = shop_item_discounts.id) LEFT J' 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_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 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 >= '2019-11-17 07:25:21' OR shop_discounts.end_datetime ='0000-00-00 00:00:00') AND shop_discounts.start_datetime <= '2019-11-17 07:25:21') 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` = 602 AND ( `shop_items`.`end_datetime` >= '2019-11-17 07:25:21' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`start_datetime` <= '2019-11-17 07:25:21' AND `shop_items`.`modification_id` = 0 HAVING 1 ORDER BY `item_price_absolute` DESC 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
4 templates/template10/template.htm
73 modules/template/model.php
100 modules/core/page.php
194 templates/template1/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