# Data explorer challenge: Generate list of members by location

**URL:** <https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [12 Enero, 2017 15:11 UTC](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648 "2017-01-12T15:11:45Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![ToddZ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/toddz/32/328350_2.png) [@ToddZ](https://meta.discourse.org/u/ToddZ)\
**Post date:** [10 Octubre, 2025 19:53 UTC](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648/8 "2025-10-10T19:53:37Z")

</div>

Tuve la ocasión de ampliar un poco la consulta de Don para producir una lista de usuarios, ubicaciones y correos electrónicos de todos los usuarios con una ubicación introducida. Podría ser interesante o útil en algunos casos:

```sql
SELECT u.username, u.locale, up.location, ue.email
    FROM users u
    LEFT JOIN user_profiles up ON u.id = up.user_id
    LEFT JOIN user_emails ue ON u.id = ue.user_id
    -- comentar la cláusula WHERE para obtener la lista completa de usuarios
    WHERE up.location <> ''
    ORDER BY up.location

```

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-challenge-generate-list-of-members-by-location/55648)._