Statistics on most-liked posts of all time?

Community Building Data & reporting
4

I just created this Data Explorer query with help from Gemini. Gives the top 10 most liked posts, ever.

-- Queries the top 10 most liked posts of all time (for modern Discourse versions)
SELECT
    p.id AS post_id,
    p.like_count,
    CONCAT('/t/', t.slug, '/', t.id, '/', p.post_number) AS url,
    t.title AS topic_title,
    p.user_id,
    u.username
FROM posts AS p
JOIN topics AS t ON t.id = p.topic_id
JOIN users AS u ON u.id = p.user_id
WHERE p.deleted_at IS NULL
  AND t.deleted_at IS NULL
  AND p.post_type = 1 -- 1 for regular posts
ORDER BY p.like_count DESC
LIMIT 10