most active users query

By Guest User · 2 months ago · Sql · 243 B

raw download duplicate

SELECT u.id,
       u.name,
       COUNT(p.id) AS paste_count,
       COALESCE(SUM(p.views), 0) AS total_views
FROM users u
LEFT JOIN pastes p ON p.user_id = u.id
GROUP BY u.id, u.name
HAVING paste_count > 0
ORDER BY total_views DESC
LIMIT 25;