SELECT DISTINCT concat(E.csnev,E.idegen,' ',E.knev) as linkszoveg,'' as megj, E.id as linkid FROM rel_data_szerepek K, key_emberek E WHERE K.szinesz_id=E.id AND E.csnev>='o' AND E.csnev<'s' 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