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

SQL

use arwiki_p;
select p1.page_title, (select (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 = "تصنيفات_مخفية")
                    limit 1) as "portal"
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 portal <> ""
limit 10;
SQL

Checking query status...
