مقالات تحتوي على تصانيف عامة تحتاج لإزالة؛ لاحتوائها على تصنيف تخصصي أكثر

SQL

SELECT p1.page_title, group_concat(cl3.cl_to)

from page p1

inner join categorylinks cl1
on p1.page_id = cl_from

inner join page p2
on p2.page_title = cl1.cl_to

inner join categorylinks cl3
on cl3.cl_from = p2.page_id

where p1.page_namespace = 0
and p1.page_is_redirect = 0

and p2.page_namespace = 14
and p2.page_is_redirect = 0

and p2.page_id not in (select cl_from from categorylinks where cl_to = "صفحات_توضيح")
and p2.page_id not in (select cl_from from categorylinks where cl_to = "تصنيفات_مخفية")
and cl1.cl_to not like "صفحات_توضيح"
and cl3.cl_to in (select cl_to from categorylinks where cl_from = p1.page_id)
group by p1.page_title
having (group_concat(cl1.cl_to) like concat("%",cl3.cl_to , ",%")
       or group_concat(cl1.cl_to) like concat("%,",cl3.cl_to, "%"))
limit 1000;

SQL

Checking query status...