Untitled query #87422

SQL

SELECT 
    p_to.page_title AS target_title,
    COUNT(DISTINCT p_from.page_id) AS redirect_count,
    GROUP_CONCAT(DISTINCT 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_id, p_to.page_title  -- added page_id to grouping
HAVING redirect_count > 0
ORDER BY redirect_count DESC, p_to.page_title
LIMIT 100 OFFSET 2000;
SQL

Checking query status...
