Расчет цены с доставкой

Коричнвеый камень

Выбор параметров
Интересные статьи
==SELECT SQL_CALC_FOUND_ROWS `1` AS `shop_items`.`id`, MIN(price) AS `min`, MAX(price) AS `max` FROM `shop_items` 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` = '3' AND ( `shop_items`.`start_datetime` < '2019-05-25 10:58:12' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2019-05-25 10:58:12' 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` = '69' AND `property_value_strings`.`value` = 'Коричнвеый' ) AND `shop_items`.`active` = 1 AND ( `shop_items`.`shop_group_id` = 0 AND `shop_items`.`modification_id` = 0 ) AND `shop_items`.`deleted` = 0 GROUP BY `shop_items`.`id` ORDER BY `shop_items`.`name` ASC LIMIT 18 OFFSET 0==Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 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 '.`id`, MIN(price) AS `min`, MAX(price) AS `max` FROM `shop_items` LEFT OUTER J' at line 3. Query: SELECT SQL_CALC_FOUND_ROWS `1` AS `shop_items`.`id`, MIN(price) AS `min`, MAX(price) AS `max` FROM `shop_items` 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` = '3' AND ( `shop_items`.`start_datetime` < '2019-05-25 10:58:12' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2019-05-25 10:58:12' 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` = '69' AND `property_value_strings`.`value` = 'Коричнвеый' ) AND `shop_items`.`active` = 1 AND ( `shop_items`.`shop_group_id` = 0 AND `shop_items`.`modification_id` = 0 ) AND `shop_items`.`deleted` = 0 GROUP BY `shop_items`.`id` ORDER BY `shop_items`.`name` ASC LIMIT 18 OFFSET 0
36 modules/core/exception.php
598 modules/core/database/pdo.php
61 modules/core/querybuilder/statement.php
570 hostcmsfiles/lib/lib_6/lib_6.php
271 modules/lib/model.php
166 modules/core/page.php
399 templates/template20/template.htm
96 modules/template/model.php
166 modules/core/page.php
496 modules/core/command/controller/default.php
194 modules/core/router/route.php
239 index.php