query-00d8d863b93ca208e2a41dd87e074a53

added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000 added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel WHERE { ?item wdt:P17 ?country. MINUS { ?country wdt:P31/wdt:P279 wd:Q7275. } # excludes normal countries MINUS { ?country wdt:P31/wdt:P279 wd:Q183366. } # excludes Scotland MINUS { ?country wdt:P31/wdt:P279 wd:Q15893266. } # excludes Brittany MINUS { ?country wdt:P31/wdt:P279 wd:Q1048835. } # excludes the European Union SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 1000

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#>
#added before 2016-10

SELECT ?item ?country ?itemLabel ?countryLabel
WHERE
{
  ?item wdt:P17 ?country.
  MINUS { ?country wdt:P31/wdt:P279* wd:Q7275. }     # excludes normal countries
  MINUS { ?country wdt:P31/wdt:P279* wd:Q183366. }   # excludes Scotland
  MINUS { ?country wdt:P31/wdt:P279* wd:Q15893266. } # excludes Brittany
  MINUS { ?country wdt:P31/wdt:P279* wd:Q1048835. }  # excludes the European Union
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 1000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?country"):::projected v1("?item"):::projected a1((" ")) a2((" ")) a3((" ")) a4((" ")) c6(["wd:Q15893266"]):::iri c9(["bd:serviceParam"]):::iri c4(["wd:Q7275"]):::iri c11(["en"]):::literal c7(["wd:Q1048835"]):::iri c5(["wd:Q183366"]):::iri v1 --"wdt:P17"--> v2 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c4 end subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P31"--> a2 a2 --"wdt:P279"--> c5 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P31"--> a3 a3 --"wdt:P279"--> c6 end subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P31"--> a4 a4 --"wdt:P279"--> c7 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end