USE betawikiversity_p;

​

SELECT CONCAT("[[:mul:Special:Redirect/page/", cat1.cl_from, "|", cat1.cl_from, "]]") AS `頁面ID及連結`,

    page.page_namespace AS `命名空間編號`,

    page.page_title AS `頁面標題（不含命名空間）`

FROM

(SELECT * FROM categorylinks

 WHERE cl_to = 'ZH') cat1

LEFT JOIN

(SELECT * FROM categorylinks

 WHERE cl_to = 'Now_in_zh.wikiversity.org_project') cat2 ON cat1.cl_from = cat2.cl_from

LEFT JOIN page ON cat1.cl_from = page.page_id

WHERE cat2.cl_to IS NULL

    AND page.page_is_redirect = 0

​