Full protected pages with Lint errors

SQL

select CONCAT('# [['
              ,case when page_namespace=1 then 'Talk:'
                    when page_namespace=2 then 'User:'
                    when page_namespace=3 then 'User_talk:'
                    when page_namespace=4 then 'Wikipedia:'
                    when page_namespace=5 then 'Wikipedia_talk:'
                    when page_namespace=9 then 'MediaWiki_talk:'
                    when page_namespace=10 then 'Template:'
                    when page_namespace=100 then 'Portal:'
                    else '' end
              , page_title, ']]') as 'Page title'
from linter
join page on page_id = linter_page
join page_restrictions on page_id = pr_page
where pr_type = 'edit'
and pr_level = 'sysop'
group by page_id
order by page_namespace asc, page_title asc
limit 4000;
SQL

Checking query status...
