Untitled query #22856

SQL

use enwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
join page p on p.page_id=l.ll_from
where p.page_namespace=0 and p.page_title in (select pla.page_title
                from categorylinks cla
                join page pla on cla.cl_from=pla.page_id
                where pla.page_namespace=1 and cla.cl_type="page" 
                                              and cla.cl_to="Top-importance_A_Song_of_Ice_and_Fire_articles"
                                              or cla.cl_to="High-importance_A_Song_of_Ice_and_Fire_articles"
                                             or cla.cl_to="Mid-importance_A_Song_of_Ice_and_Fire_articles"
                                             or cla.cl_to="Low-importance_A_Song_of_Ice_and_Fire_articles"
                                             or cla.cl_to="NA-importance_A_Song_of_Ice_and_Fire_articles"
                                             or cla.cl_to="Unknown-importance_A_Song_of_Ice_and_Fire_articles")
and l.ll_from in (select m.ll_from from langlinks m where m.ll_lang="ar")
and l.ll_lang="ar"
group by l.ll_from
SQL

Checking query status...
