Dead people articles contain Living People category on ckbwiki

Fork of Dead people articles contain Living People category on arwiki by FShbib

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

Returns all Central Kurdish biographical articles with "YEAR deaths" and "Living people" categories.

Such articles should be removed from the "Living people" category and the content of their articles updated.

SQL

USE ckbwiki_p;

SELECT
	CONCAT('# [[', page.page_title, ']]')
FROM page
WHERE page_namespace = 0
AND page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to = 'زیندووان')
AND page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to REGEXP 'مردووانی_')
AND page_is_redirect = 0
ORDER BY page.page_title ASC;

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