Untitled query #88335

SQL

SELECT
  rev.user_text AS editor,
  COUNT(*) AS total_edits,
  MIN(rev.timestamp) AS first_edit,
  MAX(rev.timestamp) AS last_edit
FROM
  revision AS rev
JOIN
  page AS p ON rev.page_id = p.page_id
WHERE
  rev.user_text = 'USERNAME'  -- Replace with the desired username
  AND rev.timestamp BETWEEN 'START_DATE' AND 'END_DATE'  -- Replace with the date range (e.g., '2024-01-01' AND '2024-12-31')
  AND p.namespace = 0  -- Namespace 0 is the main namespace (for article edits)
GROUP BY
  rev.user_text
ORDER BY
  total_edits DESC;
SQL

Checking query status...
