# Data & reporting **URL:** https://meta.discourse.org/c/community-building/data-reporting/148.md?page=25 [Mais Recente](https://meta.discourse.org/latest.md) · [Categorias](https://meta.discourse.org/categories.md) · [Etiquetas](https://meta.discourse.org/tags.md) **Page:** 26 --- ## [Make a badge for the answer with the most likes in a topic!](https://meta.discourse.org/t/make-a-badge-for-the-answer-with-the-most-likes-in-a-topic/36440)
**Author:** [@stevenpslade](https://meta.discourse.org/u/stevenpslade)\ **Respostas:** 4\ **Última atualização:** [29 Março , 2016 22:39 UTC](https://meta.discourse.org/t/make-a-badge-for-the-answer-with-the-most-likes-in-a-topic/36440 "2016-03-29T22:39:29Z")
Continuing the discussion from What cool badge queries have you come up with?: I wanted to give a badge if a user’s answer had received the most likes in a topic. Here’s what I came up with: SELECT topics.id AS topic,… --- ## [Badges for 'post in specific category' and 'filled in bio fields'](https://meta.discourse.org/t/badges-for-post-in-specific-category-and-filled-in-bio-fields/276732)
**Author:** [@mikechristopher](https://meta.discourse.org/u/mikechristopher)\ **Respostas:** 6\ **Última atualização:** [8 Março , 2016 21:32 UTC](https://meta.discourse.org/t/badges-for-post-in-specific-category-and-filled-in-bio-fields/276732 "2016-03-08T21:32:02Z")
Hi Guys, I have been reading through and been looking for two in particular One to check if you have posted a topic in a particular category - like introductions One to check if you have filled in particular user\_fiel… --- ## ["Personal Page" badge](https://meta.discourse.org/t/personal-page-badge/37721)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **Respostas:** 0\ **Última atualização:** [11 Janeiro , 2016 03:50 UTC](https://meta.discourse.org/t/personal-page-badge/37721 "2016-01-11T03:50:25Z")
I’d like to share a badge that I developed for a contest in forum.kozovod.com. Personal Page badge Created a topic in a particular category Wrote at least 1000 words in the topic (in one or multiple messages) Wrote in … --- ## [SQL Badge Query - Quick Responder!](https://meta.discourse.org/t/sql-badge-query-quick-responder/36399)
**Author:** [@ivanrlio](https://meta.discourse.org/u/ivanrlio)\ **Respostas:** 2\ **Última atualização:** [7 Dezembro , 2015 21:29 UTC](https://meta.discourse.org/t/sql-badge-query-quick-responder/36399 "2015-12-07T21:29:42Z")
Hello again, So I have this query here that’s aimed at giving users that respond to a new question within 4 hours a badge. What I have is: SELECT users.id user\_id, topics.id topic\_id, posts.id post\_id FROM users JOIN … --- ## [SQL Querying in Badges](https://meta.discourse.org/t/sql-querying-in-badges/36336)
**Author:** [@ivanrlio](https://meta.discourse.org/u/ivanrlio)\ **Respostas:** 1\ **Última atualização:** [4 Dezembro , 2015 21:20 UTC](https://meta.discourse.org/t/sql-querying-in-badges/36336 "2015-12-04T21:20:21Z")
Hi guys, So I’m extremely new to Discourse and I think I’ve just successfully written my first badge that assigns a badge to a user if they have received 5-9 likes. It is as follows: SELECT user\_id, users.username use… --- ## [Replied to topics in a certain category, but exclude replies to own topics](https://meta.discourse.org/t/replied-to-topics-in-a-certain-category-but-exclude-replies-to-own-topics/276724)
**Author:** [@nstemp](https://meta.discourse.org/u/nstemp)\ **Respostas:** 2\ **Última atualização:** [28 Outubro , 2015 11:36 UTC](https://meta.discourse.org/t/replied-to-topics-in-a-certain-category-but-exclude-replies-to-own-topics/276724 "2015-10-28T11:36:56Z")
Hello! I want to create a badge for those who help in the forums, so I want to give it to the people who have replied X times to ANY thread inside the category ‘Help’. Of course this has to avoid replies in your own top… --- ## [Badge for replies in a specific category](https://meta.discourse.org/t/badge-for-replies-in-a-specific-category/276730)
**Author:** [@Stephen](https://meta.discourse.org/u/Stephen)\ **Respostas:** 3\ **Última atualização:** [28 Agosto , 2015 12:20 UTC](https://meta.discourse.org/t/badge-for-replies-in-a-specific-category/276730 "2015-08-28T12:20:53Z")
I’m looking for something similar, a badge awarded when replying to posts in a particular category. --- ## [Badge based on link stats?](https://meta.discourse.org/t/badge-based-on-link-stats/29018)
**Author:** [@jesselperry](https://meta.discourse.org/u/jesselperry)\ **Respostas:** 5\ **Última atualização:** [27 Agosto , 2015 16:55 UTC](https://meta.discourse.org/t/badge-based-on-link-stats/29018 "2015-08-27T16:55:25Z")
Would there be any way to run a badge query on number of clicks on a link? I find that users will click a link and it will be really popular, but the topic originator never gets any likes to the post (or far less than th… --- ## [Badge for total posts, and attendence](https://meta.discourse.org/t/badge-for-total-posts-and-attendence/276727)
**Author:** [@alefattorini](https://meta.discourse.org/u/alefattorini)\ **Respostas:** 2\ **Última atualização:** [7 Agosto , 2015 12:41 UTC](https://meta.discourse.org/t/badge-for-total-posts-and-attendence/276727 "2015-08-07T12:41:35Z")
How can I create badges that count totally posts of someone? And a badge for days attendance (not consecutive) Any idea? --- ## [Badges for reading \[ ⚠ intensive\]](https://meta.discourse.org/t/badges-for-reading-intensive/276681)
**Author:** [@PJH](https://meta.discourse.org/u/PJH)\ **Respostas:** 5\ **Última atualização:** [7 Agosto , 2015 11:11 UTC](https://meta.discourse.org/t/badges-for-reading-intensive/276681 "2015-08-07T11:11:00Z")
\#badges for reading! 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 … --- ## [Some common badge queries](https://meta.discourse.org/t/some-common-badge-queries/31859)
**Author:** [@techAPJ](https://meta.discourse.org/u/techAPJ)\ **Respostas:** 0\ **Última atualização:** [7 Agosto , 2015 07:20 UTC](https://meta.discourse.org/t/some-common-badge-queries/31859 "2015-08-07T07:20:03Z")
:warning: Enabling Badge SQL entails security and performance risks so it is not available by default. For more information, see: Enable Badge SQL Here are some common badge queries which you can use to create your … --- ## [O que significa a tabela "Top Referrers"?](https://meta.discourse.org/t/what-does-the-top-referrers-table-mean/30300)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **Respostas:** 1\ **Última atualização:** [22 Junho , 2015 02:30 UTC](https://meta.discourse.org/t/what-does-the-top-referrers-table-mean/30300 "2015-06-22T02:30:44Z")
Não consigo entender a tabela "Top Referrers" com as colunas Clikes e Tópicos. Alguém pode explicar exatamente o que significa essa tabela? Este é sobre o número de cliques feitos pelos visitantes nos links internos para navegar para uma página diferente… --- ## [A badge awarded to posts that contain attachments?](https://meta.discourse.org/t/a-badge-awarded-to-posts-that-contain-attachments/276676)
**Author:** [@mochabcha](https://meta.discourse.org/u/mochabcha)\ **Respostas:** 3\ **Última atualização:** [10 Abril , 2015 17:59 UTC](https://meta.discourse.org/t/a-badge-awarded-to-posts-that-contain-attachments/276676 "2015-04-10T17:59:58Z")
How about a badge awarded to posts that contain attachments? What sql query would accomplish that? --- ## [Badge based on 'read time'](https://meta.discourse.org/t/badge-based-on-read-time/276726)
**Author:** [@alefattorini](https://meta.discourse.org/u/alefattorini)\ **Respostas:** 3\ **Última atualização:** [18 Março , 2015 12:28 UTC](https://meta.discourse.org/t/badge-based-on-read-time/276726 "2015-03-18T12:28:53Z")
@PJH do you implemented a badge on “read time” yet? :smiley: --- ## [Early Adopter badge](https://meta.discourse.org/t/early-adopter-badge/276723)
**Author:** [@dbrgn](https://meta.discourse.org/u/dbrgn)\ **Respostas:** 3\ **Última atualização:** [12 Março , 2015 14:32 UTC](https://meta.discourse.org/t/early-adopter-badge/276723 "2015-03-12T14:32:47Z")
What about this? Pioneer / Early Adopter Granted to the first 10 users that posted something on the forum. (Note that you should probably exclude all test and system accounts from this query…) SELECT MIN(id) AS post\_id… --- ## [Badge granted to our staff members that have read the guidelines placed in our hidden staff category](https://meta.discourse.org/t/badge-granted-to-our-staff-members-that-have-read-the-guidelines-placed-in-our-hidden-staff-category/276721)
**Author:** [@john\_mardlin](https://meta.discourse.org/u/john_mardlin)\ **Respostas:** 11\ **Última atualização:** [3 Março , 2015 06:09 UTC](https://meta.discourse.org/t/badge-granted-to-our-staff-members-that-have-read-the-guidelines-placed-in-our-hidden-staff-category/276721 "2015-03-03T06:09:52Z")
We’d like to have a badge granted to our staff members that have read the guidelines placed in our hidden staff category. This would (presumably) be very similar to the “Read Guidelines” badge: SELECT user\_id, read\_faq… --- ## ['Emeritus' Badge for higher Trust Levels](https://meta.discourse.org/t/emeritus-badge-for-higher-trust-levels/276722)
**Author:** [@riking](https://meta.discourse.org/u/riking)\ **Respostas:** 0\ **Última atualização:** [27 Fevereiro , 2015 09:05 UTC](https://meta.discourse.org/t/emeritus-badge-for-higher-trust-levels/276722 "2015-02-27T09:05:02Z")
Regular Emeritus SELECT user\_id, granted\_at FROM user\_badges WHERE badge\_id = 3 Description: Users with this badge have been a regular user of this forum now or in the past. The badge is awarded when the user first atta… --- ## [Likes in a short time/in one topic](https://meta.discourse.org/t/likes-in-a-short-time-in-one-topic/276679)
**Author:** [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)\ **Respostas:** 2\ **Última atualização:** [15 Fevereiro , 2015 14:07 UTC](https://meta.discourse.org/t/likes-in-a-short-time-in-one-topic/276679 "2015-02-15T14:07:18Z")
I run a game development community and showcasing your game is always a great way to harvest Likes. As far as grand total of Likes go, spreading your updates out is probably the way to go, but the Badge system won’t take… --- ## [Grant a badge for all members of a group](https://meta.discourse.org/t/grant-a-badge-for-all-members-of-a-group/18147)
**Author:** [@sam](https://meta.discourse.org/u/sam)\ **Respostas:** 0\ **Última atualização:** [27 Julho , 2014 22:25 UTC](https://meta.discourse.org/t/grant-a-badge-for-all-members-of-a-group/18147 "2014-07-27T22:25:57Z")
I just created a badge for all the awesome plugin authors. Creating a badge targeting a group is quite easy, just type this into the SQL box: select user\_id, created\_at granted\_at, NULL post\_id from group\_users where g… [Página anterior](https://meta.discourse.org/c/community-building/data-reporting/148.md?page=24)