Untitled query #34350

SQL

use arwiki_p;
select p1.page_title,cl4.cl_to
from page p1
inner join categorylinks cl1
on cl1.cl_from = p1.page_id
inner join categorylinks cl2
on cl2.cl_from = p1.page_id
inner join categorylinks cl3
on cl3.cl_to = cl2.cl_to
inner join categorylinks cl4
on cl4.cl_from = cl3.cl_from
inner join page p2
on p2.page_title = cl4.cl_to
where p1.page_namespace = 0
and p1.page_is_redirect = 0
and cl1.cl_to = "مقالات_بحاجة_لشريط_بوابات"
and cl4.cl_to like "%متعلقة%"
and p2.page_namespace = 14
and p2.page_is_redirect = 0
and p2.page_id not in (select cl_from from categorylinks where cl_from  = p2.page_id and cl_to = "تصنيفات_مخفية")
limit 100;
SQL

Checking query status...
