مقالات لأشخاص، تحتوي على أكثر من تصنيف لسنة الميلاد

SQL

SELECT page_title,
(select group_concat(cl_to) from categorylinks where cl_from = page_id and cl_to like "مواليد_%" and cl_to not like "مواليد_%هـ" and cl_to not like "%\_%\_%")
FROM page
where page_namespace = 0
and page_is_redirect = 0
and page_id in (select cl_from from categorylinks where cl_from = page_id and cl_to like "مواليد_%" and cl_to not like "مواليد_%هـ" and cl_to not like "%\_%\_%")
and (select count(*) from categorylinks where cl_from = page_id and cl_to like "مواليد_%" and cl_to not like "مواليد_%هـ" and cl_to not like "%\_%\_%") > 1
limit 100;

SQL

Checking query status...