AFDs for pages in a given cat

AFDs for pages currently in [[Category:Disambiguation pages with Chinese character titles]].  (Doesn't attempt to find nominations after the first, nor, of course, afds for pages that were actually deleted.)

For [[WP:Deletion review/Log/2023 October 12#樂天]] circa 12 October 2023.

SQL

SELECT CONCAT('WP:', wpafd.page_title) AS afd
FROM categorylinks
JOIN page AS article ON article.page_namespace = 0 AND article.page_id = cl_from
JOIN page AS wpafd ON wpafd.page_namespace = 4 AND wpafd.page_title = CONCAT('Articles_for_deletion/', article.page_title)
WHERE cl_to = 'Disambiguation_pages_with_Chinese_character_titles';

AخA
 
SELECT CONCAT('WP:', wpafd.page_title) AS afdFROM categorylinksJOIN page AS article ON article.page_namespace = 0 AND article.page_id = cl_fromJOIN page AS wpafd ON wpafd.page_namespace = 4 AND wpafd.page_title = CONCAT('Articles_for_deletion/', article.page_title)WHERE cl_to = 'Disambiguation_pages_with_Chinese_character_titles';

SQL

Checking query status...