# Ottenere (Giorni Visitati) nel report elenco utenti CSV

**URL:** <https://meta.discourse.org/t/getting-days-visited-in-csv-user-list-report/140079>\
**Category:** Feature\
**Created:** [29 Gennaio 2020, 4:11pm UTC](https://meta.discourse.org/t/getting-days-visited-in-csv-user-list-report/140079 "2020-01-29T16:11:36Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![YaserAlnajjar](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/yaseralnajjar/32/100729_2.png) [@YaserAlnajjar](https://meta.discourse.org/u/YaserAlnajjar)\
**Post date:** [30 Gennaio 2020, 5:30pm UTC](https://meta.discourse.org/t/getting-days-visited-in-csv-user-list-report/140079/7 "2020-01-30T17:30:18Z")

</div>

Ho scritto la query necessaria per questo:

```plaintext
SELECT
    u.username_lower AS "username",
    stats.days_visited
FROM users u
LEFT JOIN user_stats stats ON stats.user_id = u.id
ORDER BY u.id

```

Tuttavia, tali dati sono effettivamente utili nel rapporto sulla lista degli utenti per ottenere alcune informazioni.

Grazie @Mittineague 🌹

---

_[View the full topic](https://meta.discourse.org/t/getting-days-visited-in-csv-user-list-report/140079)._