Replicas browser and optimizer
This query is marked as a draft
This query has been published
On enwiki since 1 January 2017. Note the query can be a bit slow, there are a lot of log entries to go through.
SELECT log_id, log_timestamp, log_user_text, comment_text FROM logging JOIN comment ON (log_comment_id = comment_id) WHERE log_type = 'block' AND log_action='unblock' AND log_user_text = REPLACE(log_title,'_',' ') AND log_timestamp >= '20170101000000' ORDER BY log_timestamp DESC;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in