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
  	WHERE pr_type = 'edit' AND prot.pr_level IS NOT NULL AND (prot.pr_expiry IS NULL OR prot.pr_expiry = 'infinity')
  		AND pr_page NOT IN (
          	SELECT pr_page
  			FROM page_restriction
  			WHERE pr_type = 'move' AND prot.pr_level IS NOT NULL AND (prot.pr_expiry IS NULL OR prot.pr_expiry = 'infinity')
  			GROUP by pr_id
        )
  	FROM page_restriction
  	GROUP by pr_id
)
INNER JOIN page ON page.page_id = prot.pr_page
WHERE page.page_namespace IN (10, 828)
GROUP BY page.page_id;
SQL

Checking query status...
