# Hot **URL:** https://meta.discourse.org/hot.md?page=1686 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 1687 --- ## [Simple plugin request to show which user clicked a link](https://meta.discourse.org/t/simple-plugin-request-to-show-which-user-clicked-a-link/275091)
**Author:** [@AndyBr](https://meta.discourse.org/u/AndyBr)\ **Replies:** 2\ **Last updated:** [August 31, 2023, 5:20pm UTC](https://meta.discourse.org/t/simple-plugin-request-to-show-which-user-clicked-a-link/275091 "2023-08-31T17:20:07Z")
What would you like done? Show who clicked link When do you need it done? No real hurry What is your budget, in $ USD that you can offer for this task? It looks to be very simple, so I’m hoping someone would run with i… --- ## [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… --- ## [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… [Previous page](https://meta.discourse.org/hot.md?page=1685) [Next page](https://meta.discourse.org/hot.md?page=1687)