Каталог домов

Главная | Каталог домов
Тип строения
Этажи
Стены
Площадь, м2
от:  
до: 
Цена , руб.
от:
 до: 
Exception: Query error 23000: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'shortcut_id' in where clause is ambiguous. Query: SELECT SQL_CALC_FOUND_ROWS `shop_items`.* FROM `shop_items` INNER JOIN `shop_numbers_restore_items` ON `shop_items`.`id` = `shop_numbers_restore_items`.`n` LEFT OUTER JOIN `shop_taxes` ON `shop_taxes`.`id` = `shop_items`.`shop_tax_id` LEFT OUTER JOIN `shop_groups` AS `sg` ON `sg`.`id` = `shop_items`.`shop_group_id` WHERE `shortcut_id` = 0 AND `shop_items`.`active` = 1 AND `shop_items`.`shortcut_id` = 0 AND ( `sg`.`active` = 1 AND `sg`.`deleted` = 0 AND `sg`.`siteuser_group_id` IN (0, -1) OR `sg`.`id` IS NULL ) AND `shop_items`.`deleted` = 0 ORDER BY shop_items.sorting ASC, `shop_items`.`name` ASC LIMIT 20 OFFSET 80
modules/core/database/pdo.php:675 Core_Exception->__construct
modules/core/querybuilder/statement.php:87 Core_DataBase_Pdo->query
modules/core/orm.php:536 Core_QueryBuilder_Statement->execute
modules/core/entity.php:589 Core_ORM->findAll
modules/shop/controller/show.php:1190 Core_Entity->findAll
modules/extendedfilters/shop.php:3829 Shop_Controller_Show->show
hostcmsfiles/lib/lib_153/lib_153.php:183 Extendedfilters_Shop->show
modules/lib/model.php:284 include
modules/core/page.php:166 Lib_Model->execute
templates/template47/template.htm:126 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
templates/template43/template.htm:49 Core_Page->execute
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:594 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:237 Core_Router_Route->execute