Untitled query #89013

SQL

SELECT 
  actor_name AS user_name,
  COUNT(rev_id) AS edit_count
FROM revision
JOIN actor ON revision.rev_actor = actor.actor_id
LEFT JOIN comment ON revision.rev_comment_id = comment.comment_id
LEFT JOIN change_tag ON revision.rev_id = change_tag.ct_rev_id
WHERE
  rev_timestamp >= UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)
  AND actor_name NOT LIKE '%bot%' -- Exclude bots
  -- AND (ct_tag IS NULL OR ct_tag NOT IN ('twinkle', 'quickstatements')) -- Exclude specific tags
GROUP BY actor_name
HAVING edit_count > 500
ORDER BY edit_count DESC
LIMIT 10; -- Display top 10 users only
SQL

Checking query status...
