# HG changeset patch
# User bsw
# Date 1533216803 -7200
# Node ID b62de5ebabfa574542498ff8985d104c6c575d9e
# Parent  a0d6c347ce7fbd11869caa628712346bd4a8ee7e
Do not count manual verification requests as other reasons

diff -r a0d6c347ce7f -r b62de5ebabfa app/main/registration_admin/index.lua
--- a/app/main/registration_admin/index.lua	Wed Aug 01 18:05:18 2018 +0200
+++ b/app/main/registration_admin/index.lua	Thu Aug 02 15:33:23 2018 +0200
@@ -102,6 +102,8 @@
             local count = Verification:new_selector()
               :add_where("verified_member_id ISNULL")
               :add_where("denied ISNULL")
+              :add_where("not comment ilike '%User requested manual verification (during step 1)'")
+              :add_where("not comment ilike '%User requested manual verification (during step 2)'")
               :add_where("not comment ilike '%User requested manual verification'")
               :add_where("not comment ilike '% sent'")
               :add_where("not comment similar to '%fiscal code does not match[^/]*'")