Untitled query #59670

This query is marked as a draft This query has been published by AnisElebiary.

SQL

SELECT
                        --    p1.page_id AS from_id,
                            p1.page_title AS from_title,
                        --    p2.page_id AS to_id,
                            p2.page_title AS to_title
                        FROM
                            page p1
                        JOIN
                            redirect r
                        ON
                            r.rd_from = p1.page_id
                        JOIN
                            page p2
                        ON
                            r.rd_title = p2.page_title AND r.rd_namespace = p2.page_namespace
                        WHERE
                            p1.page_namespace = 0;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...