test cross wiki

SQL

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

and page_id = ll_from
and ll_lang = "ar"

#from bgwiki_p.page
#join bgwiki_p.categorylinks c1 on page_id=c1.cl_from and page_title like "%(пояснение)"
from arwiki_p.page
join arwiki_p.templatelinks c1 on page_id = c1.tl_from and c1.tl_title = "أشخاص_حسب_المهنة"
  )

LIMIT 100
SQL

Checking query status...
