query-e39f770693dd55c635d319bb8ec282ba

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:Q164778 }
  VALUES ?top { wd:Q128406 wd:Q908902 wd:Q4118894 wd:Q3933202 wd:Q14916420 wd:Q27108123 wd:Q898362 wd:Q14818042 wd:Q22244941 wd:Q11053 wd:Q83133549 wd:Q24745872 wd:Q24770641 wd:Q81490100 wd:Q24774064 wd:Q24773176 wd:Q24724262 wd:Q24719751 wd:Q24785520 wd:Q24726417 wd:Q24739451 wd:Q24782928 }
  ?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'))
}

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:Q164778"]) bind10 --> bind1 bind2[/VALUES ?top/] bind2-->v4 bind20(["wd:Q128406"]) bind20 --> bind2 bind21(["wd:Q908902"]) bind21 --> bind2 bind22(["wd:Q4118894"]) bind22 --> bind2 bind23(["wd:Q3933202"]) bind23 --> bind2 bind24(["wd:Q14916420"]) bind24 --> bind2 bind25(["wd:Q27108123"]) bind25 --> bind2 bind26(["wd:Q898362"]) bind26 --> bind2 bind27(["wd:Q14818042"]) bind27 --> bind2 bind28(["wd:Q22244941"]) bind28 --> bind2 bind29(["wd:Q11053"]) bind29 --> bind2 bind210(["wd:Q83133549"]) bind210 --> bind2 bind211(["wd:Q24745872"]) bind211 --> bind2 bind212(["wd:Q24770641"]) bind212 --> bind2 bind213(["wd:Q81490100"]) bind213 --> bind2 bind214(["wd:Q24774064"]) bind214 --> bind2 bind215(["wd:Q24773176"]) bind215 --> bind2 bind216(["wd:Q24724262"]) bind216 --> bind2 bind217(["wd:Q24719751"]) bind217 --> bind2 bind218(["wd:Q24785520"]) bind218 --> bind2 bind219(["wd:Q24726417"]) bind219 --> bind2 bind220(["wd:Q24739451"]) bind220 --> bind2 bind221(["wd:Q24782928"]) bind221 --> 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