Неперехваченное исключение

Ошибка (databaseException): Expression #1 of ORDER BY clause is not in SELECT list, references column 'ee21_old.oc_434_lj.int_val' which is not in SELECT list; this is incompatible with DISTINCT in query: SELECT DISTINCT SQL_CALC_FOUND_ROWS h.id as id, h.rel as pid
FROM cms3_hierarchy h, cms3_object_types t, cms3_permissions p, cms3_hierarchy_relations hr, cms3_objects o
LEFT JOIN cms3_object_content oc_434_lj ON oc_434_lj.obj_id=o.id AND oc_434_lj.field_id = '434'
WHERE o.type_id IN (139) AND t.id = o.type_id AND h.lang_id = '1' AND h.is_deleted = '0' AND h.is_active = '1' AND (p.rel_id = h.id AND p.level & 1 AND p.owner_id IN(13)) AND h.id = hr.child_id AND (hr.level <= 6 AND hr.rel_id = '5963') AND h.obj_id = o.id

ORDER BY oc_434_lj.int_val ASC

Показать отладочную информацию

Поддержка пользователей UMI.CMS umi-cms.ru/support