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', (SELECT DATE_FORMAT(log_timestamp, '%Y-%m-%d') FROM logging WHERE log_type = 'block' AND log_action in ('block', 'reblock') AND log_title = wonderfool_name ORDER BY log_timestamp DESC limit 1) as 'block date' FROM (SELECT pl_title AS wonderfool_name FROM pagelinks WHERE pl_from = (SELECT page_id FROM page WHERE page_namespace = 2 AND page_title = 'AryamanA/Wonderfool') AND pl_namespace = 2 AND pl_title != "JohnC5" LIMIT 10) AS wonderfool JOIN `user` ON replace(wonderfool_name, '_', ' ') = user_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...