Retort - a reaction-style plugin for Discourse

It’ll be a query to run using the data explorer plugin; let me see if I can cook up a couple queries that might be interesting

EDIT: Here’s the raw data:

SELECT REPLACE(key, '|retort', '') as retort, post_details.post_id, posts.user_id
FROM post_details
INNER JOIN posts on posts.id = post_details.post_id
INNER JOIN topics on topics.id = posts.topic_id
INNER JOIN users ON users.id = posts.user_id;

which you could add further columns like users.name, topics.title, etc. to.

and grouped by number of emojis total on the instance:

SELECT REPLACE(key, '|retort', '') as retort, count(key) as c
FROM post_details
WHERE extra = 'retort'
GROUP BY key
ORDER BY c DESC;
5 Likes