query-c27fca28bde12c183876b4969d6be33d
Ivan A. Krestinin(Q634099)rural settlement in Russia (Q2661988)urban settlement in Russia
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?item #?level1Label ?level2Label ?level3Label
WHERE {
?item wdt:P31/wdt:P279*
#wd:Q634099 ;
#wd:Q2661988 ;
schema:description ?label ;
#wdt:P17 wd:Q159 ;
#wdt:P131 ?level1 .
#?level1 wdt:P131 ?level2 .
#?level2 wdt:P131 ?level3 .
#minus {?level2 wdt:P576 ?fin .}
#minus {?level3 wdt:P576 ?fin2 .}
FILTER(LANG(?label) IN ("en")).
filter regex (?label, "human settlement").
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}