Untitled query #36632

SQL

/* 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_namespace, page2_title, page2_is_redirect
    FROM redirect
    JOIN (
      SELECT
        page_id AS page2_id,
        page_namespace AS page2_namespace,
        page_title AS page2_title,
        page_is_redirect AS page2_is_redirect
      FROM page
    ) AS page2 ON page2_id = rd_from
    WHERE rd_namespace = 11 AND rd_title = "BLP_unsourced_section"
SQL

Checking query status...
