Untitled query #40502

SQL

use arwiki_p;
select p.page_title, group_concat(p2.page_title SEPARATOR '***') as cats
    from page p
    inner join langlinks l1
    on l1.ll_from = p.page_id
    inner join  arwiki_p.page
    on  arwiki_p.page.page_title = replace(l1.ll_title, " ", "_")
    inner join  arwiki_p.langlinks el
    on p2.page_id  = el.ll_from
    where p.page_is_redirect = 0
    and p.page_namespace = 0
    and  arwiki_p.page.page_namespace = 0
    and  arwiki_p.page.page_is_redirect = 0
    and p2.page_is_redirect = 0
    and p2.page_namespace = 14
    and l1.ll_lang like "ar"
    and el.ll_lang like "ar"
    group by p.page_title;
SQL

Checking query status...
