- Quarry

Fork of 77762 - Edits over a time period with last timestamp by Red Director

This query is marked as a draft This query has been published by Red Director.

SQL

SELECT  page_title, MAX(rev_timestamp), COUNT(page_title) AS count,
  ( SELECT pa_class
    FROM page_assessments
    WHERE pa_page_id = page_id
      AND pa_class != 'Unknown'
    LIMIT 1
  ) AS pa_class
FROM page
JOIN revision_userindex ON page_id = rev_page
WHERE rev_actor = 100613
  AND page_namespace = 0
  -- Comment out the BETWEEN line if you want all-time stats. Date format is YYYYMMDDHHMMSS
  -- You can also scan edits *after* a date (instead of between two dates) by using:
  --    AND rev_timestamp > 20200101000000
  AND rev_timestamp BETWEEN 20040901000000 AND 20251231000000
  AND page_is_redirect = 0
GROUP BY page_namespace, page_title, page_latest
ORDER BY count DESC
LIMIT 1000

SQL

Checking query status...