SELECT u.id, u.name, u.email, COUNT(p.id) AS paste_count
FROM users u
LEFT JOIN pastes p ON p.user_id = u.id
WHERE u.status = 1
GROUP BY u.id, u.name, u.email
ORDER BY paste_count DESC
LIMIT 10;