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