# badges for reading! [image] [image] [image] SELECT pt.user_id, count(*) c, CURRENT_DATE as granted_at FROM post_timings pt WHERE :backfill GROUP BY pt.user_id HAVING count(*) >= pow(3, 9) AND count(*) < pow(3, 10) /* Change the 9 and 10 (x and x+1) for the different badges */ ORDER BY c DESC …

Badges for reading [ ⚠ intensive]

PJH (PJH) August 7, 2015, 11:11am 6

We’ve already sorta covered that - start reading near this post:

1 Like