Fork of
Bearcat protections II
by Mdaniels5757
This query is marked as a draft
This query has been published
by Mdaniels5757.
SQL
x
USE enwiki_p;
SELECT * FROM logging_userindex INNER JOIN page ON log_page = page_id INNER JOIN page_restrictions on pr_page = page_id
WHERE
log_actor = 273 AND # User:Bearcat
log_type = 'protect' AND
log_params LIKE '%/[edit=sysop/] (indefinite)%' escape '/' AND
pr_type = 'edit' AND
pr_level = 'sysop';
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.