# Community Building **URL:** https://meta.discourse.org/c/community-building/65.md?page=63 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 64 --- ## [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… --- ## [Is it really bad to have dashes in your domain name?](https://meta.discourse.org/t/is-it-really-bad-to-have-dashes-in-your-domain-name/79787)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **Replies:** 4\ **Last updated:** [February 5, 2018, 2:58pm UTC](https://meta.discourse.org/t/is-it-really-bad-to-have-dashes-in-your-domain-name/79787 "2018-02-05T14:58:45Z")
I need a URL for Ukrainians in Australia. Because I’m not a registered organisation, I can’t pick .com.au, so I’ll have to include the au portion in the URL. If it goes well, I can always migrate later to a proper URL. I… --- ## [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,… --- ## [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… --- ## [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… --- ## [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… --- ## [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… --- ## [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'… --- ## [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… --- ## [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… --- ## [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… --- ## [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\] --… --- ## [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… --- ## [Looks like a great online community solution](https://meta.discourse.org/t/looks-like-a-great-online-community-solution/80058)
**Author:** [@Pat\_Birgan](https://meta.discourse.org/u/Pat_Birgan)\ **Replies:** 0\ **Last updated:** [February 7, 2018, 10:19pm UTC](https://meta.discourse.org/t/looks-like-a-great-online-community-solution/80058 "2018-02-07T22:19:26Z")
Things have come a long way since InVision et al. --- ## [Ability to modify user email settings for group](https://meta.discourse.org/t/ability-to-modify-user-email-settings-for-group/80039)
**Author:** [@robmc](https://meta.discourse.org/u/robmc)\ **Replies:** 5\ **Last updated:** [February 7, 2018, 7:09pm UTC](https://meta.discourse.org/t/ability-to-modify-user-email-settings-for-group/80039 "2018-02-07T19:09:07Z")
It would be REALLY useful if there was a way to change certain default settings for groups of users. I have a number of ‘Absent Friends’ who are those members who joined some months ago and either never re-visited or di… --- ## [Does same content affects ranking](https://meta.discourse.org/t/does-same-content-affects-ranking/79981)
**Author:** [@burningman](https://meta.discourse.org/u/burningman)\ **Replies:** 3\ **Last updated:** [February 7, 2018, 6:51am UTC](https://meta.discourse.org/t/does-same-content-affects-ranking/79981 "2018-02-07T06:51:43Z")
I connects discourse community with my wordpress, that’s why every content posted on wordpress, automatically posted on the discourse community and that’s a great thing. But, I simply want to know, when both pages have … --- ## [What's the best name for "off-topic" category?](https://meta.discourse.org/t/whats-the-best-name-for-off-topic-category/79896)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **Replies:** 6\ **Last updated:** [February 6, 2018, 1:44pm UTC](https://meta.discourse.org/t/whats-the-best-name-for-off-topic-category/79896 "2018-02-06T13:44:59Z")
Did you create a special category for off-topic discussions, and how did you name it? --- ## [How to choose moderators from community members](https://meta.discourse.org/t/how-to-choose-moderators-from-community-members/74774)
**Author:** [@meglio](https://meta.discourse.org/u/meglio)\ **Replies:** 4\ **Last updated:** [February 6, 2018, 8:30am UTC](https://meta.discourse.org/t/how-to-choose-moderators-from-community-members/74774 "2018-02-06T08:30:51Z")
So, among 2300 registered users, there are +/- 100 active users who regularly post, read, talk to other people, invite other people, practice interlinking, learn Markdown: someone more, someone less. But it’s obvious th… --- ## [Advice on best resource to teach novices to use the wiki feature](https://meta.discourse.org/t/advice-on-best-resource-to-teach-novices-to-use-the-wiki-feature/79458)
**Author:** [@David\_Baker1](https://meta.discourse.org/u/David_Baker1)\ **Replies:** 7\ **Last updated:** [February 5, 2018, 3:21pm UTC](https://meta.discourse.org/t/advice-on-best-resource-to-teach-novices-to-use-the-wiki-feature/79458 "2018-02-05T15:21:14Z")
I have a nonprofit membership community who are eager to use the Discourse features but are relative novices and won’t venture into trial and error mode to learn new things. If I can nudge them to try new features with a… --- ## [Flagging use / abuse scenario](https://meta.discourse.org/t/flagging-use-abuse-scenario/53145)
**Author:** [@ampburner](https://meta.discourse.org/u/ampburner)\ **Replies:** 3\ **Last updated:** [November 23, 2016, 11:27pm UTC](https://meta.discourse.org/t/flagging-use-abuse-scenario/53145 "2016-11-23T23:27:04Z")
This is a question to admins of discourse sites, and developers of discourse: I have a long-time user on my forum who has a tendency to attract and/or enter into heated debates. overall: Untill now I have been de… --- ## [Books on community building](https://meta.discourse.org/t/books-on-community-building/40029)
**Author:** [@dosch](https://meta.discourse.org/u/dosch)\ **Replies:** 11\ **Last updated:** [February 3, 2018, 4:09pm UTC](https://meta.discourse.org/t/books-on-community-building/40029 "2018-02-03T16:09:19Z")
In the post explaining “What do user trust levels do?” @codinghorror references the book ‘Communtiy building on the web’. I just started reading it and found it very useful on a meta level. Sadly the examples used are g… --- ## [Addressing gender balance in online communities](https://meta.discourse.org/t/addressing-gender-balance-in-online-communities/74917)
**Author:** [@HAWK](https://meta.discourse.org/u/HAWK)\ **Replies:** 26\ **Last updated:** [February 2, 2018, 10:26pm UTC](https://meta.discourse.org/t/addressing-gender-balance-in-online-communities/74917 "2018-02-02T22:26:14Z")
Continuing the discussion from Contributor Interviews – Daniela "Trash": I’m keen to continue this discussion but I don’t want to hijack Trash’s interview. I have passively hidden my gender online for years. I general… --- ## [Is it a good idea to restrict posting to controversial topics?](https://meta.discourse.org/t/is-it-a-good-idea-to-restrict-posting-to-controversial-topics/56917)
**Author:** [@dfabulich](https://meta.discourse.org/u/dfabulich)\ **Replies:** 6\ **Last updated:** [February 2, 2018, 4:42am UTC](https://meta.discourse.org/t/is-it-a-good-idea-to-restrict-posting-to-controversial-topics/56917 "2018-02-02T04:42:15Z")
Like many forums, we have to deal with some controversial topics, and tempers can and do run high. One idea I’m considering is to make a “controversial” category, and set up the permissions list so everyone can see the … --- ## [Best practices for nonprofit membership organizations](https://meta.discourse.org/t/best-practices-for-nonprofit-membership-organizations/78965)
**Author:** [@David\_Baker1](https://meta.discourse.org/u/David_Baker1)\ **Replies:** 6\ **Last updated:** [January 31, 2018, 3:30pm UTC](https://meta.discourse.org/t/best-practices-for-nonprofit-membership-organizations/78965 "2018-01-31T15:30:26Z")
I only found one topic mentioning nonprofit but it wasn’t what I’m seeking. I’m posting here to see who else is using Discourse to manage a nonprofit association and the communications with/between members. There are man… --- ## [Best tools, materials & practices to onboard a hoarde of new users?](https://meta.discourse.org/t/best-tools-materials-practices-to-onboard-a-hoarde-of-new-users/46426)
**Author:** [@Flo](https://meta.discourse.org/u/Flo)\ **Replies:** 22\ **Last updated:** [January 30, 2018, 10:18pm UTC](https://meta.discourse.org/t/best-tools-materials-practices-to-onboard-a-hoarde-of-new-users/46426 "2018-01-30T22:18:54Z")
Hi there! we’re a higher education learning platform for refugees, and we will launch discourse as part of our platform in a few days. We hope that it will soon become the social core of our virtual campus. Now I think… --- ## [A curated weekly newsletter for your community](https://meta.discourse.org/t/a-curated-weekly-newsletter-for-your-community/76668)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 16\ **Last updated:** [January 29, 2018, 11:45pm UTC](https://meta.discourse.org/t/a-curated-weekly-newsletter-for-your-community/76668 "2018-01-29T23:45:28Z")
I’m starting to put together a curated, weekly “newsletter” on our forum, and thought I’d share something about it here. The contents include: Links to a few of the best discussions from the past week. Sharing some hi… --- ## [Building a business community](https://meta.discourse.org/t/building-a-business-community/78731)
**Author:** [@kyleballing](https://meta.discourse.org/u/kyleballing)\ **Replies:** 7\ **Last updated:** [January 26, 2018, 1:31am UTC](https://meta.discourse.org/t/building-a-business-community/78731 "2018-01-26T01:31:01Z")
Hi community community, I’ve recently been intrigued by the concept of an open source business model. There are all sorts of great open source software and hardware projects out there. There are many companies turning a… --- ## [Ways to easily seed content as posted from various users (startup)](https://meta.discourse.org/t/ways-to-easily-seed-content-as-posted-from-various-users-startup/78608)
**Author:** [@password04](https://meta.discourse.org/u/password04)\ **Replies:** 4\ **Last updated:** [January 25, 2018, 8:08pm UTC](https://meta.discourse.org/t/ways-to-easily-seed-content-as-posted-from-various-users-startup/78608 "2018-01-25T20:08:51Z")
Hey Guys, First post on here.. I’ve been using Discourse in one or two other places now and i’m just about to deploy it for my own site. Among the various ways that I will see the various categories with content is to… --- ## [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 ( … --- ## [Feedback: Have you changed the default text for flag dispositions/flag action responses?](https://meta.discourse.org/t/feedback-have-you-changed-the-default-text-for-flag-dispositions-flag-action-responses/78838)
**Author:** [@Jumanji](https://meta.discourse.org/u/Jumanji)\ **Replies:** 1\ **Last updated:** [January 24, 2018, 4:48am UTC](https://meta.discourse.org/t/feedback-have-you-changed-the-default-text-for-flag-dispositions-flag-action-responses/78838 "2018-01-24T04:48:10Z")
We’ve received some feedback from some of our community that the “auto PMs” received when a moderator agrees/disagrees/defers/agrees+deletes with a flag are too robotic and a bit vague. It’s usually more related to the … [Previous page](https://meta.discourse.org/c/community-building/65.md?page=62) [Next page](https://meta.discourse.org/c/community-building/65.md?page=64)