Full protected pages with Lint errors

SQL

select case when page_namespace = 2 then CONCAT('# {{noping|', page_title, '|label1=', page_title, '}}') else
       CONCAT('# [[',
					case when page_namespace=2303 then 'Gadget definition talk:'
						when page_namespace=2302 then 'Gadget definition:'
	              		when page_namespace=2301 then 'Gadget talk:'
    	                when page_namespace=2300 then 'Gadget:'
        	            when page_namespace=829 then 'Module talk:'
            	        when page_namespace=828 then 'Module:'
                	    when page_namespace=710 then 'TimedText:'
	                    when page_namespace=711 then 'TimedText talk:'
        	            when page_namespace=119 then 'Draft talk:'
    	                when page_namespace=118 then 'Draft:'
            	        when page_namespace=101 then 'Portal talk:'
                	    when page_namespace=100 then 'Portal:'
	                    when page_namespace=10 then 'Template:'
    	                when page_namespace=11 then 'Template talk:'
        	            when page_namespace=12 then 'Help:'
            	        when page_namespace=13 then 'Help talk:'
                	    when page_namespace=14 then 'Category:'
	                    when page_namespace=15 then 'Category talk:'
    	                when page_namespace=0 then ''
        	            when page_namespace=1 then 'Talk:'
            	        when page_namespace=3 then 'User talk:'
                	    when page_namespace=4 then 'Wikipedia:'
                    	when page_namespace=5 then 'Wikipedia talk:'
	                    when page_namespace=6 then 'File:'
    	                when page_namespace=7 then 'File talk:'
        	            when page_namespace=8 then 'MediaWiki:'
            	        when page_namespace=9 then 'MediaWiki talk:'
              		end,
              page_title, ']]') 
		 end 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...
