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
Galanben
.
test
Toggle Highlighting
SQL
(SELECT c.page_title, b.edits, e.page_create_date FROM( (SELECT b.rev_timestamp, b.rev_page, c.page_namespace, c.page_title, b.edits FROM ( SELECT a.rev_timestamp, a.rev_page, COUNT(*) AS edits FROM revision a WHERE a.rev_timestamp BETWEEN "201601" AND "201602" GROUP BY a.rev_page ORDER BY edits DESC LIMIT 500 ) AS b INNER JOIN page ON rev_page = page_id WHERE page_namespace = 1 ORDER BY page_namespace, edits DESC LIMIT 20)) c JOIN (SELECT d.rev_page, MIN(d.rev_timestamp) as page_create_date, FROM revision d WHERE MIN(d.rev_timestamp) > "20160101000000") e on c.rev_page = e.rev_page LIMIT 10);
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...