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

SQL

x
 
USE cswiki_p;
SELECT p.page_id "id", p.page_namespace "from NS", p.page_title "from", pl.pl_namespace "to NS", pl.pl_title "to"#, x.page_title
FROM page p
INNER JOIN pagelinks pl
    ON pl.pl_from = p.page_id
#       AND pp.page_namespace = pl.pl_namespace
#       AND pp.page_title = pl.pl_title
) x
WHERE p.page_namespace = 0 # from Articles
    AND pl.pl_namespace = 0 # to Articles
 /*   AND p.page_title IN (
        SELECT pp.page_title
        FROM page pp
        WHERE pp.page_title LIKE "Mo%" ###
    ) x AND x.page_namespace = pl.pl_namespace
        AND x.page_title = pl.pl_title*/
    
    AND p.page_title = "Setrvačnost" ###
###    AND x.page_title IS NULL
LIMIT 20;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...