Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Aram
.
Toggle Highlighting
SQL
SELECT DISTINCT p.page_title FROM page p JOIN categorylinks cl ON p.page_id = cl.cl_from WHERE cl.cl_to = 'زیندووان' AND p.page_id IN ( SELECT DISTINCT pp_page FROM page_props pp WHERE pp.pp_propname = 'wikibase_item' AND pp.pp_value IN ( SELECT DISTINCT wd1.wb_entity_id FROM wb_items_per_site wd1 LEFT JOIN wb_terms wt ON wd1.wb_entity_id = wt.wb_entity_id WHERE wd1.wb_entity_id IS NOT NULL AND wt.wb_term_entity_type = 'item' AND wt.wb_term_language = 'ckb' AND wd1.wb_site_id = 'ckbwiki' AND wd1.wb_entity_id IN ( SELECT DISTINCT wd2.wb_entity_id FROM wb_claims wd2 WHERE wd2.wb_property_id = 'P570' ) ) );
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...