تحويلات من ويكي بيانات

SQL

use wikidatawiki_p;
select wb1.term_text, (select ips_site_page from wb_items_per_site where ips_site_id = "arwiki" and ips_item_id = wb1.term_entity_id)
from wb_terms wb1
where wb1.term_language = "ar"
and replace(wb1.term_text," ","_") not in (select arwiki_p.page.page_title from arwiki_p.page where arwiki_p.page.page_namespace = 0)
and wb1.term_text not like "%:%"
and (select ips_site_page from wb_items_per_site where ips_site_id = "arwiki" and ips_item_id = wb1.term_entity_id) not like "%:%"
and wb1.term_type = "alias";

SQL

Checking query status...