Badge Discussion: Like Ratios + Spending Likes

[alefattorini (Alessio Fattorini)]

Yes, I could btw I just used some of these queries

What cool badge queries have you come up with?

##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 I highly recommend not running this query more frequently than daily - our forum’s only been running for 10 months and the table referenced here has 11,949,028 rows making this query rather time int…