نساء ليس لهم وصلات في اللغة العربية

SQL

use wikidatawiki_p;
select page_title, (select count(term_full_entity_id) 
                       from wb_terms 
                       where term_entity_type = "item" 
                       and term_type = "label"
                       and term_full_entity_id = page_title) as "noll"
from page
inner join pagelinks
on pl_from = page_id
where page_namespace = 0
and page_is_redirect = 0
and pl_namespace = 0
and pl_from_namespace = 0
and pl_title = "Q6581072"
and page_title not in (select term_full_entity_id 
                       from wb_terms 
                       where term_entity_type = "item" 
                       and term_language = "ar" 
                       and term_type = "label"
                       and term_full_entity_id = page_title)
and "noll" > 2
limit 500000;

SQL

Checking query status...