بوابات من بوابات التصانيف

SQL

use arwiki_p;
select p1.page_title, (select group_concat(distinct cl2.pl_title) 
                    from categorylinks cl1
                    inner join page p2
                    on p2.page_title = cl1.cl_to
                    inner join pagelinks cl2
                    on cl2.pl_from = p2.page_id
                    where cl1.cl_from = p1.page_id
                    and p2.page_namespace = 14
                    and p2.page_is_redirect = 0
                    and pl_from_namespace = 14
                    and pl_namespace = 100
                    and p2.page_id not in (select cl_from from categorylinks where cl_from = p2.page_id and cl_to = "تصنيفات_مخفية")
                       and cl2.pl_title in (select page_title from page where page_namespace = 100)
                    )
from page p1
inner join categorylinks
on cl_from = p1.page_id
where p1.page_namespace = 0
and p1.page_is_redirect = 0
and cl_to = "مقالات_بحاجة_لشريط_بوابات"
and (select group_concat(distinct cl2.pl_title) 
                    from categorylinks cl1
                    inner join page p2
                    on p2.page_title = cl1.cl_to
                    inner join pagelinks cl2
                    on cl2.pl_from = p2.page_id
                    where cl1.cl_from = p1.page_id
                    and p2.page_namespace = 14
                    and p2.page_is_redirect = 0
                    and pl_from_namespace = 14
                    and pl_namespace = 100
                    and p2.page_id not in (select cl_from from categorylinks where cl_from = p2.page_id and cl_to = "تصنيفات_مخفية")
                       and cl2.pl_title in (select page_title from page where page_namespace = 100)
                    ) <> "";
SQL

Checking query status...
