# Phantom aanmeldingen (twee gebruikers met hetzelfde account na migratie)

**URL:** <https://meta.discourse.org/t/phantom-signups-two-users-with-the-same-account-after-migration/168631>\
**Category:** Product Support\
**Created:** [29 oktober 2020 om 13:06 UTC](https://meta.discourse.org/t/phantom-signups-two-users-with-the-same-account-after-migration/168631 "2020-10-29T13:06:04Z")\
**Posts on this page:** 1\
**Showing post:** 14

<div class="post-metadata">

**Author:** ![Roman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/roman/32/157504_2.png) [@Roman](https://meta.discourse.org/u/Roman)\
**Post date:** [2 november 2020 om 10:49 UTC](https://meta.discourse.org/t/phantom-signups-two-users-with-the-same-account-after-migration/168631/14 "2020-11-02T10:49:03Z")

</div>

Hi @Paul_King

I suspect a migration I added around the same time as the commit you mentioned caused this issue, making some unapproved users look like they’re in the review queue and causing weird notifications.

Can you run this query on the [data explorer](https://meta.discourse.org/t/32566?silent=true) to confirm that this is the case?

```SQL
SELECT COUNT(*)
FROM users
INNER JOIN reviewables r ON r.target_id = users.id
WHERE r.type = 'User' AND r.status = 1 AND users.approved = FALSE

```

---

_[View the full topic](https://meta.discourse.org/t/phantom-signups-two-users-with-the-same-account-after-migration/168631)._
