result = Repo.one!(from cl in Client,
                       inner_join: u in assoc(cl, :user),
                       inner_join: co in assoc(u, :company),
                       inner_join: a in assoc(u, :account),
                       inner_join: va in assoc(u, :video_address),
                       inner_join: d in assoc(va, :domain),
                       inner_join: oc in assoc(d, :opensips_cluster),
                       inner_join: pvmr in assoc(u, :pexip_vmr),
                       inner_join: pvmr_va in assoc(pvmr, :video_address),
                       inner_join: pvmr_d in assoc(pvmr_va, :domain),
                       where: u.id == ^user_id,
                       where: pvmr.client_internal == true,
                       where: a.type == "client",
                       select: %{
                                 sip:    %{
                                           username: a.username,
                                           password: a.password,
                                           uri: va.username,
                                           domain: d.domain,
                                           proxy: oc.proxy_url
                                         },
                                 internalVmr: %{ pin: pvmr.pin,
                                                 uri: a.username,
                                                 domain: d.domain,
                                                 webrtcDomain: pvmr_d.webrtc_gateway
                                               },
                                 seeviaToken: fragment("coalesce(?,'default-token')",co.search_token),
                                 seeviaTokenGeneric: fragment("(? IS NULL) from ?", co.search_token, co)
                               }
                       )