query-f74b3a60004aab97485ebba1ea5ba667

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 prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?label ?item ?pmcid ?doi ?date
{
  VALUES ?pw { wd:Q1052913 }
  VALUES ?top { wd:Q128406 wd:Q908902 wd:Q4118894 wd:Q3933202 wd:Q14916420 wd:Q27108123 wd:Q898362 wd:Q14818042 wd:Q22244941 wd:Q11053 wd:Q24784703 wd:Q115694203 wd:Q24769547 wd:Q115694320 wd:Q115694242 wd:Q115694145 wd:Q115694310 wd:Q115694288 wd:Q115694380 wd:Q115694277 wd:Q24773028 }
  ?item p:P921 [ ps:P921 ?pw].
  ?item p:P921 [ ps:P921 ?top].
  MINUS { ?item wdt:P921 wd:Q177005 }
  { MINUS { ?item wdt:P2860 [] } }
  UNION
  {
    ?item p:P2860 [ prov:wasDerivedFrom [ pr:P248 wd:Q107507940 ]].
    MINUS { ?item p:P2860 [ prov:wasDerivedFrom [ pr:P248 wd:Q5188229 ]] }
  }
  ?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((" ")) a5((" ")) a4((" ")) a7((" ")) a6((" ")) c9(["wd:Q107507940"]):::iri c12(["wd:Q5188229"]):::iri c6(["wd:Q177005"]):::iri f0[["?label = 'en'not ends-with(?doi,'PDB')"]] f0 --> v1 f0 --> v2 bind1[/VALUES ?pw/] bind1-->v3 bind10(["wd:Q1052913"]) 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:Q24784703"]) bind210 --> bind2 bind211(["wd:Q115694203"]) bind211 --> bind2 bind212(["wd:Q24769547"]) bind212 --> bind2 bind213(["wd:Q115694320"]) bind213 --> bind2 bind214(["wd:Q115694242"]) bind214 --> bind2 bind215(["wd:Q115694145"]) bind215 --> bind2 bind216(["wd:Q115694310"]) bind216 --> bind2 bind217(["wd:Q115694288"]) bind217 --> bind2 bind218(["wd:Q115694380"]) bind218 --> bind2 bind219(["wd:Q115694277"]) bind219 --> bind2 bind220(["wd:Q24773028"]) bind220 --> 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/P921"--> c6 end subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; a4 --"p:reference/P248"--> c9 a5 --"prov:wasDerivedFrom"--> a4 v5 --"p:P2860"--> a5 subgraph minus4["MINUS"] style minus4 stroke-width:6px,fill:pink,stroke:red; a6 --"p:reference/P248"--> c12 a7 --"prov:wasDerivedFrom"--> a6 v5 --"p:P2860"--> a7 end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; subgraph minus5["MINUS"] style minus5 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P2860"--> a3 end end union0r <== or ==> union0l 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