# Como posso ver quantos dias seguidos visitei o fórum?

**URL:** https://meta.discourse.org/t/how-can-i-see-how-many-days-in-a-row-i-visited-the-forum/100441
**Category:** Support
**Created:** [25 Outubro , 2018 10:13 UTC](https://meta.discourse.org/t/how-can-i-see-how-many-days-in-a-row-i-visited-the-forum/100441 "2018-10-25T10:13:22Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![TheBestPessimist](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thebestpessimist/32/247704_2.png) [@TheBestPessimist](https://meta.discourse.org/u/TheBestPessimist)
#### Post date: [25 Outubro , 2018 10:13 UTC](https://meta.discourse.org/t/how-can-i-see-how-many-days-in-a-row-i-visited-the-forum/100441/1 "2018-10-25T10:13:22Z")

</div>

I am pretty sure i have visited meta (and a few more discourse forums) for more than 100 _ **consecutive** _ days and still didn’t get the [aficionado](https://forum.duplicacy.com/badges/46/aficionado) badge.  
is there any way to check this count?

---

<div class="post-metadata">

### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [25 Outubro , 2018 12:21 UTC](https://meta.discourse.org/t/how-can-i-see-how-many-days-in-a-row-i-visited-the-forum/100441/2 "2018-10-25T12:21:34Z")

</div>

You can’t but here is your attendance on meta

 ![image](https://global.discourse-cdn.com/meta/original/3X/b/e/bebfd0d3a92165eb42f53dbe97cf5d20d4a53b96.jpeg)

I used the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) Plugin. Not sure if the query is built-in, so here it is

```sql
-- [params]
-- user_list :users

WITH StartingPoints AS (
  SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum
  FROM user_visits AS A
  WHERE NOT EXISTS (
     SELECT 1
     FROM user_visits AS B
     WHERE B.visited_at = A.visited_at - INTERVAL '1 day' AND
     B.user_id = A.user_id
  ) AND user_id IN (:users)
),
EndingPoints AS (
  SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum
  FROM user_visits AS A
  WHERE NOT EXISTS (
     SELECT 1
     FROM user_visits AS B
     WHERE B.visited_at = A.visited_at + INTERVAL '1 day' AND
     B.user_id = A.user_id
  ) AND user_id IN (:users)
)
SELECT u.username, S.visited_at AS start_range, E.visited_at AS end_range, (E.visited_at - S.visited_at + 1) AS Days
FROM StartingPoints AS S
JOIN EndingPoints AS E ON E.rownum = S.rownum
JOIN users u ON u.id=S.user_id AND
u.id IN (:users)
ORDER BY u.id ASC, S.visited_at DESC

```

---

<div class="post-metadata">

### Author: ![TheBestPessimist](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thebestpessimist/32/247704_2.png) [@TheBestPessimist](https://meta.discourse.org/u/TheBestPessimist)
#### Post date: [25 Outubro , 2018 12:33 UTC](https://meta.discourse.org/t/how-can-i-see-how-many-days-in-a-row-i-visited-the-forum/100441/3 "2018-10-25T12:33:37Z")

</div>

So basically i missed a day for example on 09 august.

Gosh darn it! :flips\_table:

---

<div class="post-metadata">

### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [25 Outubro , 2018 12:39 UTC](https://meta.discourse.org/t/how-can-i-see-how-many-days-in-a-row-i-visited-the-forum/100441/4 "2018-10-25T12:39:42Z")

</div>