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_title = ar.page_title
and ll_from = en.page_id
/*and ar.page_id not in (select tl_from 
                       from arwiki_p.templatelinks as ar_temp
                       where ar_temp.tl_title = "أشحاص_حسب_المهنة" 
                       and ar.page_id = ar_temp.tl_from
                      )
*/

LIMIT 100
SQL

Checking query status...
