/* Copied from rdcheck.py */

/*SELECT page_namespace, page_title/*, rd_namespace, rd_title, rd_fragment*/

/*FROM redirect

JOIN page ON page_id=rd_from

WHERE rd_namespace=0 AND rd_title="Ebola_virus_disease"*/

​

/* Debugging another query */

​

    SELECT rd_namespace, rd_title, rd_fragment, page2_title

    FROM redirect

    JOIN (

      SELECT

        page_id AS page2_id,

        page_namespace AS page2_namespace,

        page_title AS page2_title

      FROM page

    ) AS page2 ON page2_id = rd_from

    WHERE rd_title = "BLP_unsourced_section"