Untitled query #37826

SQL

use arwiki_p;
select p.page_title, l2.ll_title
from page p
inner join categorylinks
on cl_from = p.page_id
inner join langlinks l1
on l1.ll_from = p.page_id
inner join enwiki_p.page p2
on p2.page_title = replace(l1.ll_title," ", "_")
inner join enwiki_p.templatelinks tl
on tl.tl_from = p2.page_id 
inner join enwiki_p.page p3
on p3.page_title = tl.tl_title
inner join enwiki_p.langlinks l2
on l2.ll_from = p3.page_id
where cl_to = "مقالات_بذور_عامة"
and tl.tl_title like "%-stub%"
and tl.tl_from_namespace = 0
and tl.tl_namespace = 10
and l1.ll_lang = "en"
and p2.page_namespace = 0
and p2.page_is_redirect = 0
and p3.page_is_redirect = 0
and p3.page_namespace = 10
and l2.ll_lang = "ar";
SQL

Checking query status...
