Untitled query #62447

SQL

USE metawiki;
SELECT p1.page_namespace AS `namespace`,p1.page_title AS `title`,rd_namespace,rd_title,rd_fragment FROM `redirect` JOIN `page` `p1` ON ((rd_from=p1.page_id)) LEFT JOIN `page` `p2` ON ((rd_namespace=p2.page_namespace) AND (rd_title=p2.page_title)) LEFT JOIN `metawiki`.`page` `gu_p` ON ((rd_namespace=gu_p.page_namespace) AND (rd_title=gu_p.page_title)) WHERE (rd_namespace >= 0) AND (rd_interwiki IS NULL OR rd_interwiki = '') AND (p2.page_namespace IS NULL) AND (gu_p.page_namespace IS NULL) ORDER BY rd_namespace,rd_title,rd_from LIMIT 11;
SQL

Checking query status...
