Untitled query #78522

SQL

SELECT 
p.page_title AS template, 
GROUP_CONCAT(REPLACE(pr.page_title, '_', ' ') SEPARATOR ',') as redirect_title,
GROUP_CONCAT(REPLACE(links.pl_title, '_', ' ') SEPARATOR ',') as page_title
FROM page AS p
JOIN pagelinks AS links ON (links.pl_from = p.page_id)
JOIN page AS pr ON (links.pl_title = pr.page_title)
JOIN redirect ON (redirect.rd_from = pr.page_id)
WHERE p.page_is_redirect = 0
AND p.page_namespace = 10
AND p.page_title NOT Like '%/%'
AND links.pl_from_namespace = 10
AND links.pl_namespace = 0
AND links.pl_title IN (SELECT pl.page_title FROM page AS pl WHERE pl.page_namespace = 0 AND pl.page_is_redirect = 1)
GROUP BY p.page_title
LIMIT 100;
SQL

Checking query status...
