Exception: Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'property_value_ints.value.count' in 'order clause'. Query: SELECT
SQL_CALC_FOUND_ROWS
`shop_items`.*
FROM `shop_items`
LEFT OUTER JOIN `shop_warehouse_items` AS `shop_warehouse_itemsOsnov` ON `shop_warehouse_itemsOsnov`.`shop_item_id` = `shop_items`.`id`
LEFT OUTER JOIN `shop_warehouse_items` AS `shop_warehouse_itemsUdal` ON `shop_warehouse_itemsUdal`.`shop_item_id` = `shop_items`.`id`
LEFT OUTER JOIN `property_value_ints` ON `shop_items`.`id` = `property_value_ints`.`entity_id` AND `property_value_ints`.`property_id` = 1206
INNER JOIN `tmp_shop_items_filter` ON `tmp_shop_items_filter`.`n` = `shop_items`.`id`
WHERE `shop_items`.`shop_id` = '1' AND `shop_warehouse_itemsOsnov`.`shop_warehouse_id` IN (6) AND ( `shop_warehouse_itemsUdal`.`shop_warehouse_id` IN (10) OR `shop_warehouse_itemsUdal`.`shop_warehouse_id` IN (6, 10) ) AND `shop_items`.`deleted` = 0
GROUP BY `shop_items`.`id`
ORDER BY SUM(`shop_warehouse_itemsOsnov`.`count`) DESC, SUM(`property_value_ints.value`.`count`) ASC, SUM(`shop_warehouse_itemsUdal`.`count`) DESC, `shop_items`.`name` ASC
LIMIT 24
OFFSET 6144
modules/core/database/pdo.php:679 Core_Exception->__construct
modules/core/querybuilder/statement.php:86 Core_DataBase_Pdo->query
modules/core/orm.php:551 Core_QueryBuilder_Statement->execute
modules/core/entity.php:620 Core_ORM->findAll
modules/asmp/shop/controller/show.php:1126 Core_Entity->findAll
hostcmsfiles/lib/lib_74/lib_74.php:85 ASMP_Shop_Controller_Show->show
modules/lib/model.php:376 include
modules/core/page.php:178 Lib_Model->execute
templates/template94/template.htm:113 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:178 Template_Model->execute
templates/template1/template.htm:626 Core_Page->execute
modules/template/model.php:107 include
modules/core/page.php:178 Template_Model->execute
modules/core/command/controller/default.php:622 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:379 Core_Router_Route->execute