select oauth_validation_public_id
       , i.identity_public_id
       , ov.access_token
       , ov.raw_response
       , ov.created_at
       , ov.validated_at
       , iov.revoked_at
       , iov.deleted_at
       , op.name          as oauth_provider_name
       , op.flow          as oauth_provider_flow
       , op.base_url      as oauth_provider_base_url
       , op.response_type as oauth_provider_response_type
       , op.default_scope as oauth_provider_default_scope
       , op.client_id     as oauth_provider_client_id
       , op.client_secret as oauth_provider_client_secret
       , op.redirect_url  as oauth_provider_redirect_url
       , op.created_at    as oauth_provider_created_at
       , op.deleted_at    as oauth_provider_deleted_at
from secd.oauth_validation               ov
join secd.oauth_provider                 op  using(oauth_provider_id)
left join secd.identity_oauth_validation iov using(oauth_validation_id)
left join secd.identity                  i   using(identity_id)
where oauth_validation_public_id = $1;
