Fork of
Hewiki template restrictions
by IKhitron
This query is marked as a draft
This query has been published
by IKhitron.
SQL
x
use ruwiki_p;
SELECT
CONCAT('[[Ш:', page_title, ']]'),
page_len
FROM page
WHERE
page_namespace = 10
AND (page_restrictions like "%edit=sysop%"
or
EXISTS (
SELECT
1
FROM page_restrictions
WHERE pr_page = page_id
AND pr_type = 'edit'
AND pr_level = 'sysop'
))
AND EXISTS (
SELECT
1
FROM templatelinks
WHERE tl_from = page_id
AND tl_namespace = 10
AND tl_title = 'Doc-inline'
)
ORDER BY page_len DESC
;
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.