user = Repo.one(from u in User,
                    inner_join: va in assoc(u, :video_address),
                    inner_join: va_d in assoc(va, :domain),
                    inner_join: pvmr in assoc(u, :pexip_vmr),
                    inner_join: pvmr_va in assoc(pvmr, :video_address),
                    inner_join: pvmr_va_d in assoc(pvmr_va, :domain),

                    where: u.id == ^user.id,
                    select: %{
                      username: u.username,
                      password: "hidden, put info about pin reset",
                      videoAddress: "#{va.username}@#{va_d.domain}"
                    })