SQL
AخA
SELECT page_title, pr_level
FROM page LEFT JOIN page_restrictions ON page_id = pr_page
WHERE page_id IN (SELECT rt_page FROM revtag WHERE rt_type = 'tp:mark')
AND page_namespace = 10
AND (pr_type IS NULL OR pr_type = 'edit')
AND (pr_expiry IS NULL OR pr_expiry = 'infinity')
ORDER BY pr_level 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.