Untitled query #87482

SQL

SELECT 
    p_to.page_title AS target_title,
    COUNT(p_from.page_id) AS redirect_count,
    GROUP_CONCAT(p_from.page_title ORDER BY p_from.page_title) AS redirect_titles
FROM page p_to
LEFT JOIN redirect r ON r.rd_title = p_to.page_title 
    AND r.rd_namespace = p_to.page_namespace
LEFT JOIN page p_from ON r.rd_from = p_from.page_id 
    AND p_from.page_is_redirect = 1
WHERE p_to.page_namespace = 0
    AND p_to.page_is_redirect = 0
GROUP BY p_to.page_title
HAVING redirect_count > 0
ORDER BY redirect_count DESC, p_to.page_title
LIMIT 1000 OFFSET 1000;
SQL

Checking query status...
