query-028372c0329f44f9995c37820c1ce6b9

rq turtle/ttl

TODO

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 ?label ?item ?pmcid ?doi ?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].
  MINUS { ?item wdt:P2860 [] }
  ?item wdt:P577 ?date.
  OPTIONAL { 
    ?item wdt:P932 ?pmcid.
  }
  OPTIONAL { 
    ?item wdt:P356 ?doi.
  }
  ?item rdfs:label ?label.
  FILTER(lang(?label) = 'en' && !STRENDS(?doi, 'PDB'))
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?date"):::projected v2("?doi"):::projected v5("?item"):::projected v1("?label"):::projected v7("?pmcid"):::projected v3("?pw") v4("?top") a3((" ")) a1((" ")) a2((" ")) f0[["?label = 'en'not ends-with(?doi,'PDB')"]] f0 --> v1 f0 --> v2 bind1[/VALUES ?pw/] bind1-->v3 bind10(["wd:Q82069695"]) bind10 --> bind1 bind2[/VALUES ?top/] bind2-->v4 bind20(["wd:Q7202"]) bind20 --> bind2 bind21(["wd:Q128406"]) bind21 --> bind2 bind22(["wd:Q908902"]) bind22 --> bind2 a1 --"p:statement/P921"--> v3 v5 --"p:P921"--> a1 a2 --"p:statement/P921"--> v4 v5 --"p:P921"--> a2 subgraph minus3["MINUS"] style minus3 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P2860"--> a3 end v5 --"p:direct/P577"--> v6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P932".-> v7 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:direct/P356".-> v2 end v5 --"rdfs:label"--> v1