Editprotected pages by level of protection and namespace

SQL

SELECT 
    CASE p.page_namespace
        WHEN 0 THEN 'Main'
        WHEN 1 THEN 'Talk'
        WHEN 2 THEN 'User'
        WHEN 3 THEN 'User talk'
        WHEN 4 THEN 'Wikipedia'
        WHEN 5 THEN 'Wikipedia talk'
        WHEN 6 THEN 'File'
        WHEN 7 THEN 'File talk'
        WHEN 8 THEN 'MediaWiki'
        WHEN 9 THEN 'MediaWiki talk'
        WHEN 10 THEN 'Template'
        WHEN 11 THEN 'Template talk'
        WHEN 12 THEN 'Help'
        WHEN 13 THEN 'Help talk'
        WHEN 14 THEN 'Category'
        WHEN 15 THEN 'Category talk'
        WHEN 100 THEN 'Portal'
        WHEN 101 THEN 'Portal talk'
        WHEN 118 THEN 'Draft'
        WHEN 119 THEN 'Draft talk'
        ELSE CONCAT('Namespace ', p.page_namespace)
    END AS namespace_name,
    pr.pr_level AS protection_level,
    COUNT(pr.pr_page) AS count
FROM 
    page_restrictions pr
JOIN 
    page p ON pr.pr_page = p.page_id
WHERE 
    pr.pr_type = 'edit'
GROUP BY 
    p.page_namespace,
    pr.pr_level
ORDER BY 
    p.page_namespace,
    pr.pr_level;
SQL

Checking query status...
