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 CONVERT(DATE_FORMAT(DATE_FORMAT(NOW(), '%Y-%m-01') - INTERVAL(a.a + (10 * b.a) + (100 * c.a)) MONTH, '%Y%m'), UNSIGNED INTEGER) 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 a.Date = FLOOR(logging.log_timestamp / 100000000) WHERE a.Date >= 200101 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...