Untitled query #81873 - Quarry

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

SQL

SELECT
  user.user_name,
  user.user_editcount
FROM user
JOIN ipblocks ON user.user_id = ipblocks.ipb_user
WHERE user.user_editcount > 50000
AND (ipblocks.ipb_expiry > NOW() OR ipblocks.ipb_expiry = 'infinity' OR ipblocks.ipb_expiry IS NULL)
ORDER BY user.user_editcount DESC

​x
 
SELECT  user.user_name,  user.user_editcountFROM userJOIN ipblocks ON user.user_id = ipblocks.ipb_userWHERE user.user_editcount > 50000AND (ipblocks.ipb_expiry > NOW() OR ipblocks.ipb_expiry = 'infinity' OR ipblocks.ipb_expiry IS NULL)ORDER BY user.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.

Checking query status...