Unknown column 'asp_category.TITLE' in 'order clause'
SELECT asp_category.ASP_CATEGORY_ID, asp_category.TITLE_EN AS TITLE, count(asp_category_assignment.KA_ID) AS ITEMS FROM asp_category LEFT JOIN asp_category_assignment ON ((asp_category_assignment.ASP_CATEGORY_ID=asp_category.ASP_CATEGORY_ID) OR (asp_category_assignment.ASP_CATEGORY_ID=asp_category.HIERARCHY)) WHERE asp_category.USER_ID='' AND asp_category.HIERARCHY=0 GROUP BY asp_category.ASP_CATEGORY_ID ORDER BY asp_category.TITLE