SQL
AخA
USE cswiki_p;
SELECT ref.page_title, pl_title FROM pagelinks
LEFT JOIN page AS cs ON cs.page_title = pl_title AND cs.page_namespace = pl_namespace
JOIN enwiki_p.page AS en ON en.page_title = pl_title AND en.page_namespace = pl_namespace
JOIN page AS ref ON ref.page_id = pl_from
WHERE cs.page_id IS NULL
AND pl_namespace = 0
AND pl_from_namespace = 0
LIMIT 1;
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.