Edit count to given articles by date

This query is marked as a draft This query has been published by Cryptic.

Number of edits to [[Joe Biden]], [[Donald Trump]], and [[Barack Obama]] by date from January 20 to March 10 in 2021, 2017, and 2009 respectively.
For [[WP:VPT#Is there a way to get a count of edits per day for a certain article?]] circa 15 March 2021.

SQL

SELECT page_title, DATE_FORMAT(LEFT(rev_timestamp, 8), '%Y-%m-%d') AS date, COUNT(*)
FROM revision
JOIN page
  ON page_id = rev_page
WHERE page_namespace = 0
  AND ((page_title = 'Joe_Biden' AND rev_timestamp BETWEEN '20210120' AND '20210311')
       OR (page_title = 'Donald_Trump' AND rev_timestamp BETWEEN '20170120' AND '20170311')
       OR (page_title = 'Barack_Obama' AND rev_timestamp BETWEEN '20090120' AND '20090311'))
GROUP BY page_title, LEFT(rev_timestamp, 8);

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...