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
Blahma
.
Toggle Highlighting
SQL
SELECT page_title, actor_name, rev_timestamp FROM page JOIN revision ON rev_page = page_id JOIN actor ON rev_actor = actor_id WHERE page_namespace = 0 AND page_is_redirect = 1 AND page_title LIKE '%_%' AND rev_parent_id = 0 AND rev_timestamp REGEXP '^(20200219|20200122|20191218|20191120|20191030|20190918|20190821|20190717|20190619|20190515|20190417|20190320|20190220|20190116|20181219|20181121|20181017|20180919|20180815|20180718|20180620|20180516|20180418|20180321|20180221|20180117|20171220|20171115|20171018|20170913|20170816|20170719|20170621|20170517|20170419|20170322|20170215|20170118|20161221|20161116|20161019|20160921|20160824|20160720|20160615|20160518|20160420|20160316|20160217|20160120)' ORDER BY rev_timestamp
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...
