Continuing the discussion from What cool badge queries have you come up with? : [画像] [Superseded] What cool badge queries have you come up with? So there are lots of potential badges that we can come up with using SQL queries. I thought I’d start a topic for people to share some of the queries a…

I’m not sure if you’re interested in modifying the query, but from my few tests on localhost I’ve found using the badge_posts VIEW ran faster than using the posts table. * it doesn’t show in the Data Explorer because it isn’t a table CREATE VIEW badge_posts AS SELECT p.id, p.user_id, p.to…

When would this badge be awarded? Is there a time limit after the topic is created before it considers who got the most likes? I wouldn’t want it to award to someone that got one like on the first post in a topic.

I believe with Run revocation query daily enabled then this badge could be rewarded and redacted accordingly. So if someone has the most like one day, it could change the next. I supposed you could do a time limit with post.created_at or another option could be to wait until X amount of likes have b…

Make a badge for the answer with the most likes in a topic!

Community Building Data & reporting

stevenpslade (Steven Slade) 2016 年 3 月 28 日午後 5:04 3

Thanks for letting me know! Good tip on the badge_posts view.

トピック		返信	表示
What query to award a badge for liking or replying to a particular topic? Data & reporting sql-triggered-badge	1	680	2023 年 5 月 23 日
Likes in a short time/in one topic Data & reporting sql-triggered-badge	2	193	2015 年 2 月 15 日
Badge for popular topic Data & reporting sql-triggered-badge	5	411	2024 年 6 月 1 日
Request for badge: Nice/Good/Great Topic Feature badges	3	1179	2014 年 9 月 11 日
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1901	2016 年 6 月 24 日

Make a badge for the answer with the most likes in a topic!

関連トピック