Fork of
block and tag diff
by Antigng
This query is marked as a draft
This query has been published
by Antigng.
SQL
AخA
USE zhwiki_p;SELECT user_name FROM ipblocks, user WHERE ipb_expiry="infinity" AND ipb_user=user_id AND NOT EXISTS(SELECT * FROM page WHERE page_title=REPLACE(user_name," ","_") AND page_namespace=2) AND NOT EXISTS(SELECT * FROM protected_titles WHERE pt_title=REPLACE(user_name," ","_") AND pt_namespace=2) AND ipb_timestamp>20180101000000 AND ipb_timestamp<20210115000000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.