Квадроциклы
Экипировка
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 MariaDB server version for the right syntax to use near ') OR `shop_items`.`id` IN (541315) ) AND `shop_items`.`id` <> shop_items.modifi' at line 11. Query: SELECT DISTINCT SQL_CALC_FOUND_ROWS `shop_items`.*, `used_items`.`value` AS `used_items_value` FROM `shop_items` INNER JOIN `shop_warehouse_items` AS `swi` ON `swi`.`shop_item_id` = `shop_items`.`id` INNER JOIN `shop_warehouses` AS `sw` ON `sw`.`id` = `swi`.`shop_warehouse_id` AND `sw`.`shop_id` = shop_items.shop_id LEFT OUTER JOIN `shop_warehouse_items` AS `itemsswi` ON `itemsswi`.`shop_item_id` = `shop_items`.`id` AND `itemsswi`.`shop_warehouse_id` IN (4, 5, 12, 6, 11, 15, 16, 17) LEFT OUTER JOIN `property_value_ints` AS `archived_items` ON `archived_items`.`entity_id` = `shop_items`.`id` AND `archived_items`.`property_id` = 1715 LEFT OUTER JOIN `property_value_ints` AS `used_items` ON `used_items`.`entity_id` = `shop_items`.`id` AND `used_items`.`property_id` = 741 WHERE `shop_items`.`shop_id` = '3' AND ( `shop_items`.`start_datetime` < '2020-06-07 05:09:33' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2020-06-07 05:09:33' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`image_small` != '' AND `swi`.`count` > 0 AND COALESCE(archived_items.value, 0) = 0 AND ( `shop_items`.`shop_group_id` IN () OR `shop_items`.`id` IN (541315) ) AND `shop_items`.`id` <> shop_items.modification_id AND `shop_items`.`active` = 1 AND `shop_items`.`deleted` = 0 GROUP BY `shop_items`.`id` HAVING CASE WHEN used_items.value = 10843 THEN SUM(COALESCE(itemsswi.count, 0)) ELSE 1 END <> 0 AND `shop_items`.`deleted` = 0 ORDER BY RAND() ASC LIMIT 4 OFFSET 0
36 modules/core/exception.php
597 modules/core/database/pdo.php
80 modules/core/querybuilder/statement.php
518 modules/core/orm.php
531 modules/core/entity.php
1013 modules/shop/controller/show.php
680 vendor/mikeborisov/hostcms-modules/src/utils/module/shop/controller/show.php
1934 libs/modules/moto/module/shop/controller/show.php
727 libs/modules/moto/module/shop/controller/show.php
101 hostcmsfiles/lib/lib_52/lib_52.php
278 modules/lib/model.php
166 modules/core/page.php
2 templates/template64/template.htm
103 modules/template/model.php
166 modules/core/page.php
314 templates/template62/template.htm
103 modules/template/model.php
166 modules/core/page.php
545 modules/core/command/controller/default.php
195 modules/core/router/route.php
240 index.php