blob: 96a8cc4fa235972414c46ee95c67786a8f50d1e9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
select
ev.email_validation_public_id
, i.identity_public_id
, e.address
, ev.attempts
, ev.code
, ev.is_validated
, ev.created_at
, ev.expires_at
, ev.revoked_at
from secd.email_validation ev
join secd.identity_email ie using (identity_email_id)
join secd.email e using (email_id)
join secd.identity i using (identity_id)
where (($1 is null) or (email_validation_public_id = $1))
and (($2 is null) or (code = $2));
--
|
