‎ - Quarry

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 categorylinks ON page_id = parentcat
JOIN categorylinks ON page_id = cl_from
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 parentcat = 'National_Football_League_players_by_team'
GROUP BY page_namespace, page_title
ORDER BY count DESC
LIMIT 10000
SQL

Checking query status...
