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

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) Março 28, 2016, 5:04pm 3

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

Tópico		Respostas	Visualizações
What query to award a badge for liking or replying to a particular topic? Data & reporting sql-triggered-badge	1	680	23 de Maio de 2023
Likes in a short time/in one topic Data & reporting sql-triggered-badge	2	193	15 de Fevereiro de 2015
Badge for popular topic Data & reporting sql-triggered-badge	5	411	1 de Junho de 2024
Request for badge: Nice/Good/Great Topic Feature badges	3	1179	11 de Setembro de 2014
Badge ideas for Topic Voting Feature badges , topic-voting , sql-triggered-badge	0	1901	24 de Junho de 2016

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

Tópicos relacionados