Non-Blocked "88" users

This query is marked as a draft This query has been published by Cryptic.

Usernames starting or ending with 88 not currently blocked on enwiki.  For [[WT:Requests for adminship/AmericanAir88]].

SQL

SELECT user_name, 
       user_editcount, 
       user_registration 
FROM   user 
WHERE  (user_name LIKE "%88" 
        OR user_name LIKE "88%")
           AND user_id NOT IN (SELECT ipb_user 
                               FROM   ipblocks 
                               WHERE  ipb_user = user_id) 
ORDER  BY user_editcount DESC;

AخA
 
SELECT user_name,        user_editcount,        user_registration FROM   user WHERE  (user_name LIKE "%88"         OR user_name LIKE "88%")           AND user_id NOT IN (SELECT ipb_user                                FROM   ipblocks                                WHERE  ipb_user = user_id) ORDER  BY user_editcount DESC; 

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.

SQL

Checking query status...