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>='a' AND E.csnev<'d' AND E.b_public=1 AND K.tevekenyseg_id='104' 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