query-d6007f0b0828fd3af37842d433c2cc35

rq turtle/ttl

Propertiesinstance of (P31)medical condition (P1050)subclass of (P279)start time (P580)research intervention (P4844)sponsor (P859)

Use at

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#>
SELECT
  DISTINCT
  ?start_date
  ?trial ?trialLabel
  ?intervention ?interventionLabel
  ?sponsor ?sponsorLabel
WHERE {
  ?trial wdt:P31 wd:Q30612 ;
  wdt:P1050 / wdt:P279* wd:Q84263196 .
  OPTIONAL {
    ?trial wdt:P580 ?starttime
    BIND(SUBSTR(STR(?starttime), 0, 11) AS ?start_date)
  }
  OPTIONAL { ?trial wdt:P4844 ?intervention }
  OPTIONAL { ?trial wdt:P859 ?sponsor }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,da,de,es,fr,jp,nl,no,pl,ru,sv,zh". }
}
ORDER BY DESC(?starttime)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?intervention"):::projected v5("?sponsor"):::projected v3("?start_date"):::projected v1("?starttime") v2("?trial"):::projected a1((" ")) c5(["wd:Q84263196"]):::iri c10(["bd:serviceParam"]):::iri c2(["wd:Q30612"]):::iri c12(["en,da,de,es,fr,jp,nl,no,pl,ru,sv,zh"]):::literal v2 --"wdt:P31"--> c2 v2 --"wdt:P1050"--> a1 a1 --"wdt:P279"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P580".-> v1 bind0[/"substring(str(?starttime),'0^^xsd:integer','11^^xsd:integer')"/] v1 --o bind0 bind0 --as--o v3 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P4844".-> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v2 -."wdt:P859".-> v5 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end