Fork of
Indef sysop creation protection
by Anarchyte
This query is marked as a draft
This query has been published
by Anarchyte.
SQL
AخA
SELECT
CONCAT ("[[",pt_title,"]]")
AS 'Page', user_name AS "Protecting admin", pt_timestamp AS "Time", comment_text AS "Summary"
FROM protected_titles
JOIN comment ON comment_id = pt_reason_id
JOIN user on user_id = pt_user
WHERE pt_expiry = 'infinity'
AND pt_create_perm = 'sysop'
AND pt_namespace = 0;
AND pt_title LIKE "%'''%"
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.