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
JJMC89
.
Toggle Highlighting
SQL
select user_name `User`, ipb_reason `Block reason`, ipb_by_text `Admin`, ipb_timestamp `Timestamp` from ipblocks ipb left join user u on ipb.ipb_user = u.user_id where ipb_reason like '%memorialblock%' order by `Timestamp`; select log_title `User`, log_comment `Block reason`, log_user_text `Admin`, log_timestamp `Timestamp` from logging_compat where log_namespace = 2 and log_type='block' and log_comment like '%memorialblock%' order by `Timestamp`;
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...