Hi all,

I'm trying to delete duplicates from _Subscribers but I'm getting some discordance problems on the results. I'm using the following query in order to find email duplicates:

SELECT SubscriberKey,emailaddress, status

FROM _subscribers

WHERE emailaddress IN (

                        SELECT emailaddress

                        FROM _subscribers

                        GROUP BY emailaddress

                        HAVING COUNT(*)>1

                      )

Then, I import the results to a list and delete them. The problem is that if I search them through the search panel on All Subscribers it doesn't show me any results (the register was deleted indeed), but if I run the query again, it shows me almost the same results as before, like if it didn’t delete anything. Do I just have to wait before the registers are deleted from an internal table or something like it?

Thnx and good day,