بوابات للتصانيف

SQL

use arwiki_p;
select p1.page_title
from page p1
inner join langlinks ll1
on ll1.ll_from = p1.page_id
inner join frwiki_p.page p2
on p2.page_title = ll1.ll_title
inner join frwiki_p.pagelinks pl1
on pl1.pl_from = p2.page_id
inner join langlinks ll2
on ll2.ll_from = pl1.pl_from
where p1.page_namespace = 14
and p1.page_is_redirect = 0
and p2.page_namespace = 14
and p2.page_is_redirect = 0
and ll1.ll_lang = "fr"
and pl1.pl_from_namespace = 100
and pl1.pl_namespace = 14
and ll2.ll_lang = "ar"
/*and replace(ll2.ll_title," ","_") not in (select pl_title from pagelinks where pl_title = replace(ll2.ll_title," ","_"))*/
limit 10;
SQL

Checking query status...
