test cross wiki

SQL

use enwiki_p;
select CONCAT("Category:",en.page_title) AS title, ll_title
from page as en, templatelinks as en_temp, langlinks , arwiki_p.page as ar
where en.page_namespace = 14
and en.page_id = en_temp.tl_from
and en_temp.tl_namespace = 10 #and tl_from_namespace=0
and en_temp.tl_title = "Fooian_fooers"

and ll_lang = "ar"
and ll_from = en.page_id

and ar.page_title = ll_title
and ar.page_id = ll_from
and ar.page_namespace = 0 
and ar.page_id not in (select ar_temp.tl_from 
                       from arwiki_p.templatelinks as ar_temp
                       where ar_temp.tl_title = "أشحاص_حسب_المهنة" 
                       and ll_from = ar_temp.tl_from
                      )
#and ll_title = ar.page_title
/*and ll_title in (select ar.page_title
                from arwiki_p.templatelinks ar_temp
                join arwiki_p.page ar on ar_temp.tl_from=ar.page_id# and ar_temp.tl_from_Народные артисты СССР
                where ar.page_namespace=0
                     and ar_temp.tl_title="أشحاص_حسب_المهنة")*/
/*
and ll_title in (select ar.page_title
                from arwiki_p.page ar
                where ll_title = ar.page_title# and ar_temp.tl_from_Народные артисты СССР
                and ar.page_namespace = 0
                 and ar.page_id in (select ar_temp.tl_from 
                       from templatelinks as ar_temp
                       where ar_temp.tl_title = "أشحاص_حسب_المهنة" 
                       and ll_from = ar_temp.tl_from
                      )
                #and ar_temp.tl_title="أشحاص_حسب_المهنة"
                )*/
                     
/*and ll_from not in (select ar_temp.tl_from 
                       from arwiki_p.templatelinks as ar_temp
                       where ar_temp.tl_title = "أشحاص_حسب_المهنة" 
                       and ll_from = ar_temp.tl_from
                      )*/


LIMIT 100
SQL

Checking query status...
