Replicas browser and optimizer
This query is marked as a draft
This query has been published
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-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;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in