query-0c4c876518893ceb6f43d753b6f4d22e

rq turtle/ttl

For use with QuickStatements

1. Run the Query (change to correct date first) and download as CSV

2. Go to QuickStatements and put the following up top: qid,P1320,S3452,s1059,s813

3. Open the CSV file and copy all that stuff under "string" and paste it under the text inserted at step 2

4. Press "Import CSV commands"

SELECT (CONCAT(replace(str(?item),"http://www.wikidata.org/entity/", ""),',"""dk/', ?enhet,'""",Q795419,"""',?enhet,'""",+2022-01-20T00:00:00Z/11') as ?string) WHERE { ?item wdt:P1059 ?enhet. MINUS { ?item wdt:P1320 []. } MINUS { ?item wdt:P31 wd:Q163740.} MINUS { ?item wdt:P31 wd:Q157031.} }

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#For use with QuickStatements
# 1. Run the Query (change to correct date first) and download as CSV 
# 2. Go to QuickStatements and put the following up top: qid,P1320,S3452,s1059,s813
# 3. Open the CSV file and copy all that stuff under "string" and paste it under the text inserted at step 2
# 4. Press "Import CSV commands"
SELECT (CONCAT(replace(str(?item),"http://www.wikidata.org/entity/", ""),',"""dk/', ?enhet,'""",Q795419,"""',?enhet,'""",+2022-01-20T00:00:00Z/11') as ?string) WHERE {
  ?item wdt:P1059 ?enhet.
  MINUS { ?item wdt:P1320 []. }
  MINUS { ?item wdt:P31 wd:Q163740.}
  MINUS { ?item wdt:P31 wd:Q157031.}
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?enhet"):::projected v1("?item"):::projected v3("?string") a1((" ")) c4(["wd:Q163740"]):::iri c5(["wd:Q157031"]):::iri v1 --"wdt:P1059"--> v2 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P1320"--> a1 end subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P31"--> c4 end subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v1 --"wdt:P31"--> c5 end bind3[/"concat(replace(str(?item),'http://www.wikidata.org/entity/',''),',"""dk/',?enhet,'""",Q795419,"""',?enhet,'""",+2022-01-20T00:00:00Z/11')"/] v1 --o bind3 v2 --o bind3 bind3 --as--o v3