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 page_id = ll_from
and ll_lang = "ar"
and tl_namespace = 10 #and tl_from_namespace=0
and tl_title = "Fooian_fooers"
/*
#from bgwiki_p.page
#join bgwiki_p.categorylinks c1 on page_id=c1.cl_from and page_title like "%(пояснение)"
from srwiki_p.page
join srwiki_p.categorylinks c1 on page_id=c1.cl_from and page_title not like "%(вишезначна_одредница)"
and c1.cl_to = "Вишезначна_одредница"
and page_is_redirect = 0 AND page_namespace = 0
  )
and pp_value is not NULL
AND ll_title IS NULL
*/
LIMIT 100
SQL

Checking query status...
