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.