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_title like '%.js' or page_title like '%.css') -- filter .js and .css pages
and page_content_model IN ('javascript', 'css', 'json') -- filter pages of javascript and css content model
group by page_id
order by pr_level asc, page_title asc; -- arrange by protection level and title in asceding order
SQL

Checking query status...
