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 ll_title = ar.page_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...
