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
Arnab777as3uj
.
USE enwiki_p; select distinct u.*, (SELECT GROUP_CONCAT(up_property SEPARATOR ', ') FROM user_properties up where up.up_user = ib.ipb_user GROUP BY up.up_user) up_property, (SELECT GROUP_CONCAT(up_value SEPARATOR ', ') FROM user_properties up where up.up_user = ib.ipb_user GROUP BY up.up_user) up_value, (SELECT GROUP_CONCAT(ug_group SEPARATOR ', ') FROM user_groups ug where ug.ug_user = ib.ipb_user GROUP BY ug.ug_user) ug_group, ib.*, (select comment_text from comment c where c.comment_id = ib.ipb_reason_id) text from user u right outer join ipblocks ib on u.user_id = ib.ipb_user where SUBSTRING(ib.ipb_timestamp, 1, 4) = '2018' and ib. order by ib.ipb_timestamp desc limit 1000
Toggle Highlighting
SQL
select * from ipblocks limit 500
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...