SELECT DISTINCT concat(E.csnev,E.idegen,' ',E.knev) as linkszoveg,'' as megj, E.id as linkid FROM rel_ember_darab K, key_emberek E WHERE K.ember_id=E.id AND E.csnev>='l' AND E.csnev<'o' AND E.b_public=1 AND K.tevekenyseg_id='78' 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