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 badge. is there any way to check this count?

You can’t but here is your attendance on meta [image] I used the Data Explorer Plugin. Not sure if the query is built-in, so here it is -- [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

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

Product Support

TheBestPessimist October 25, 2018, 12:33pm 3

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

Gosh darn it! :flips_table:

Topic		Replies	Views
See how many days straight we've been on the forums Feature	4	863	August 15, 2023
Does Discourse track consecutive days active? Data & reporting badges , sql-query	3	223	January 30, 2025
How do I check a badge's status midway to it being awarded? Product Support	2	1421	July 31, 2019
Fake aficionado Bug	9	1094	October 25, 2018
'Seen in last X days' badge? Data & reporting sql-triggered-badge	12	388	August 26, 2016

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

Related topics