# How can I see how many days in a row I visited the forum?

**URL:** https://meta.discourse.org/t/how-can-i-see-how-many-days-in-a-row-i-visited-the-forum/100441
**Category:** Support
**Created:** [10월 25, 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:** 1
**Showing post:** 2

<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: [10월 25, 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

```

---

_[View the full topic](https://meta.discourse.org/t/how-can-i-see-how-many-days-in-a-row-i-visited-the-forum/100441)._