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 20230101000000 AND 20231231125959

  AND page_is_redirect = 0

  AND page_title = Dohnovan_West

  AND page_title = Cordale_Flott

  AND page_title = Makai_Polk

  AND page_title = Nick_Cross_(American_football)

  AND page_title = Tyler_Smith_(American_football)

  AND page_title = WanDale_Robinson

AND page_title = Zonovan_Knight

AND page_title = Brandon_Smith_(linebacker)

AND page_title = Jameson_Williams

AND page_title = Cade_York

AND page_title = George_Karlaftis

AND page_title = Kenyon_Green

AND page_title = Drake_London

AND page_title = Drake_Jackson

AND page_title = Kaiir_Elam

AND page_title = Kyle_Hamilton_(American_football)

AND page_title = Isaiah_Spiller

AND page_title = Christian_Harris

AND page_title = Breece_Hall

AND page_title = George_Pickens

AND page_title = Derek_Stingley_Jr.

​

GROUP BY page_namespace, page_title

ORDER BY count DESC

LIMIT 500