تصانيف جاهزة بحاجة لإنشاء من المقابل الإنجليزي حسب عنوان المقالة

SQL

use arwiki_p;
select page_title, ll_title, (select enwiki_p.page.page_id from enwiki_p.page where enwiki_p.page.page_title = ll_title
        and enwiki_p.page.page_namespace = 14 and enwiki_p.page.page_is_redirect) 
from page
inner join langlinks
on ll_from = page_id
where page_namespace = 0
and page_is_redirect = 0
and page_title not in (select page_title from page where page_namespace = 14 and page_title = page_title)
and ll_lang= "en"
and ll_title in (select enwiki_p.page.page_title from enwiki_p.page where enwiki_p.page.page_namespace = 14 and enwiki_p.page.page_title
                = ll_title
                and enwiki_p.page.page_is_redirect = 0)
and (
  		(select enwiki_p.page.page_id from enwiki_p.page where enwiki_p.page.page_title = ll_title
        and enwiki_p.page.page_namespace = 14 and enwiki_p.page.page_is_redirect) 
  		not in (select ll_from from langlinks where ll_lang = "ar")
    )
limit 100;

SQL

Checking query status...