query-09c27f6e2733c7ce90c129fb8a169f5b

rq turtle/ttl

PropertiesCIViC variant ID (P3329)positive therapeutic predictor for (P3354)statement disputed by (P1310)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?civic ?value ?valueLabel ?disputed_by WHERE {
  ?item wdt:P3329 ?civic ;  # find items that have a civic id
        p:P3354 ?id .  # get "positive therapeutic predictor" statements
  ?id ?b ?value .  # get the object used in these statements
  FILTER(regex(str(?b), "http://www.wikidata.org/prop/statement" ))
  # FILTER NOT EXISTS {?id pq:P1310 ?disputed_by } # filter out statements that have a disputing qualifier
  BIND(EXISTS {?id pq:P1310 [] } as ?disputed_by)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?b") v3("?civic"):::projected v6("?disputed_by"):::projected v4("?id") v2("?item"):::projected v5("?value"):::projected c5(["bd:serviceParam"]):::iri c7(["en"]):::literal f0[["regex(str(?b),'http://www.wikidata.org/prop/statement')"]] f0 --> v1 v2 --"p:direct/P3329"--> v3 v2 --"p:P3354"--> v4 v4 -->v1--> v5 v4 --"p:qualifier/P1310"--> null bind1[/" "/] subgraph bind1e0["Exists Clause"] e0v1 --"p:qualifier/P1310"--> e0a1 e0v1("?id"):::projected e0a1((" ")):::projected end bind1--EXISTS--> bind1e0 v4 --o bind1 null --o bind1 null --o bind1 bind1 --as--o v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c5 --"wikibase:language"--> c7 end