select identity_email_validation_id from secd.email_validation where email_validation_public_id = $1::uuid -- select identity_public_id , data , i.created_at from secd.identity i left join secd.identity_email ie using (identity_id) where ie.identity_email_validation_id = $1;