query-d620166e112f154f11c68e456a0c84d4

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item (SUBSTR(?published1, 1, 10) as ?published )?volume ?issue ?pages ?doi ?pubMedId ?title WHERE {  
  VALUES ?journalItems {wd:Q26827892 wd:Q26827884 wd:Q3511931} .
  ?item wdt:P1433 ?journalItems .  
  OPTIONAL {?item wdt:P577 ?published1} .
  OPTIONAL {?item wdt:P478 ?volume} .
  OPTIONAL {?item wdt:P433 ?issue} .
  OPTIONAL {?item wdt:P304 ?pages0} . 
  OPTIONAL {?item wdt:P356 ?doi} .
  OPTIONAL {?item wdt:P698 ?pubMedId} .  
  OPTIONAL {?item wdt:P1476 ?title} . 
  BIND(REPLACE(?pages0, "-", "–") AS ?pages)
  BIND(if(contains(?pages,  "–"), strbefore(?pages, "–"), ?pages) as ?startpage)
  BIND(if(contains(?pages,  "–"), strafter(?pages, "–"), ?pages) as ?endpage)
  FILTER (contains(lcase(?title), "gen. nov."))
  #FILTER (contains(lcase(?title), "sp. nov."))
  #FILTER (contains(lcase(?title), "subsp. nov."))
  #FILTER (contains(lcase(?title), "comb. nov."))
  #FILTER (contains(lcase(?title), "candidatus"))
}
ORDER BY ASC(?published) ASC(xsd:integer(?issue)) ASC(xsd:integer(?startpage))

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?doi"):::projected v13("?endpage") v2("?issue"):::projected v6("?item"):::projected v5("?journalItems") v12("?pages"):::projected v9("?pages0") v11("?pubMedId"):::projected v14("?published") v7("?published1"):::projected v13("?startpage") v4("?title"):::projected v8("?volume"):::projected f0[["contains(lower-case(?title),'gen. nov.')"]] f0 --> v4 bind1[/VALUES ?journalItems/] bind1-->v5 bind10(["wd:Q26827892"]) bind10 --> bind1 bind11(["wd:Q26827884"]) bind11 --> bind1 bind12(["wd:Q3511931"]) bind12 --> bind1 v6 --"wdt:P1433"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P577".-> v7 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P478".-> v8 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P433".-> v2 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P304".-> v9 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P356".-> v10 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P698".-> v11 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P1476".-> v4 end bind2[/"replace(?pages0,'-','–')"/] v9 --o bind2 bind2 --as--o v12 bind3[/"if(contains(?pages,'–'),substring-before(?pages,'–'),?pages)"/] v12 --o bind3 bind3 --as--o v13 bind4[/"if(contains(?pages,'–'),substring-after(?pages,'–'),?pages)"/] v12 --o bind4 bind4 --as--o v13 bind5[/"substring(?published1,'1^^xsd:integer','10^^xsd:integer')"/] v7 --o bind5 bind5 --as--o v14