Which reactions are the most commonly-used in your community?

Let’s slide this over to community to get more eyes on it. :eyes:

Though the query isn’t counting Likes properly, or at least not all of ours (possibly because we’ve turned Reactions on mid-flow)

reaction posts count
:heart: 52295 144915
:+1: 1167 1224
:100: 1101 1236

versus:

reaction_value count
:heart: 1371442
:100: 1236
:+1: 1224
FWIW I've been using a small variation of this one to produce our table:
SELECT source.reaction_value,
       count
FROM

 (
 (
 
SELECT 
    CASE WHEN post_action_type_id = 2 THEN 'heart' END AS reaction_value,
    COUNT(*) AS count
FROM post_actions
WHERE post_action_type_id = 2
  AND deleted_at IS NULL
GROUP BY 1

)
UNION ALL
(

SELECT 
    reaction_value,
    SUM(reaction_users_count) AS count
FROM discourse_reactions_reactions
WHERE reaction_value <> 'heart'
GROUP BY 1

)
) AS source

GROUP BY 1,2
ORDER BY 2 DESC

There’s also the stock one in the reports section too to cross-check (but the table isn’t as easy to copy and paste :slight_smile:) - /admin/reports/reactions

4 Likes