مقالات أعلام بحاجة لتصنيف:وفيات بعمر

SQL

use arwiki_p;
select page_title, replace(cl_to, "مواليد_", "") as "تاريخ الولادة",
replace((select cl_to from categorylinks where page_id = cl_from and cl_to like "وفيات_%"), "وفيات_", "") as "تاريخ الوفاة",
concat("وفيات بعمر ",replace((select cl_to from categorylinks where page_id = cl_from and cl_to like "وفيات_%"), "وفيات_", "") - replace(cl_to, "مواليد_", "")) as "التصنيف المطلوب"
from page
inner join categorylinks on cl_from = page_id
where page_namespace = 0 and page_is_redirect = 0
and cl_to like "%مواليد%" 
and page_id not in (select cl_from from categorylinks where page_id = cl_from and cl_to like "وفيات_بعمر_%") 
and page_id in (select cl_from from categorylinks where page_id = cl_from and cl_to like "وفيات_%")  limit 50;

SQL

Checking query status...