query-fe4b65d7402754fc6fb4bc20ba3be8be

rq turtle/ttl

SPARQL code to find items in an arbitrary administrative unit, called Q800000000,

using the proposed qualifier, called P8000

SELECT ?item WHERE { VALUES ?searched_unit { wd:Q800000000 } { ?item wdt:P131 ?searched_unit . # located in the searched unit } MINUS { ?item wdt:P131/p:P131/pq:P8000 ?other_unit . # unless next level in hierarchy is a unit ?other_unit wdt:P131/^wdt:P131 ?searched_unit . # at same level in the hierarchy FILTER (?other_unit != ?searched_unit) # and different from the sought unit } }

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
# SPARQL code to find items in an arbitrary administrative unit, called Q800000000,
# using the proposed qualifier, called P8000
SELECT ?item
WHERE
{
  VALUES ?searched_unit { wd:Q800000000 }
  {
    ?item wdt:P131* ?searched_unit .                 # located in the searched unit 
  }
  MINUS
  {
    ?item wdt:P131*/p:P131/pq:P8000 ?other_unit .    # unless next level in hierarchy is a unit
    ?other_unit wdt:P131/^wdt:P131 ?searched_unit .  # at same level in the hierarchy
    FILTER (?other_unit != ?searched_unit)           # and different from the sought unit
  }
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Property_proposal/hierarchy_switch