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 …

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) 28.Март.2016 17:04:41 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	23.05.2023
Likes in a short time/in one topic Data & reporting sql-triggered-badge	2	193	15.02.2015
Badge for popular topic Data & reporting sql-triggered-badge	5	411	01.06.2024
Request for badge: Nice/Good/Great Topic Feature badges	3	1179	11.09.2014
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1901	24.06.2016

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

Связанные темы