Dead people articles contain Living People category on arwiki

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

SQL

use arwiki_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.page_id not in (select cl_from from categorylinks where cl_to = 'وفيات_مشكوك_فيها')
and page.page_id not in (select cl_from from categorylinks where cl_to = 'وفيات_غير_عادية')
and page.page_id not in (select cl_from from categorylinks where cl_to = 'أشخاص_يحتمل_أن_يكونوا_أحياء') 
and page_is_redirect = 0 
order by page.page_title ASC
;

SQL

Checking query status...