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

SQL

# FA
SELECT
	CONCAT('* {{icon|FA}} [[', REPLACE(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;

# FFA
SELECT
	page_title AS 撤銷典範條目（FFA）
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;

# FL
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

# FFL
SELECT
	page_title AS 撤銷特色列表（FFL）
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...
