# Community Building **URL:** https://meta.discourse.org/c/community-building/65.md?page=55 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 56 --- ## [1E9 says thank you, Discourse!](https://meta.discourse.org/t/1e9-says-thank-you-discourse/116264)
**Author:** [@Krischan](https://meta.discourse.org/u/Krischan)\ **Replies:** 0\ **Last updated:** [April 29, 2019, 5:37pm UTC](https://meta.discourse.org/t/1e9-says-thank-you-discourse/116264 "2019-04-29T17:37:47Z")
I would like to take a moment to express my deep gratitude here: With the help of Discourse, the great team behind it and the extraordinary community around it, we - the former team of WIRED Germany - were able to launch… --- ## [Looking for some good badges related to Voting](https://meta.discourse.org/t/looking-for-some-good-badges-related-to-voting/116086)
**Author:** [@Marc\_Montecalvo](https://meta.discourse.org/u/Marc_Montecalvo)\ **Replies:** 6\ **Last updated:** [April 29, 2019, 2:06pm UTC](https://meta.discourse.org/t/looking-for-some-good-badges-related-to-voting/116086 "2019-04-29T14:06:37Z")
I have a few ideas for badges but I’m unsure how to write the queries (I don’t know the table structure well enough). The numbers are just to use as a base. I’ll be extending them for additional badges. Someone got 1… --- ## [Why did more people come to my old forum?](https://meta.discourse.org/t/why-did-more-people-come-to-my-old-forum/116105)
**Author:** [@SealsRock12](https://meta.discourse.org/u/SealsRock12)\ **Replies:** 3\ **Last updated:** [April 28, 2019, 5:23pm UTC](https://meta.discourse.org/t/why-did-more-people-come-to-my-old-forum/116105 "2019-04-28T17:23:48Z")
I recently upgraded from phpBB to Discourse, but in the same amount of time, 13 people came to my phpBB by only 1 person came to my Discourse. Why is that? --- ## [Public message in-line where a post was removed by flag?](https://meta.discourse.org/t/public-message-in-line-where-a-post-was-removed-by-flag/107067)
**Author:** [@keith1](https://meta.discourse.org/u/keith1)\ **Replies:** 1\ **Last updated:** [April 28, 2019, 8:09am UTC](https://meta.discourse.org/t/public-message-in-line-where-a-post-was-removed-by-flag/107067 "2019-04-28T08:09:21Z")
Our community just ran into a scenario where a post was (correctly) flagged as inappropriate, but the responses to it remained civil and fruitful discussions. I’ve accepted the community flag and removed the post, but no… --- ## [Please don't pressure self-installers to be on Beta branch](https://meta.discourse.org/t/please-dont-pressure-self-installers-to-be-on-beta-branch/32237)
**Author:** [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)\ **Replies:** 6\ **Last updated:** [April 26, 2019, 7:46pm UTC](https://meta.discourse.org/t/please-dont-pressure-self-installers-to-be-on-beta-branch/32237 "2019-04-26T19:46:19Z")
I’ve heard this a couple times now, and understand where you’re coming from, but being on Beta is not doable for us. We have no dedicated sysadmin or web developer who can attend to the plethora of smaller things that c… --- ## [Good Community Still Not In Google](https://meta.discourse.org/t/good-community-still-not-in-google/115557)
**Author:** [@burningman](https://meta.discourse.org/u/burningman)\ **Replies:** 3\ **Last updated:** [April 26, 2019, 2:14pm UTC](https://meta.discourse.org/t/good-community-still-not-in-google/115557 "2019-04-26T14:14:42Z")
Hey Guys, I created a Discourse community for my client around 10 days ago. But till today, when I checked on google, Google is not indexing a single page of the community. It’s Completely Unusual. I checked on Googl… --- ## [Should be enjoying Christmas! badge](https://meta.discourse.org/t/should-be-enjoying-christmas-badge/281536)
**Author:** [@Alexander\_Wright](https://meta.discourse.org/u/Alexander_Wright)\ **Replies:** 2\ **Last updated:** [April 20, 2019, 8:53pm UTC](https://meta.discourse.org/t/should-be-enjoying-christmas-badge/281536 "2019-04-20T20:53:45Z")
Should be enjoying Christmas! This code give every user who logs in between ‘Day of Year’ = 358 and 2 days into the new year a badge. Word it as you like! SQL: SELECT distinct(user\_id), CURRENT\_DATE as granted\_at FROM… --- ## [User Statistics for a particular group](https://meta.discourse.org/t/user-statistics-for-a-particular-group/275174)
**Author:** [@DNSTARS](https://meta.discourse.org/u/DNSTARS)\ **Replies:** 0\ **Last updated:** [April 18, 2019, 11:33am UTC](https://meta.discourse.org/t/user-statistics-for-a-particular-group/275174 "2019-04-18T11:33:44Z")
Got this sorted promptly with the professional talent of @pfaffman, our thanks to him. The script I’ll turn over for the community. They way we will be using it is by letting in 100 registrants or so, locking public acce… --- ## [TeamAndro exploring a migration from phpBB](https://meta.discourse.org/t/teamandro-exploring-a-migration-from-phpbb/114802)
**Author:** [@teamandro](https://meta.discourse.org/u/teamandro)\ **Replies:** 15\ **Last updated:** [April 12, 2019, 10:50pm UTC](https://meta.discourse.org/t/teamandro-exploring-a-migration-from-phpbb/114802 "2019-04-12T22:50:09Z")
Hi everyone, we are running a forum that can be found at www.team-andro.com/phpBB3 Statistics are as follows: Existing since 2004 About 9.9 million posts in more than 360 k topics Nearly 290 k users Around 40 k visit… --- ## [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… --- ## [Strategy to increase real names and profile usage?](https://meta.discourse.org/t/strategy-to-increase-real-names-and-profile-usage/54544)
**Author:** [@Denis\_Didkovsky](https://meta.discourse.org/u/Denis_Didkovsky)\ **Replies:** 8\ **Last updated:** [December 22, 2016, 11:14am UTC](https://meta.discourse.org/t/strategy-to-increase-real-names-and-profile-usage/54544 "2016-12-22T11:14:23Z")
Strategy to increase real names usage and profile. We have discourse forum for supporting face-to-face meetups and (70% of audience is remote anyhow). Our estimation is that only 50% of our audience have Facebook accou… --- ## [Identifying users who only want to sell their product/services](https://meta.discourse.org/t/identifying-users-who-only-want-to-sell-their-product-services/114745)
**Author:** [@DigitalStartup](https://meta.discourse.org/u/DigitalStartup)\ **Replies:** 4\ **Last updated:** [April 11, 2019, 10:34am UTC](https://meta.discourse.org/t/identifying-users-who-only-want-to-sell-their-product-services/114745 "2019-04-11T10:34:37Z")
I’ve had my forum online for less than 6 months but it’s growing everyday. But today, I had my first “shiller” (or whatever the term is). Basically, someone who joins signs up and leaves a reply in a post leaving a link… --- ## [Discourse - this genuinely awesome forum software](https://meta.discourse.org/t/discourse-this-genuinely-awesome-forum-software/113756)
**Author:** [@Zeemah](https://meta.discourse.org/u/Zeemah)\ **Replies:** 0\ **Last updated:** [April 8, 2019, 2:03pm UTC](https://meta.discourse.org/t/discourse-this-genuinely-awesome-forum-software/113756 "2019-04-08T14:03:42Z")
Hi there, I’d just like to thank all Discourse staff for their hard work on this software. It’s genuinely awesome and I’d just like to say my thanks to you all. I’m currently a moderator for a forum with ~250k members a… --- ## [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… --- ## [How to Track Community Growth in Forums - Jono Bacon](https://meta.discourse.org/t/how-to-track-community-growth-in-forums-jono-bacon/113260)
**Author:** [@erlend\_sh](https://meta.discourse.org/u/erlend_sh)\ **Replies:** 0\ **Last updated:** [April 2, 2019, 6:31pm UTC](https://meta.discourse.org/t/how-to-track-community-growth-in-forums-jono-bacon/113260 "2019-04-02T18:31:05Z")
When I work with clients, one of the key things they want to understand is how they track community growth and react to the data they are seeing. This can be a complex business: community platforms provide bazillions … --- ## [How we use Discourse as a superior ..... management tool](https://meta.discourse.org/t/how-we-use-discourse-as-a-superior-management-tool/113029)
**Author:** [@pipkin](https://meta.discourse.org/u/pipkin)\ **Replies:** 5\ **Last updated:** [April 2, 2019, 9:45am UTC](https://meta.discourse.org/t/how-we-use-discourse-as-a-superior-management-tool/113029 "2019-04-02T09:45:46Z")
This post is in reply to @sam’s question, but I think it merits a new topic. I’m the co-founder of an industrial robotics consultancy & training startup from Holland. In many cases, we are flown in once proverbial sh\*… --- ## [Why start a forum at all ? Trying to understand motivations](https://meta.discourse.org/t/why-start-a-forum-at-all-trying-to-understand-motivations/4248)
**Author:** [@varshakarthik08](https://meta.discourse.org/u/varshakarthik08)\ **Replies:** 5\ **Last updated:** [February 28, 2013, 11:04pm UTC](https://meta.discourse.org/t/why-start-a-forum-at-all-trying-to-understand-motivations/4248 "2013-02-28T23:04:06Z")
I am only trying to understand. Is the motivation to start something cool, engage people in a healthy way and help community or is the end goal be able to monetize it ? Hope my question doesn’t come across as flame - but… --- ## [What CMSes can I embed Discourse into?](https://meta.discourse.org/t/what-cmses-can-i-embed-discourse-into/112913)
**Author:** [@Watercolor\_Games](https://meta.discourse.org/u/Watercolor_Games)\ **Replies:** 3\ **Last updated:** [March 31, 2019, 5:52pm UTC](https://meta.discourse.org/t/what-cmses-can-i-embed-discourse-into/112913 "2019-03-31T17:52:32Z")
Hey guys! So, my gamedev team’s website has been going really well as far as stability goes. I currently have Discourse, MediaWiki and Anchor CMS going on the website which is okay. I’ve also gotten user accounts to be… --- ## [Find posts "solved" in specific month](https://meta.discourse.org/t/find-posts-solved-in-specific-month/112674)
**Author:** [@user2](https://meta.discourse.org/u/user2)\ **Replies:** 4\ **Last updated:** [March 29, 2019, 10:06pm UTC](https://meta.discourse.org/t/find-posts-solved-in-specific-month/112674 "2019-03-29T22:06:38Z")
I run discourse in a corporate environment as an order and documentation system. I use tags to choose whether an order (topic) is ongoing or completed. But I would need a way to identify orders that are completed in Mars… --- ## [Counting pageviews per topic using the Data-Explorer plugin](https://meta.discourse.org/t/counting-pageviews-per-topic-using-the-data-explorer-plugin/112417)
**Author:** [@Alexandra\_Diehl](https://meta.discourse.org/u/Alexandra_Diehl)\ **Replies:** 5\ **Last updated:** [March 27, 2019, 12:25am UTC](https://meta.discourse.org/t/counting-pageviews-per-topic-using-the-data-explorer-plugin/112417 "2019-03-27T00:25:05Z")
Hi, everybody, Please, could you tell me how can I access to history/temporal data about the pageviews per topic? I tried it using the table top\_topics, and topic\_views, but none of them contains the complete results s… --- ## [Managing "Voting" Roadmap Features](https://meta.discourse.org/t/managing-voting-roadmap-features/111232)
**Author:** [@mtan](https://meta.discourse.org/u/mtan)\ **Replies:** 4\ **Last updated:** [March 26, 2019, 7:36am UTC](https://meta.discourse.org/t/managing-voting-roadmap-features/111232 "2019-03-26T07:36:33Z")
When you have a “Voting” feature in your forum and you deliver the feature: How do you handle the topic, do you archive, close, move to a new category? How do you manage follow-up requests? How do you preserve the vote… --- ## [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)? … --- ## [Splitting topic into a new message for moderation](https://meta.discourse.org/t/splitting-topic-into-a-new-message-for-moderation/111825)
**Author:** [@Zeemah](https://meta.discourse.org/u/Zeemah)\ **Replies:** 7\ **Last updated:** [March 18, 2019, 1:58am UTC](https://meta.discourse.org/t/splitting-topic-into-a-new-message-for-moderation/111825 "2019-03-18T01:58:36Z")
I recently came across a situation where I needed to talk to a user about further clarification about what his topic was about, to ensure that they didn’t disobey the rules. I initially started the conversation on the or… --- ## [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? --- ## [Data Explorer Categories Permissions](https://meta.discourse.org/t/data-explorer-categories-permissions/111682)
**Author:** [@csmu](https://meta.discourse.org/u/csmu)\ **Replies:** 1\ **Last updated:** [March 16, 2019, 8:09pm UTC](https://meta.discourse.org/t/data-explorer-categories-permissions/111682 "2019-03-16T20:09:23Z")
Is there any existing SQL to extract the distinct permissions for all the subcategories for a parent category against the permissions for a parent category using the Data Explorer plugin? --- ## [Examples of communities running ads](https://meta.discourse.org/t/examples-of-communities-running-ads/93652)
**Author:** [@tyraniczar](https://meta.discourse.org/u/tyraniczar)\ **Replies:** 4\ **Last updated:** [March 15, 2019, 7:00pm UTC](https://meta.discourse.org/t/examples-of-communities-running-ads/93652 "2019-03-15T19:00:07Z")
Hey all, do you have any examples of sizable communities that run ads on their platform? I didn’t see any on the ones I checked @ customers. Thanks --- ## [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 … --- ## [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… --- ## [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! --- ## [Building a Discourse vs Mailing List spreadsheet](https://meta.discourse.org/t/building-a-discourse-vs-mailing-list-spreadsheet/111106)
**Author:** [@sjmscott](https://meta.discourse.org/u/sjmscott)\ **Replies:** 3\ **Last updated:** [March 8, 2019, 6:33pm UTC](https://meta.discourse.org/t/building-a-discourse-vs-mailing-list-spreadsheet/111106 "2019-03-08T18:33:25Z")
I’m part of the leadership team in a community of 180. After 2.5 years we still have men who are grumbling about our move away from yahoo groups. We’ve begun brainstorming the benefits of Discourse over Yahoo Groups. … [Previous page](https://meta.discourse.org/c/community-building/65.md?page=54) [Next page](https://meta.discourse.org/c/community-building/65.md?page=56)