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
Cr29uva
.
user page activity
Toggle Highlighting
SQL
select ib.ipb_user, substring(ib.ipb_timestamp,1,6) block_yearmn,substring(re.rev_timestamp,1,6) rev_yearmn from ipblocks ib, revision re where substring(ib.ipb_timestamp,1,6)IN('20180930') and substring(re.rev_timestamp,1,4)IN('201809') and ib.ipb_user = re.rev_user
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...