SELECT DISTINCT felhasznalonev
      ,idmunkatars
      ,irhato
  FROM (SELECT DISTINCT i.idugylet       AS id
                       ,m.felhasznalonev
                       ,m.id             AS idmunkatars
                       ,aj.irhato
                       ,aj.szerepkor
          FROM munkatars m
          JOIN (SELECT DISTINCT idmunkatars
                              ,idszolgaltatas
                              ,irhato
                              ,szerepkor
                 FROM ta_munkatars_jog
                WHERE SYSDATE BETWEEN valid_from AND valid_to) aj
            ON (m.id = aj.idmunkatars)
          JOIN ta_igenyles i
            ON (i.idszolgaltatas = aj.idszolgaltatas)
        UNION ALL
        SELECT i.idugylet       AS id
              ,m.felhasznalonev
              ,m.id             AS idmunkatars
              ,1                AS irhato
              ,NULL
          FROM munkatars m
          JOIN mxmunkatarscsoport mx
            ON (m.id = mx.idmunkatarslista)
          JOIN mtcsoport admin
            ON (admin.id = mx.idmunkatarscsoportlista)
          JOIN funkciojogosultsag f
            ON (f.idmtcsoport = admin.id AND
               komponens = 'IgenylesKorlatlanKereses'), ta_igenyles i
        UNION ALL
        SELECT u.id
              ,m.felhasznalonev
              ,m.id             AS idmunkatars
              ,1                AS irhato
              ,NULL
          FROM ugylet u
          JOIN ta_szocialisdiagnozis szd
            ON szd.idugylet = u.id
          JOIN munkatars m
            ON m.id = u.idpalyazo
        UNION ALL
        SELECT szd.idugylet     AS id
              ,m.felhasznalonev
              ,m.id             AS idmunkatars
              ,1                AS irhato
              ,NULL
          FROM munkatars m
          JOIN mxmunkatarscsoport mx
            ON (m.id = mx.idmunkatarslista)
          JOIN mtcsoport admin
            ON (admin.id = mx.idmunkatarscsoportlista)
          JOIN funkciojogosultsag f
            ON (f.idmtcsoport = admin.id AND
               komponens = 'DiagnozisKorlatlanSzerkeszt'),
         ta_szocialisdiagnozis szd)