Continuing the discussion from What cool badge queries have you come up with? : [immagine] [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 que…

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 Marzo 2016, 5:04pm 3

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

Argomento		Risposte	Visualizzazioni
What query to award a badge for liking or replying to a particular topic? Data & reporting sql-triggered-badge	1	680	Maggio 23, 2023
Likes in a short time/in one topic Data & reporting sql-triggered-badge	2	193	Febbraio 15, 2015
Badge for popular topic Data & reporting sql-triggered-badge	5	411	Giugno 1, 2024
Request for badge: Nice/Good/Great Topic Feature badges	3	1179	Settembre 11, 2014
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1901	Giugno 24, 2016

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

Argomenti correlati