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
Erutuon
.
Toggle Highlighting
SQL
use enwiktionary_p; select actor_name as blocker, log_title as 'Wonderfool name', user_editcount as 'Wonderfool editcount', if(user_registration is NULL or user_registration = '', '', date_format(user_registration, '%Y-%m-%d')) as 'Wonderfool registration date', comment_text as 'block message', date_format(log_timestamp, '%Y-%m-%d') as date from comment join logging on log_comment_id = comment_id left join actor on actor_id = log_actor left join user on user_name = replace(log_title, '_', ' ') where log_type = 'block' and log_action = 'block' # changing # comment_text like '%wonderfool%' or comment_text like '%Wonderfool%' or comment_text rlike '\\b[Ww][Ff]\\b' # to # (lower(comment_text) like '%wonderfool%') or (comment_text rlike '\\b[Ww][Ff]\\b') # yields fewer results! why? and (comment_text like '%wonderfool%' or comment_text like '%Wonderfool%' or comment_text rlike '\\b[Ww][Ff]\\b');
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...