Assessment templates, including redirects to them

SQL

SELECT DISTINCT page.page_title, redirectpage.page_title
FROM categorylinks
INNER JOIN page ON page.page_id = categorylinks.cl_from
LEFT OUTER JOIN redirect ON redirect.rd_title = page.page_title
INNER JOIN page redirectpage ON redirectpage.page_id = redirect.rd_from
WHERE categorylinks.cl_to = "WikiProject_banners_with_quality_assessment"
AND page.page_namespace = 10
AND redirect.rd_namespace = 10
LIMIT 5

AخA
 
SELECT DISTINCT page.page_title, redirectpage.page_titleFROM categorylinksINNER JOIN page ON page.page_id = categorylinks.cl_fromLEFT OUTER JOIN redirect ON redirect.rd_title = page.page_titleINNER JOIN page redirectpage ON redirectpage.page_id = redirect.rd_fromWHERE categorylinks.cl_to = "WikiProject_banners_with_quality_assessment"AND page.page_namespace = 10AND redirect.rd_namespace = 10LIMIT 5

SQL

Checking query status...