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 user_name AS name, user_editcount AS 'edit count', lb_date as 'block date' FROM (SELECT pl_title AS wonderfool_name FROM pagelinks WHERE pl_from = (SELECT page_id FROM page WHERE page_namespace = 2 # User AND page_title = 'AryamanA/Wonderfool') AND pl_namespace = 2 # User AND pl_title != "JohnC5") AS wonderfool JOIN `user` ON replace(wonderfool_name, '_', ' ') = user_name JOIN (SELECT log_title as lb_user_name, DATE_FORMAT(MAX(log_timestamp), '%Y-%m-%d') AS lb_date FROM logging_logindex WHERE log_type = 'block' AND log_action IN ('block', 'reblock') GROUP BY log_title) AS latest_block ON lb_user_name = wonderfool_name;
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...