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 cl3.cl_to like "بوابة%متعلقة"
limit 100;
SQL

Checking query status...
