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) AS c ) a JOIN logging ON a.Date = FLOOR(logging.log_timestamp / 100000000) WHERE a.Date >= 200101 AND logging.log_type IN ('block', 'delete', 'import', 'merge', 'protect', '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...