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
Japanologie
.
Toggle Highlighting
SQL
use jawiki_p; select log_timestamp as "date of blocked", actor_name as "blocker user", log_title as "blocked user", user_registration as "date of registration", log_params as "information" from logging inner join actor on log_actor = actor_id inner join user on log_title = user_name where log_type = 'block' and log_action != 'unblock' and date_add(date(coalesce(user_registration,"2003-01-01")), interval "10" year) < date(log_timestamp) and log_params like "%finite%" order by log_timestamp desc
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...