1 files changed, 8 insertions, 6 deletions
diff --git a/crates/secd/store/sqlite/sql/find_identity.sql b/crates/secd/store/sqlite/sql/find_identity.sql
index bd1654d..f94e7b1 100644
--- a/crates/secd/store/sqlite/sql/find_identity.sql
+++ b/crates/secd/store/sqlite/sql/find_identity.sql
@@ -1,9 +1,11 @@
 select
-        identity_public_id,
-        data,
-        i.created_at
+        identity_public_id
+        , data
+        , i.created_at
+        , i.deleted_at
 from identity       i
-join identity_email ie using (identity_id)
-join email          e  using (email_id)
+join identity_email_validation iev using (identity_id)
+join email_validation          ev  using (email_validation_id)
+join email                     e   using (email_id)
 where ((?1 is null) or (i.identity_public_id = ?1))
-and   ((?2 is null) or (e.address = ?2))
+and   ((?2 is null) or (e.address = ?2));