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
Bdijkstra
.
Note: need to match registered users by ID otherwise the query times out. Executes in ~6 minutes.
Toggle Highlighting
SQL
SELECT RIGHT(cl_to,4) AS year, ipb_address, ipb_timestamp, ipb_expiry, ipb_range_start, ipb_range_end, ipb_sitewide FROM (SELECT ipb_address, ipb_timestamp, ipb_expiry, ipb_range_start, ipb_range_end, ipb_sitewide FROM ipblocks WHERE ipb_auto=0 LIMIT 25) ipb INNER JOIN page ON (page_namespace=3 AND ipb_address=REPLACE(page_title, '_', ' ')) LEFT JOIN categorylinks ON (cl_from=page_id AND cl_to REGEXP '^Wikipedia:Waarschuwing_20[01]') ORDER BY year,`user` /*SELECT page_title AS `user`, RIGHT(cl_to,4) AS year, ipb_address, ipb_timestamp, ipb_expiry, ipb_range_start, ipb_range_end, ipb_sitewide FROM ipblocks INNER JOIN page ON (page_namespace=3 AND ipb_address=REPLACE(page_title, '_', ' ')) LEFT JOIN categorylinks ON (cl_from=page_id AND cl_to REGEXP '^Wikipedia:Waarschuwing_20[01]') WHERE ipb_auto=0 ORDER BY year,`user` LIMIT 1*/
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...