SELECT DISTINCT concat(E.csnev,E.idegen,' ',E.knev) as linkszoveg,'' as megj, E.id as linkid FROM key_kritikak K, key_emberek E WHERE K.ember_id=E.id AND E.csnev>='h' AND E.csnev<'l' AND E.b_public=1 ORDER BY concat(E.csnev,E.knev) asc
Expression #1 of ORDER BY clause is not in SELECT list, references column 'hamlet_ro.E.csnev' which is not in SELECT list; this is incompatible with DISTINCT