WhatLinksHere all in one

SQL

USE enwiki_p;

SELECT 
    page_id,
    page_namespace,
    page_title,
    rd_from,
    rd_fragment,
    page_is_redirect
FROM
    (SELECT 
        pl_from, rd_from, rd_fragment
    FROM
        `pagelinks`
    LEFT JOIN `redirect` ON ((rd_from = pl_from)
        AND rd_title = 'Main_Page'
        AND (rd_interwiki = ''
        OR rd_interwiki IS NULL)
        AND rd_namespace = 0)
    JOIN `page` ON ((pl_from = page_id))
    WHERE
        pl_namespace = 0
            AND pl_title = 'Main_Page'
    ORDER BY pl_from
    LIMIT 102) `temp_backlink_range`
        JOIN
    `page` ON ((pl_from = page_id))
ORDER BY page_id
LIMIT 51
SQL

Checking query status...
