query-031a35d44a00c0f0a40627ad1ca41a3c

rq turtle/ttl

All former municipalities of Switzerland

MINUS those who also have a "current statement"

should be empty (all Q685309 should also be Q70208)

SELECT * WITH { # select all that have both current AND former SELECT ?item WHERE { hint:Query hint:optimizer "None" . ?item wdt:P31 wd:Q685309 . ?item wdt:P31 wd:Q70208 } } as %muni WHERE { ?item wdt:P31 wd:Q685309 . MINUS { include %muni } # subtract those with qualifier from all Q685309 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de" }
}

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 bd: <http://www.bigdata.com/rdf#>
# All former municipalities of Switzerland 
# MINUS those who also have a "current statement" 
# should be empty (all  Q685309 should also be Q70208)
SELECT * 
WHERE
{
   ?item wdt:P31 wd:Q685309 .
   MINUS { 
{
    # select all that have both current AND former 
    SELECT ?item WHERE {

         ?item wdt:P31 wd:Q685309 .
         ?item wdt:P31 wd:Q70208
    } 
}} # subtract those with qualifier from all Q685309
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de"  }  
}

Query found at

• https://www.wikidata.org/wiki/User:Hannes_R%C3%B6st/Queries/Swiss_Municipalities