# Discourse Retort

**URL:** https://meta.discourse.org/t/discourse-retort/35903
**Category:** Plugin
**Tags:** end-of-life
**Created:** [November 22, 2015, 11:53am UTC](https://meta.discourse.org/t/discourse-retort/35903 "2015-11-22T11:53:58Z")
**Posts on this page:** 1
**Showing post:** 194

<div class="post-metadata">

### Author: ![gdpelican](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/gdpelican/32/81308_2.png) [@gdpelican](https://meta.discourse.org/u/gdpelican)
#### Post date: [October 13, 2017, 1:51am UTC](https://meta.discourse.org/t/discourse-retort/35903/194 "2017-10-13T01:51:42Z")

</div>

It’ll be a query to run using the [data explorer](https://github.com/discourse/discourse-data-explorer) plugin; let me see if I can cook up a couple queries that might be interesting

EDIT: Here’s the raw data:

```plaintext
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:

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

```

---

_[View the full topic](https://meta.discourse.org/t/discourse-retort/35903)._