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

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

SQL

SELECT
	page_title AS "典範條目（FL）"
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 "撤銷典範條目（FL）"
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

SQL

Checking query status...