User interface pages with protection level set

SQL

select ROW_NUMBER() OVER(order by page_title) num, -- get row number
       CONCAT('[[User:', replace(page_title, '_', ' '), ']]') as 'Page title', -- Format as wikilink, replace _ with space
       pr_level as 'Protection level',
       pr_type as 'Type',
       page_content_model as 'Content model'
from page
join page_restrictions on page_id = pr_page -- link page_restrictions and page table
where page_namespace = 2 -- filter User namespace
and page_content_model IN ('javascript', 'css', 'json') -- filter pages of javascript, css and json content model
order by pr_level asc, page_title asc; -- arrange by protection level and title in asceding order

SQL

Checking query status...