Query Run
SELECT page_title, COUNT(*) AS edits FROM revision JOIN page ON rev_page =... 1 day ago
select count(*) from (select rev_page, min(rev_timestamp) rev_timestamp... 1 day ago