query-38b62e9d9e415f2602402538d003313e

rq turtle/ttl

historic county or not in Scotland. Could someone who knows more about Scottish administrative regions ensure that (Q7309443)registration county but some council areas which are not the historic county entries are considered to be a (Q67376938)historic county of the United Kingdom which is a (Q1350181)shire of Scotland is a (Q7309443)registration county When requesting a list of historic counties in the UK I got some Scottish entries twice because

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?itemDescription WHERE {
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en-GB,en". } 
  { 
    SELECT DISTINCT ?item WHERE { 
      ?item p:P31 ?statement0. 
      ?statement0 (ps:P31/(wdt:P279*)) wd:Q67770276. 
      ?item p:P17 ?statement1. 
      ?statement1 (ps:P17/(wdt:P279*)) wd:Q145. 
    } 
  } 
}

Query found at

• https://www.wikidata.org/wiki/Talk:Q7309443