053

• License: https://www.gnu.org/licenses/gpl-3.0

• Uses method in: https://github.com/WDscholia/scholia/tree/master/scholia/app/templates/clinical-trial_related-trials.sparql

rq turtle/ttl

Clinical-trial aspect: related trials

Use at

• https://query.wikidata.org/sparql

PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://wikidata.org/entity/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX target: <http://www.wikidata.org/entity/Q64651365>

SELECT
  ?score
  ?trial ?trialLabel
WHERE {
  {
    SELECT
      (SUM(?score_) AS ?score)
      ?trial
    WHERE {
      BIND(target: AS ?query_trial)
      ?trial wdt:P31 wd:Q30612 .
      { 
        ?query_trial wdt:P1050 / ^wdt:P1050 ?trial .
        BIND(3 AS ?score_)
      }
      UNION 
      {
        ?query_trial wdt:P4844 / ^wdt:P4844 ?trial .
        BIND(2 AS ?score_)        
      }
      UNION 
      {
        ?query_trial wdt:P859 / ^wdt:P859 ?trial .
        BIND(1 AS ?score_)        
      }
    }
    GROUP BY ?trial
    ORDER BY DESC(?score)
    LIMIT 500
  }
  FILTER (target: != ?trial)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . }
}
ORDER BY DESC(?score)

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v3("?query_trial")
  v5("?score"):::projected 
  v5("?score_")
  v2("?trial"):::projected 
  a1((" "))
  a2((" "))
  a3((" "))
  c3([http://wikidata.org/entity/Q30612]):::iri 
  c8([http://www.bigdata.com/rdf#serviceParam]):::iri 
  c10(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal 
  f0[["'wd:Q64651365' != ?trial"]]
  f0 --> v2
  bind1[/"'wd:Q64651365'"/]
  bind1 --as--o v3
  v2 --"p:direct/P31"-->  c3
  subgraph union0[" Union "]
  subgraph union0l[" "]
    style union0l fill:#abf,stroke-dasharray: 3 3;
    subgraph union1[" Union "]
    subgraph union1l[" "]
      style union1l fill:#abf,stroke-dasharray: 3 3;
      v3 --"p:direct/P859"-->  a3
      v2 --"p:direct/P859"-->  a3
      bind2[/"'1^^xsd:integer'"/]
      bind2 --as--o v5
    end
    subgraph union1r[" "]
      style union1r fill:#abf,stroke-dasharray: 3 3;
      v3 --"p:direct/P4844"-->  a2
      v2 --"p:direct/P4844"-->  a2
      bind3[/"'2^^xsd:integer'"/]
      bind3 --as--o v5
    end
    union1r <== or ==> union1l
    end
  end
  subgraph union0r[" "]
    style union0r fill:#abf,stroke-dasharray: 3 3;
    v3 --"p:direct/P1050"-->  a1
    v2 --"p:direct/P1050"-->  a1
    bind4[/"'3^^xsd:integer'"/]
    bind4 --as--o v5
  end
  union0r <== or ==> union0l
  end
  bind6[/"sum(?score_)"/]
  v5 --o bind6
  bind6 --as--o v5
  subgraph s1["http://wikiba.se/ontology#label"]
    style s1 stroke-width:4px;
    c8 --"wikibase:language"-->  c10
  end