# Hot **URL:** https://meta.discourse.org/hot.md?page=1642 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 1643 --- ## [User participation](https://meta.discourse.org/t/user-participation/275012)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [November 17, 2017, 2:39pm UTC](https://meta.discourse.org/t/user-participation/275012 "2017-11-17T14:39:42Z")
User participation Shows the following columns over a specified time range (in days): user\_id, username, name, email, visits, topics\_viewed, posts\_read, posts\_cr… --- ## [Participation Histograms](https://meta.discourse.org/t/participation-histograms/275022)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [November 17, 2017, 2:42pm UTC](https://meta.discourse.org/t/participation-histograms/275022 "2017-11-17T14:42:55Z")
Participation Histograms (Output from these used to make graphs shown in this post). Posts Read User Counts Number of users who have read at least N posts over the specified time period. -- \[params\] -- int :from\_days\_a… --- ## [New users within the past week (formatted usernames)](https://meta.discourse.org/t/new-users-within-the-past-week-formatted-usernames/275023)
**Author:** [@outofthebox](https://meta.discourse.org/u/outofthebox)\ **Replies:** 2\ **Last updated:** [January 18, 2018, 1:26pm UTC](https://meta.discourse.org/t/new-users-within-the-past-week-formatted-usernames/275023 "2018-01-18T13:26:55Z")
Hi, can anyone provide a data explorer query that provides a list of all new users within the past week and month? It’d be ideal if the format was so they were already @mentioned, making it easy to copy-paste it into a n… --- ## [Help modifying a query to return usernames, instead of user ID numbers](https://meta.discourse.org/t/help-modifying-a-query-to-return-usernames-instead-of-user-id-numbers/275025)
**Author:** [@BenLeong](https://meta.discourse.org/u/BenLeong)\ **Replies:** 2\ **Last updated:** [January 25, 2018, 4:53am UTC](https://meta.discourse.org/t/help-modifying-a-query-to-return-usernames-instead-of-user-id-numbers/275025 "2018-01-25T04:53:04Z")
Hi! I’m looking for a bit of help modifying a query to return usernames, instead of user ID numbers. This is what I’ve been using so far (modified from @DavidGNavas’ excellent Network Chart thread) WITH pairs AS ( … --- ## [Users who like flagged posts](https://meta.discourse.org/t/users-who-like-flagged-posts/275027)
**Author:** [@ChrisBeach](https://meta.discourse.org/u/ChrisBeach)\ **Replies:** 0\ **Last updated:** [February 11, 2018, 12:10am UTC](https://meta.discourse.org/t/users-who-like-flagged-posts/275027 "2018-02-11T00:10:08Z")
Users who like flagged posts A pattern I’ve spotted on my forum: one or two users habitually “like” posts that break our community guidelines. These users may not intentionally be trolling, but their “likes” are serving… --- ## [User Digest options](https://meta.discourse.org/t/user-digest-options/275028)
**Author:** [@robmc](https://meta.discourse.org/u/robmc)\ **Replies:** 0\ **Last updated:** [April 3, 2018, 1:41pm UTC](https://meta.discourse.org/t/user-digest-options/275028 "2018-04-03T13:41:49Z")
User Digest options It may not be the best way to do it (I still need to find a way to tell it to convert minutes to “Daily”, “Weekly” etc) but I find this information useful in order to know what digests my members are … --- ## [Help with creating a query to randomly check PMs for certain terms](https://meta.discourse.org/t/help-with-creating-a-query-to-randomly-check-pms-for-certain-terms/275030)
**Author:** [@DNSTARS](https://meta.discourse.org/u/DNSTARS)\ **Replies:** 4\ **Last updated:** [July 12, 2018, 3:48pm UTC](https://meta.discourse.org/t/help-with-creating-a-query-to-randomly-check-pms-for-certain-terms/275030 "2018-07-12T15:48:16Z")
How best do you think to fetch 10% of user to user PM messages in the last 30 days I’m trying to find a “randomise” function that could be called upon? I run a website where people talk about largely illegal stuff - dr… --- ## [Users who don’t have a particular badge](https://meta.discourse.org/t/users-who-don-t-have-a-particular-badge/275031)
**Author:** [@John\_Waltrip1](https://meta.discourse.org/u/John_Waltrip1)\ **Replies:** 3\ **Last updated:** [July 17, 2018, 10:36pm UTC](https://meta.discourse.org/t/users-who-don-t-have-a-particular-badge/275031 "2018-07-17T22:36:43Z")
I’m trying to put together a query that will show users of a group that don’t have a particular badge, like Certified. Something along the lines of "give me all the users from group VIP where badge Certified does not ex… --- ## [Do Email DNS records have to be in Cloudfare?](https://meta.discourse.org/t/do-email-dns-records-have-to-be-in-cloudfare/275033)
**Author:** [@afscstagiaire](https://meta.discourse.org/u/afscstagiaire)\ **Replies:** 7\ **Last updated:** [August 22, 2023, 10:42am UTC](https://meta.discourse.org/t/do-email-dns-records-have-to-be-in-cloudfare/275033 "2023-08-22T10:42:58Z")
First time setting up anything in the world of networking, still new to DNS. I’m setting up a forum for the nonprofit i just joined. They’ve been using Brevo for their newsletter. I got a DigitalOcean droplet, installe… --- ## [Summary email algorithm could use some work](https://meta.discourse.org/t/summary-email-algorithm-could-use-some-work/275034)
**Author:** [@ganncamp](https://meta.discourse.org/u/ganncamp)\ **Replies:** 2\ **Last updated:** [November 6, 2023, 12:44pm UTC](https://meta.discourse.org/t/summary-email-algorithm-could-use-some-work/275034 "2023-11-06T12:44:27Z")
I’ve long had the sense that the summary emails were a bit useless, but I didn’t have a concrete example before: --- ## [Lurkers who become members](https://meta.discourse.org/t/lurkers-who-become-members/275035)
**Author:** [@JanJoost](https://meta.discourse.org/u/JanJoost)\ **Replies:** 0\ **Last updated:** [September 9, 2018, 2:52pm UTC](https://meta.discourse.org/t/lurkers-who-become-members/275035 "2018-09-09T14:52:09Z")
Lurkers who become members Hi all, I’m rather new to this, but boy - what a cool tool this is! Here’s a (very simple!) qeuery I created which allows you to easily identify lurkers who became member in the last so many … --- ## [Stats for group members](https://meta.discourse.org/t/stats-for-group-members/275036)
**Author:** [@kinocharlino](https://meta.discourse.org/u/kinocharlino)\ **Replies:** 4\ **Last updated:** [July 18, 2018, 6:48pm UTC](https://meta.discourse.org/t/stats-for-group-members/275036 "2018-07-18T18:48:14Z")
I’m looking for a query that would give me usage/participation stats for all users in a specific group. We have volunteers who help the community and have them all in primary group “ninjas.” I’m looking to get a table wi… --- ## [Established users with trust-level locked to 0 or 1](https://meta.discourse.org/t/established-users-with-trust-level-locked-to-0-or-1/275037)
**Author:** [@ChrisBeach](https://meta.discourse.org/u/ChrisBeach)\ **Replies:** 0\ **Last updated:** [October 22, 2018, 12:19pm UTC](https://meta.discourse.org/t/established-users-with-trust-level-locked-to-0-or-1/275037 "2018-10-22T12:19:40Z")
Established users with trust-level locked to 0 or 1: -- \[params\] -- int :min\_visited\_days = 30 -- int :min\_posts = 1 SELECT id AS user\_id, manual\_locked\_trust\_level, days\_visited, post\_count FROM … --- ## [Users who have added tags to topics](https://meta.discourse.org/t/users-who-have-added-tags-to-topics/275040)
**Author:** [@southpaw](https://meta.discourse.org/u/southpaw)\ **Replies:** 2\ **Last updated:** [November 19, 2018, 4:36am UTC](https://meta.discourse.org/t/users-who-have-added-tags-to-topics/275040 "2018-11-19T04:36:26Z")
Could anyone help me get started toward writing a query that would return the users who have added a specific tag to topics, and number of times they’ve done so during a given date range? @nixie were you able to write t… --- ## [Finding 'Top X' users with the most badges](https://meta.discourse.org/t/finding-top-x-users-with-the-most-badges/275042)
**Author:** [@Richie](https://meta.discourse.org/u/Richie)\ **Replies:** 5\ **Last updated:** [December 23, 2018, 6:06pm UTC](https://meta.discourse.org/t/finding-top-x-users-with-the-most-badges/275042 "2018-12-23T18:06:46Z")
Has anyone come up with some SQL to display a list of users (top 10 maybe), ordered by the total number of Badges they have? I’ve had a poke around in the Data Explorer and looked at the “user\_badges” table and can see … --- ## [How many members open the Welcome PM?](https://meta.discourse.org/t/how-many-members-open-the-welcome-pm/275043)
**Author:** [@Jumanji](https://meta.discourse.org/u/Jumanji)\ **Replies:** 4\ **Last updated:** [March 11, 2019, 12:25am UTC](https://meta.discourse.org/t/how-many-members-open-the-welcome-pm/275043 "2019-03-11T00:25:07Z")
Can somebody help with a query showing how many members open the Welcome PM? Thanks! --- ## [Broken page: (Failed to execute 'removeChild' on 'Node')](https://meta.discourse.org/t/broken-page-failed-to-execute-removechild-on-node/275044)
**Author:** [@Don](https://meta.discourse.org/u/Don)\ **Replies:** 3\ **Last updated:** [August 15, 2023, 6:42am UTC](https://meta.discourse.org/t/broken-page-failed-to-execute-removechild-on-node/275044 "2023-08-15T06:42:45Z")
Hello :wave: I’ve catched this error in console. It appears when I translate the page with the browser built-in Google Translator. Console error Uncaught DOMException: Failed to execute 'removeChild' on 'Node': The no… --- ## [List all open PMs](https://meta.discourse.org/t/list-all-open-pms/275045)
**Author:** [@rishabh](https://meta.discourse.org/u/rishabh)\ **Replies:** 0\ **Last updated:** [March 15, 2019, 12:57pm UTC](https://meta.discourse.org/t/list-all-open-pms/275045 "2019-03-15T12:57:56Z")
List all open PMs sorted by recent activity SELECT t.id AS topic\_id, t.user\_id FROM topics t JOIN posts p ON t.id = p.topic\_id WHERE t.archetype = 'private\_message' AND t.user\_id \> 0 AND t.reply\_coun… --- ## [New topics (by month)](https://meta.discourse.org/t/new-topics-by-month/275046)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 9:15am UTC](https://meta.discourse.org/t/new-topics-by-month/275046 "2018-02-12T09:15:00Z")
New topics Lists all new topics created with a given month, ordered by category and creation\_date. The query accepts a ‘months\_ago’ parameter. It defaults to 0 to give you the stats for the current month. -- \[params\] --… --- ## [New topics per category (by month)](https://meta.discourse.org/t/new-topics-per-category-by-month/275047)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 10:37am UTC](https://meta.discourse.org/t/new-topics-per-category-by-month/275047 "2018-02-12T10:37:00Z")
New topics per category (by month) Returns the number of new topics created in each category for a given month, ordered by topic\_count. The query accepts a ‘months ago’ parameter, defaults to 0 to give the results for th… --- ## [How to exclude a Category from search or Search through all categories except one+](https://meta.discourse.org/t/how-to-exclude-a-category-from-search-or-search-through-all-categories-except-one/275051)
**Author:** [@Alimot\_Akinbode](https://meta.discourse.org/u/Alimot_Akinbode)\ **Replies:** 2\ **Last updated:** [August 14, 2023, 6:26pm UTC](https://meta.discourse.org/t/how-to-exclude-a-category-from-search-or-search-through-all-categories-except-one/275051 "2023-08-14T18:26:09Z")
I’m trying to exclude a category from but this feature does not seem to work.As an alternative, I also tried to search through multiple categories but this doesn’t work either. Is there a way around this? --- ## [Login popup not display](https://meta.discourse.org/t/login-popup-not-display/275055)
**Author:** [@b.iyer](https://meta.discourse.org/u/b.iyer)\ **Replies:** 4\ **Last updated:** [August 18, 2023, 10:44am UTC](https://meta.discourse.org/t/login-popup-not-display/275055 "2023-08-18T10:44:54Z")
Hello, I have done following steps to install Discourse: install Ubuntu on Oracle Vitrual box. follow the steps given on URL: Install Discourse on Ubuntu or Debian for Development to install Discourse instance. insta… --- ## [The "more" menu option for About, FAQ, Badges, Groups is missing on Safari with macOS - but only when logged in](https://meta.discourse.org/t/the-more-menu-option-for-about-faq-badges-groups-is-missing-on-safari-with-macos-but-only-when-logged-in/275060)
**Author:** [@Richie](https://meta.discourse.org/u/Richie)\ **Replies:** 13\ **Last updated:** [August 14, 2023, 6:23pm UTC](https://meta.discourse.org/t/the-more-menu-option-for-about-faq-badges-groups-is-missing-on-safari-with-macos-but-only-when-logged-in/275060 "2023-08-14T18:23:53Z")
I feel somewhat embarrassed asking this question as I’m sure the answer is obvious. We’re getting warnings on our dashboard about the legacy navigation menu we’re still using so I’ve been trying to explore the new layou… --- ## [Is it possible to freeze Flair for a group? ie prevent a User from self-changing it?](https://meta.discourse.org/t/is-it-possible-to-freeze-flair-for-a-group-ie-prevent-a-user-from-self-changing-it/275064)
**Author:** [@mindy](https://meta.discourse.org/u/mindy)\ **Replies:** 2\ **Last updated:** [August 16, 2023, 9:14pm UTC](https://meta.discourse.org/t/is-it-possible-to-freeze-flair-for-a-group-ie-prevent-a-user-from-self-changing-it/275064 "2023-08-16T21:14:59Z")
Is it possible to NOT allow the user to change or modify their Flair if they belong to a particular group? We have a group that identifies a user that they have a financial interest in the product (ie a sponsor), so it … --- ## [Top 50 active topics (and their associated categories)](https://meta.discourse.org/t/top-50-active-topics-and-their-associated-categories/275110)
**Author:** [@vinothkannans](https://meta.discourse.org/u/vinothkannans)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 11:15am UTC](https://meta.discourse.org/t/top-50-active-topics-and-their-associated-categories/275110 "2018-02-12T11:15:00Z")
Top 50 active topics (and their associated categories) Returns the top 50 active topics per month. It’s based on the number of replies created for a topic in a given month. The query accepts a ‘months\_ago’ parameter, def… --- ## [Solved count by members (monthly)](https://meta.discourse.org/t/solved-count-by-members-monthly/275111)
**Author:** [@vinothkannans](https://meta.discourse.org/u/vinothkannans)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 11:36am UTC](https://meta.discourse.org/t/solved-count-by-members-monthly/275111 "2018-02-12T11:36:00Z")
Solved count by members (monthly) Count of topics solved by regular members (defaults to last month) -- \[params\] -- int :months\_ago = 1 WITH query\_period AS ( SELECT date\_trunc('month', CURRENT\_DATE) - INTERVAL ':month… --- ## [Solved count by staff (monthly)](https://meta.discourse.org/t/solved-count-by-staff-monthly/275112)
**Author:** [@vinothkannans](https://meta.discourse.org/u/vinothkannans)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 12:03pm UTC](https://meta.discourse.org/t/solved-count-by-staff-monthly/275112 "2018-02-12T12:03:00Z")
Solved count by staff (monthly) Count of topics solved by staff(defaults to last month) -- \[params\] -- int :months\_ago = 1 WITH query\_period AS ( SELECT date\_trunc('month', CURRENT\_DATE) - INTERVAL ':months\_ago months'… --- ## [Topics solved by regular users (lists topics)](https://meta.discourse.org/t/topics-solved-by-regular-users-lists-topics/275113)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 12:45pm UTC](https://meta.discourse.org/t/topics-solved-by-regular-users-lists-topics/275113 "2018-02-12T12:45:00Z")
Topics solved by regular users (lists topics) Returns topics solved by regular users over a given monthly period, ordered by solution\_date. The query accepts a ‘months\_ago’ parameter, and defaults to 0 to give the result… --- ## [Topics solved by staff (lists topics)](https://meta.discourse.org/t/topics-solved-by-staff-lists-topics/275114)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 12:56pm UTC](https://meta.discourse.org/t/topics-solved-by-staff-lists-topics/275114 "2018-02-12T12:56:00Z")
Topics solved by staff (lists topics) Returns topics solved by staff over a given monthly period, ordered by solution\_date. The query accepts a ‘months\_ago’ parameter, defaults to 0 to give the results for the current mo… --- ## [Top 50 posters](https://meta.discourse.org/t/top-50-posters/275115)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 1:06pm UTC](https://meta.discourse.org/t/top-50-posters/275115 "2018-02-12T13:06:00Z")
Top 50 posters Returns the top 50 posters for a given monthly period. Results are ordered by post\_count. It accepts a ‘months\_ago’ parameter, defaults to 0 to give results for the current month. -- \[params\] -- int :mont… [Previous page](https://meta.discourse.org/hot.md?page=1641) [Next page](https://meta.discourse.org/hot.md?page=1643)