# Community Guide: Activating Lurkers

**URL:** <https://meta.discourse.org/t/community-guide-activating-lurkers/271091>\
**Category:** Community Building\
**Tags:** how-to, guide\
**Created:** [July 10, 2023, 9:33am UTC](https://meta.discourse.org/t/community-guide-activating-lurkers/271091 "2023-07-10T09:33:44Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Lilly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lilly/32/575047_2.png) [@Lilly](https://meta.discourse.org/u/Lilly)\
**Post date:** [July 12, 2023, 12:58am UTC](https://meta.discourse.org/t/community-guide-activating-lurkers/271091/6 "2023-07-12T00:58:59Z")

</div>

you are correct -[Plugin directory | Discourse - Civilized Discussion](https://www.discourse.org/plugins), and it’s always good to point out when a hosted tier is required for a specific plugin. 👍

since their forum has gamification plugin enabled, i have to assume they at least have a hosted business plan, or are self-hosting. i also know from past posts on here that @ganncamp knows how to use the [data explorer](https://meta.discourse.org/t/32566?silent=true) so probably still has it enabled 🙂

* * *

here is a simple [data explorer](https://meta.discourse.org/t/32566?silent=true) query that returns top 100 viewed topics in whatever past interval you want to specify (to present)

```sql
SELECT t.id AS topic_id,
    t.category_id,
    t.views AS view_count
FROM topics t
WHERE t.created_at >= NOW() - INTERVAL '1 year'
ORDER BY t.views DESC
LIMIT 100

```

---

_[View the full topic](https://meta.discourse.org/t/community-guide-activating-lurkers/271091)._