# Novo usuário tem vários dias relatados como "Dias Visitados"?

**URL:** <https://meta.discourse.org/t/new-user-has-several-days-reported-as-days-visited/251518>\
**Category:** UX\
**Created:** [Janeiro 12, 2023, 6:07am UTC](https://meta.discourse.org/t/new-user-has-several-days-reported-as-days-visited/251518 "2023-01-12T06:07:54Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [Janeiro 19, 2023, 11:18am UTC](https://meta.discourse.org/t/new-user-has-several-days-reported-as-days-visited/251518/5 "2023-01-19T11:18:04Z")

</div>

> [@kgrier](#):
>
> Se houver uma consulta do Explorador de Dados que ajude aqui, por favor, me avise, e eu a executarei e relatarei.

Não encontrei uma existente, mas talvez algo como isto:

```sql

SELECT u.id AS user_id,
       u.created_at,
       u.approved_at,
       us.days_visited
FROM users u
JOIN user_stats us ON u.id = us.user_id
WHERE u.approved_at IS NOT NULL
ORDER BY u.created_at DESC

```

Ou uma com um pouco mais para torná-la mais legível:

```sql

SELECT u.id AS user_id,
       CONCAT(u.created_at::date, ' at ', to_char(u.created_at, 'HH:MM')) "user_created",
       CONCAT(u.approved_at::date, ' at ', to_char(u.approved_at, 'HH:MM')) "user_approved",
       us.days_visited
FROM users u
JOIN user_stats us ON u.id = us.user_id
WHERE u.approved_at IS NOT NULL
ORDER BY u.created_at DESC
   

```

---

_[View the full topic](https://meta.discourse.org/t/new-user-has-several-days-reported-as-days-visited/251518)._