‎ - Quarry

Fork of 85267 - Edits to certain pages by category 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),page_latest, 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
JOIN pagelinks ON pl_title
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 20040101000000 AND 20241231125959
  AND page_is_redirect = 0
  AND pl_title = '2024_NFL_Draft'
GROUP BY page_namespace, page_title
ORDER BY count DESC
LIMIT 1000

SQL

Checking query status...