# Hot **URL:** https://meta.discourse.org/hot.md?page=1643 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 1644 --- ## [Top 50 likers](https://meta.discourse.org/t/top-50-likers/275116)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 1:26pm UTC](https://meta.discourse.org/t/top-50-likers/275116 "2018-02-12T13:26:00Z")
Top 50 likers Returns the top 50 likers for a given monthly period. Results are ordered by like\_count. It accepts a ‘months\_ago’ parameter and defaults to 0 to give results for the current month. -- \[params\] -- int :mon… --- ## [Time to first response by group members](https://meta.discourse.org/t/time-to-first-response-by-group-members/275118)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 13\ **Last updated:** [October 12, 2023, 4:28pm UTC](https://meta.discourse.org/t/time-to-first-response-by-group-members/275118 "2023-10-12T16:28:58Z")
Time to first group response for topics created within a given time period Returns the time to first response by a member of a given group to “regular” (not Personal Message) topics created by a user who is not a member … --- ## [Topics solved by staff](https://meta.discourse.org/t/topics-solved-by-staff/275119)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 2:07pm UTC](https://meta.discourse.org/t/topics-solved-by-staff/275119 "2018-02-12T14:07:00Z")
Topics solved by staff The number of topics solved by staff for a given time period, broken down by categories. The categories array can be altered by editing this line: WHERE t.category\_id = ANY ('{46,25,43,40,44,35,22,… --- ## [Topics solved by regular users](https://meta.discourse.org/t/topics-solved-by-regular-users/275120)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [February 12, 2018, 3:15pm UTC](https://meta.discourse.org/t/topics-solved-by-regular-users/275120 "2018-02-12T15:15:00Z")
Topics solved by regular users (There is probably a way to combine this query with the staff query.) The number of topics solved by staff for a given time period, broken down by categories. The categories array can be a… --- ## [I thought login 'with email' meant use my email to login](https://meta.discourse.org/t/i-thought-login-with-email-meant-use-my-email-to-login/275121)
**Author:** [@jidanni](https://meta.discourse.org/u/jidanni)\ **Replies:** 1\ **Last updated:** [August 15, 2023, 1:31am UTC](https://meta.discourse.org/t/i-thought-login-with-email-meant-use-my-email-to-login/275121 "2023-08-15T01:31:55Z")
Here the user is surprised. He thought that email button meant to use the usual email address and password combination below. Only after he presses it does he realize that it’s going to send him an email, where he can g… --- ## [Option for the legacy Share popup](https://meta.discourse.org/t/option-for-the-legacy-share-popup/275124)
**Author:** [@darkpixlz](https://meta.discourse.org/u/darkpixlz)\ **Replies:** 3\ **Last updated:** [August 18, 2023, 4:36am UTC](https://meta.discourse.org/t/option-for-the-legacy-share-popup/275124 "2023-08-18T04:36:03Z")
Hello, Recently on Meta I’ve seen a new “link copied” text when clicking a Share button, which is extremely useful. I’m not sure if it’s a plugin or a beta feature, but I’d live to see it in core, as I don’t see it on m… --- ## [Where is the watched words regular expressions site setting?](https://meta.discourse.org/t/where-is-the-watched-words-regular-expressions-site-setting/275125)
**Author:** [@Firepup650](https://meta.discourse.org/u/Firepup650)\ **Replies:** 2\ **Last updated:** [August 14, 2023, 10:07pm UTC](https://meta.discourse.org/t/where-is-the-watched-words-regular-expressions-site-setting/275125 "2023-08-14T22:07:45Z")
In reply to How to use Discourse regexes with watched words? - #9 by justin On the forum I help run, I can’t seem to get regex replaced properly. I can’t find the site setting that the post I linked mentioned, and it’s … --- ## [Topics solved by regular users and staff](https://meta.discourse.org/t/topics-solved-by-regular-users-and-staff/275127)
**Author:** [@Jp\_Robotshop](https://meta.discourse.org/u/Jp_Robotshop)\ **Replies:** 0\ **Last updated:** [April 16, 2018, 4:41pm UTC](https://meta.discourse.org/t/topics-solved-by-regular-users-and-staff/275127 "2018-04-16T16:41:44Z")
Indeed :slight\_smile: Kinda struggled with it but found a way to make it work. So, here you go! -- \[params\] -- int :months\_ago = 0 WITH query\_period AS ( SELECT date\_trunc('month', CURRENT\_DATE) - INTERVAL ':months\_ag… --- ## [Users Last Seen Since (Since N Weeks Ago)](https://meta.discourse.org/t/users-last-seen-since-since-n-weeks-ago/275128)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 1:45am UTC](https://meta.discourse.org/t/users-last-seen-since-since-n-weeks-ago/275128 "2016-05-01T01:45:00Z")
Users Last Seen Since (Since N Weeks Ago) with intervals as ( select n as start\_time, CURRENT\_TIMESTAMP as end\_time from generate\_series(CURRENT\_TIMESTAMP - INTERVAL '140 days', … --- ## [Users Last Seen Since (Since N Days Ago)](https://meta.discourse.org/t/users-last-seen-since-since-n-days-ago/275130)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 2:00am UTC](https://meta.discourse.org/t/users-last-seen-since-since-n-days-ago/275130 "2016-05-01T02:00:00Z")
Users Last Seen Since (Since N Days Ago) with intervals as ( select n as start\_time, CURRENT\_TIMESTAMP as end\_time from generate\_series(CURRENT\_TIMESTAMP - INTERVAL '30 days', … --- ## [A Topic counted as new, but it showed no new topics (This Also Happens in all other forums)](https://meta.discourse.org/t/a-topic-counted-as-new-but-it-showed-no-new-topics-this-also-happens-in-all-other-forums/275131)
**Author:** [@LxmasWasntHere](https://meta.discourse.org/u/LxmasWasntHere)\ **Replies:** 2\ **Last updated:** [August 14, 2023, 11:36pm UTC](https://meta.discourse.org/t/a-topic-counted-as-new-but-it-showed-no-new-topics-this-also-happens-in-all-other-forums/275131 "2023-08-14T23:36:28Z")
There was a new topic (the indicator saying “(1)” was showing there was), so i clicked on it. Although, it didn’t show me any topics. I cannot upload the video, because i am currently stuck in TL0. If said to screenshot… --- ## [Posts Read (Daily)](https://meta.discourse.org/t/posts-read-daily/275133)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 4:53am UTC](https://meta.discourse.org/t/posts-read-daily/275133 "2016-05-01T04:53:00Z")
Posts Read (Daily) Total number of new posts read by all users per day SELECT visited\_at as day, count(1) as users, sum(posts\_read) as posts\_read, sum(posts\_read) / count(1) as avg\_posts\_read\_per\_user FROM user\_visits … --- ## [Posts Read Percentiles](https://meta.discourse.org/t/posts-read-percentiles/275134)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 5:00am UTC](https://meta.discourse.org/t/posts-read-percentiles/275134 "2016-05-01T05:00:00Z")
Posts Read Percentiles Number of posts read for users in each percentile with tentiles as ( select posts\_read\_count as read, ntile(10) over (order by posts\_read\_count) as tentile from user\_stats ) sel… --- ## [Active Readers (Past Month)](https://meta.discourse.org/t/active-readers-past-month/275135)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 5:15am UTC](https://meta.discourse.org/t/active-readers-past-month/275135 "2016-05-01T05:15:00Z")
Active Readers (Past Month) Users with the most visits that include reading activity select user\_id, count(1) as visits, sum(posts\_read) as posts\_read from user\_visits where posts\_read \> 0 and visited\_at \> CURR… --- ## [Active Readers (Since N Days Ago)](https://meta.discourse.org/t/active-readers-since-n-days-ago/275136)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 4:53am UTC](https://meta.discourse.org/t/active-readers-since-n-days-ago/275136 "2016-05-01T04:53:38Z")
Active Readers (Since N Days Ago) Number of users who have read at least 1 post since N days ago with intervals as ( select n as start\_time, CURRENT\_TIMESTAMP as end\_time from generate\_series(CU… --- ## [Posts created for period](https://meta.discourse.org/t/posts-created-for-period/275138)
**Author:** [@HAWK](https://meta.discourse.org/u/HAWK)\ **Replies:** 0\ **Last updated:** [September 14, 2016, 9:54pm UTC](https://meta.discourse.org/t/posts-created-for-period/275138 "2016-09-14T21:54:25Z")
Posts created for period Got what I need (thanks @meglio) so updating this for future posterity. -- \[params\] -- date :date\_from -- date :date\_to -- int :min\_posts = 1 WITH user\_activity AS ( SELECT p.user\_id, cou… --- ## [Off-topic posts that deserved their own topic](https://meta.discourse.org/t/off-topic-posts-that-deserved-their-own-topic/275139)
**Author:** [@Mittineague](https://meta.discourse.org/u/Mittineague)\ **Replies:** 0\ **Last updated:** [May 27, 2016, 3:47am UTC](https://meta.discourse.org/t/off-topic-posts-that-deserved-their-own-topic/275139 "2016-05-27T03:47:44Z")
While working on this I was looking for a way to find topics that were created as a result of a moderator splitting posts into a new topic. (i.e. off-topic posts that deserved their own topic) It wasn’t as easy as I … --- ## [Active users in the last 30 days](https://meta.discourse.org/t/active-users-in-the-last-30-days/275140)
**Author:** [@riking](https://meta.discourse.org/u/riking)\ **Replies:** 3\ **Last updated:** [September 5, 2016, 9:47pm UTC](https://meta.discourse.org/t/active-users-in-the-last-30-days/275140 "2016-09-05T21:47:07Z")
Active users in the last 30 days select username from users where last\_posted\_at \> current\_timestamp - interval '30' day --- ## [How to filter out a group?](https://meta.discourse.org/t/how-to-filter-out-a-group/275141)
**Author:** [@Kyle\_Selby](https://meta.discourse.org/u/Kyle_Selby)\ **Replies:** 2\ **Last updated:** [May 14, 2018, 7:07pm UTC](https://meta.discourse.org/t/how-to-filter-out-a-group/275141 "2018-05-14T19:07:20Z")
Hello all, I am attempting to filter out a group I created named “Employees” from this data explorer tab, what am I doing wrong? How do I exclude group that I have created?: SELECT sum(p.score) / count(p) as "… --- ## [Why is iOS Discourse Hub app faster than "Add to Home Screen" app?](https://meta.discourse.org/t/why-is-ios-discourse-hub-app-faster-than-add-to-home-screen-app/275142)
**Author:** [@Jonathan5](https://meta.discourse.org/u/Jonathan5)\ **Replies:** 0\ **Last updated:** [August 14, 2023, 11:47pm UTC](https://meta.discourse.org/t/why-is-ios-discourse-hub-app-faster-than-add-to-home-screen-app/275142 "2023-08-14T23:47:46Z")
On my phone, the Discourse Hub app is noticably faster to load any forum than its “Add to Home Screen” app. Is there anything I can do to change this? Thanks. --- ## [List of users by who’s solved the most topics/threads](https://meta.discourse.org/t/list-of-users-by-who-s-solved-the-most-topics-threads/275143)
**Author:** [@AstonJ](https://meta.discourse.org/u/AstonJ)\ **Replies:** 0\ **Last updated:** [October 8, 2018, 12:02am UTC](https://meta.discourse.org/t/list-of-users-by-who-s-solved-the-most-topics-threads/275143 "2018-10-08T00:02:06Z")
List of users by who’s solved the most topics/threads Change within\_number\_of\_months to how many months you want to query for. So 3 will show you results from the last three months, etc. -- \[params\] -- int :within\_num… --- ## [Latest uploads](https://meta.discourse.org/t/latest-uploads/275144)
**Author:** [@AstonJ](https://meta.discourse.org/u/AstonJ)\ **Replies:** 0\ **Last updated:** [October 10, 2018, 11:16pm UTC](https://meta.discourse.org/t/latest-uploads/275144 "2018-10-10T23:16:06Z")
Latest uploads SELECT id, user\_id, original\_filename, created\_at, url, extension FROM uploads order by created\_at desc LIMIT 50 Though it would be nice if they show in the results rather than… --- ## [Top 10 referrers over the last month](https://meta.discourse.org/t/top-10-referrers-over-the-last-month/275145)
**Author:** [@AstonJ](https://meta.discourse.org/u/AstonJ)\ **Replies:** 0\ **Last updated:** [October 12, 2018, 1:04am UTC](https://meta.discourse.org/t/top-10-referrers-over-the-last-month/275145 "2018-10-12T01:04:27Z")
Another one I can’t take any credit for - ripped directly out of DC’s dashboard :smiley: Top 10 referrers over the last month SELECT COUNT(\*) AS count\_all, incoming\_domains.name AS incoming\_domains\_name FROM "incomi… --- ## [Poll results](https://meta.discourse.org/t/poll-results/275147)
**Author:** [@JanJoost](https://meta.discourse.org/u/JanJoost)\ **Replies:** 0\ **Last updated:** [December 19, 2018, 10:56am UTC](https://meta.discourse.org/t/poll-results/275147 "2018-12-19T10:56:49Z")
Hi all, I just wrote a post here on how our users mis-use (abuse?) the poll-feature to create their own pub quiz. I created a small query that gets the results of a post with N polls, including which user voted for w… --- ## [Using a CASE expression to order results](https://meta.discourse.org/t/using-a-case-expression-to-order-results/275148)
**Author:** [@simon](https://meta.discourse.org/u/simon)\ **Replies:** 0\ **Last updated:** [March 1, 2019, 8:39pm UTC](https://meta.discourse.org/t/using-a-case-expression-to-order-results/275148 "2019-03-01T20:39:18Z")
Using a CASE expression to order results I don’t think it’s possible to pass a keyword as a parameter, but a boolean :desc parameter could be used in a CASE expression. --\[params\] -- boolean :desc = false SELECT \* FROM… --- ## [Users who have accessed a topic in a protected category](https://meta.discourse.org/t/users-who-have-accessed-a-topic-in-a-protected-category/275149)
**Author:** [@Cozdabuch](https://meta.discourse.org/u/Cozdabuch)\ **Replies:** 3\ **Last updated:** [March 15, 2019, 5:15pm UTC](https://meta.discourse.org/t/users-who-have-accessed-a-topic-in-a-protected-category/275149 "2019-03-15T17:15:37Z")
I could use some help. I don’t know my head from my butt with SQL. I am admining a board for my labor union. I’m an elected rep, but I’m not in leadership. The reason I’m admining it is because I have experience with … --- ## [View Count of a specific tag](https://meta.discourse.org/t/view-count-of-a-specific-tag/275150)
**Author:** [@Viki](https://meta.discourse.org/u/Viki)\ **Replies:** 1\ **Last updated:** [March 16, 2019, 11:41pm UTC](https://meta.discourse.org/t/view-count-of-a-specific-tag/275150 "2019-03-16T23:41:17Z")
How to query the View counts of entire Topics with Particular Tag? --- ## [Topics where user mentioned and hasn’t responded after being mentioned](https://meta.discourse.org/t/topics-where-user-mentioned-and-hasn-t-responded-after-being-mentioned/275152)
**Author:** [@awesomerobot](https://meta.discourse.org/u/awesomerobot)\ **Replies:** 1\ **Last updated:** [March 18, 2019, 11:49am UTC](https://meta.discourse.org/t/topics-where-user-mentioned-and-hasn-t-responded-after-being-mentioned/275152 "2019-03-18T11:49:14Z")
I don’t know even a bit of SQL… but would it be possible to have a query that shows me topics where I’ve been mentioned… but haven’t responded after being mentioned (I imagine this part is tricky, if it’s even possible)? … --- ## [Help with creating a query to replicate TL3 progress](https://meta.discourse.org/t/help-with-creating-a-query-to-replicate-tl3-progress/275153)
**Author:** [@Kyle\_Risi](https://meta.discourse.org/u/Kyle_Risi)\ **Replies:** 0\ **Last updated:** [April 4, 2019, 2:37pm UTC](https://meta.discourse.org/t/help-with-creating-a-query-to-replicate-tl3-progress/275153 "2019-04-04T14:37:52Z")
Hi Guys, We have a scheme within our community in which we promote certain regulars to PosBuddy status, these are regulars who share our brands tone of voice and have show an aptitude for answering questions, driving co… --- ## [Time to first response for a support group](https://meta.discourse.org/t/time-to-first-response-for-a-support-group/275154)
**Author:** [@angus](https://meta.discourse.org/u/angus)\ **Replies:** 0\ **Last updated:** [April 12, 2019, 8:32am UTC](https://meta.discourse.org/t/time-to-first-response-for-a-support-group/275154 "2019-04-12T08:32:25Z")
In the course of working for @icaria36 on improving his use of Discourse groups as a support system, we’ve developed some queries (more to follow). Let us know if you can spot any issues or improvements :slight\_smile: T… [Previous page](https://meta.discourse.org/hot.md?page=1642) [Next page](https://meta.discourse.org/hot.md?page=1644)