SQL
AخA
USE zhwiki_p;
SELECT tl_from, page_namespace, page_title
FROM (
SELECT DISTINCT tl_from
FROM templatelinks
WHERE tl_from_namespace = 8 AND tl_namespace != 8
) tl
LEFT JOIN page
ON tl_from = page_id
WHERE page_title NOT REGEXP "\/(zh|zh-hans|zh-hant|zh-cn|zh-sg|zh-my|zh-hk|zh-mo|zh-tw)$"
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.