AFDs for pages in a given cat

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

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 LIKE CONCAT('Articles_for_deletion/', article.page_title, '%')
WHERE cl_to = 'Disambiguation_pages_with_Chinese_character_titles';

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...