query-c5b8b1a05b7863801aadf58023bd9093

rq turtle/ttl

SARS-Cov-2

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?ref ?refLabel ?date
{
  VALUES ?pw { wd:Q82069695 }
  VALUES ?top { wd:Q7202 wd:Q128406 wd:Q908902 }
  ?item p:P921 [ ps:P921 ?pw].
  ?item p:P921 [ ps:P921 ?top].
  ?item wdt:P2860 ?ref.
#  MINUS { 
#    ?ref wdt:P921 ?pw.
#  }
  MINUS { ?ref wdt:P921 wd:Q7202 }
  MINUS { ?ref wdt:P921 wd:Q128406 }
  MINUS { ?ref wdt:P921 wd:Q128570 }
  MINUS { ?ref wdt:P921 wd:Q908902 }
  MINUS { ?ref wdt:P921 wd:Q6926073 }
  MINUS { ?ref wdt:P921 wd:Q88161067 }
  ?ref rdfs:label ?refLabel.
  FILTER(LANG(?refLabel) = 'en' && (CONTAINS(STR(?refLabel), 'SARS')|| CONTAINS(STR(?refLabel), 'severe') || CONTAINS(STR(?refLabel), 'COVID'))).
  ?ref wdt:P577 ?date.
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?date"):::projected v4("?item") v2("?pw") v5("?ref"):::projected v1("?refLabel"):::projected v3("?top") a1((" ")) a2((" ")) c10(["wd:Q128406"]):::iri c11(["wd:Q128570"]):::iri c12(["wd:Q908902"]):::iri c14(["wd:Q88161067"]):::iri c9(["wd:Q7202"]):::iri c13(["wd:Q6926073"]):::iri f0[["?refLabel = 'en'(contains(str(?refLabel),'SARS') || (contains(str(?refLabel),'severe') || contains(str(?refLabel),'COVID')))"]] f0 --> v1 bind1[/VALUES ?pw/] bind1-->v2 bind10(["wd:Q82069695"]) bind10 --> bind1 bind2[/VALUES ?top/] bind2-->v3 bind20(["wd:Q7202"]) bind20 --> bind2 bind21(["wd:Q128406"]) bind21 --> bind2 bind22(["wd:Q908902"]) bind22 --> bind2 a1 --"p:statement/P921"--> v2 v4 --"p:P921"--> a1 a2 --"p:statement/P921"--> v3 v4 --"p:P921"--> a2 v4 --"p:direct/P2860"--> v5 subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P921"--> c9 end subgraph minus4["MINUS"] style minus4 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P921"--> c10 end subgraph minus5["MINUS"] style minus5 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P921"--> c11 end subgraph minus6["MINUS"] style minus6 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P921"--> c12 end subgraph minus7["MINUS"] style minus7 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P921"--> c13 end subgraph minus8["MINUS"] style minus8 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P921"--> c14 end v5 --"rdfs:label"--> v1 v5 --"p:direct/P577"--> v6