Untitled query #89058

SQL

SELECT CONCAT(CASE
    WHEN page.page_namespace = 10 THEN "Template"
    WHEN page.page_namespace = 828 THEN "Module"
    ELSE CONVERT(page.page_namespace,char)
END, ":", page.page_title) AS formatted_title
FROM (
 	SELECT pr_page
  	FROM page_restrictions
  	WHERE pr_type = 'edit' AND pr_level IS NOT NULL AND (pr_expiry IS NULL OR pr_expiry = 'infinity')
  		AND pr_page NOT IN (
          	SELECT pr_page
  			FROM page_restrictions
  			WHERE pr_type = 'move' AND pr_level IS NOT NULL AND (pr_expiry IS NULL OR pr_expiry = 'infinity')
			GROUP BY pr_page
        )
  	GROUP BY pr_page
) AS prot
INNER JOIN page AS page ON page.page_id = prot.pr_page
WHERE page.page_namespace IN (10, 828)
GROUP BY page.page_id;
SQL

Checking query status...
