Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Mr. Stradivarius
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT a.Date, COUNT(*) AS 'Count' FROM ( -- Hack to generate a table of dates, adapted from http://stackoverflow.com/questions/2157282/generate-days-from-date-range SELECT DATE_FORMAT(NOW(), '%Y-%m-01') - INTERVAL(a.a + (10 * b.a) + (100 * c.a)) MONTH AS Date FROM (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS a CROSS JOIN (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS b CROSS JOIN (SELECT 0 AS a UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS c ) a JOIN logging ON -- Timestamp for the start of the month log_timestamp >= YEAR(a.Date) * 10000000000 + MONTH(a.Date) * 100000000 AND -- Timestamp for the start of the next month log_timestamp < YEAR(a.Date + INTERVAL(1) MONTH) * 10000000000 + MONTH(a.Date + INTERVAL(1) MONTH) * 100000000 WHERE a.Date BETWEEN '2001-01-01' AND NOW() AND ( logging.log_type = 'block' OR logging.log_type = 'delete' OR logging.log_type = 'import' OR logging.log_type = 'merge' OR logging.log_type = 'protect' OR logging.log_type = 'rights' ) GROUP BY a.Date;
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
.
Checking query status...