Query Run
use commonswiki_p; select log_type, substring(log_timestamp,1,4), count(*)... 1 year ago
SET @rev = (SELECT MIN(rev_id) FROM revision WHERE... 1 year ago