SQL
x
USE enwiki_p;
SELECT *
FROM
logging 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
page_len >= 100 AND
log_params LIKE '%\[edit=sysop\] \(indefinite\)%' ESCAPE '\'
# pr_type = 'edit' AND
# pr_level = 'sysop' AND
LIMIT 10
;
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.