電子遊戲專題認證條目 (zh)

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

用於更新[[w:zh:WikiProject:电子游戏/认证条目]]。列表格式已處理好，可直接下載csv檔；但漢字排序是個謎……

SQL

SELECT
	page_title AS fa
FROM
	page
	JOIN categorylinks AS a ON a.cl_from = page_id
	JOIN categorylinks AS b ON b.cl_from = page_id
WHERE
	a.cl_to = "电子游戏条目"
    AND b.cl_to = "典范条目讨论"
	AND page_namespace = 1
    
SELECT
	page_title AS ffa
FROM
	page as ffapage
	JOIN categorylinks AS c ON c.cl_from = ffapage.page_id
	JOIN categorylinks AS d ON d.cl_from = ffapage.page_id
WHERE
	c.cl_to = "电子游戏条目"
    AND d.cl_to = "已撤銷的典範條目"
	AND ffapage.page_namespace = 1

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...