Community Guide: Activating Lurkers

Community
,
6

you are correct -Plugin directory | Discourse - Civilized Discussion, and it’s always good to point out when a hosted tier is required for a specific plugin. :+1:

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 so probably still has it enabled :slight_smile:

here is a simple data explorer query that returns top 100 viewed topics in whatever past interval you want to specify (to present)

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
9 Likes