# How to handle multiple account?

**URL:** <https://meta.discourse.org/t/how-to-handle-multiple-account/15244>\
**Category:** Feature\
**Created:** [2 במאי,‏ 2014,‏ 1:19pm UTC](https://meta.discourse.org/t/how-to-handle-multiple-account/15244 "2014-05-02T13:19:02Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)\
**Post date:** [2 בדצמבר,‏ 2017,‏ 3:01am UTC](https://meta.discourse.org/t/how-to-handle-multiple-account/15244/11 "2017-12-02T03:01:33Z")

</div>

Running this as a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query will give a list of all users with shared registration\_ip\_addresses. It will exclude users created through the API, or SSO, where the registration\_ip\_address is NULL.

```plaintext
WITH users_per_ip AS (
SELECT
count(1) AS user_count,
u.registration_ip_address AS ip
FROM users u
GROUP BY ip
)

SELECT
u.id AS user_id,
upi.ip AS ip_address
FROM users_per_ip upi
JOIN users u
ON u.registration_ip_address = upi.ip
WHERE upi.user_count > 1
ORDER BY upi.ip, u.username

```

---

_[View the full topic](https://meta.discourse.org/t/how-to-handle-multiple-account/15244)._
