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

SQL

use wikidatawiki_p;
/*select wb1.term_text, (select wb2.term_text from wb_terms wb2 where wb2.term_type = "label" and wb2.term_full_entity_id = wb1.term_full_entity_id and term_language = "ar")
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 arwiki_p.page.page_is_redirect = 1)
and wb1.term_type = "alias"
limit 10;*/
select * from wb_items_per_site limit 100;

SQL

Checking query status...