Untitled query #68262

SQL

SELECT  page_title,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
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 20050101000000 AND 20221231125959
  AND page_is_redirect = 0
GROUP BY page_namespace, page_title
ORDER BY count DESC
LIMIT 300
SQL

Checking query status...
