Untitled query #32978

SQL

use wikidatawiki_p;
select page_title
from page
where page_is_redirect = 0
and page_content_model = "wikibase_item"
and (select pp_value from page_props where pp_page = page_id and pp_propname = "wb_claims") = 0
and (select pp_value from page_props where pp_page = page_id and pp_propname = "wb_identifiers") = 0
and (select pp_value from page_props where pp_page = page_id and pp_propname = "wb-sitelinks") = 0 
/*and page_title in (select term_full_entity_id from wb_terms where term_full_entity_id = page_title and term_language = "ar" 
               and term_type = "label"
               and term_entity_type = "item")*/
               limit 10;
SQL

Checking query status...
