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_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
                      )
#and ar.page_title = ll_title
#and ll_title = ar.page_title



LIMIT 100
SQL

Checking query status...
