query-c95c7d7b95c03200628a021570f1035d

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 ?doi ?zoobankpub (substr(?published1, 1, 10) as ?published) ?issue ?pages ?title WHERE {  
  ?item wdt:P1433 wd:Q21386186 .
  ?item wdt:P356 ?doi .
  OPTIONAL {?item wdt:P577 ?published1} .
  OPTIONAL {?item wdt:P433 ?issue} .
  OPTIONAL {?item wdt:P304 ?pages0} . 
  OPTIONAL {?item wdt:P2007 ?zoobankpub} . 
  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)
}
ORDER BY ASC(xsd:integer(?issue)) ASC(xsd:integer(?startpage))

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?doi"):::projected v10("?endpage") v1("?issue"):::projected v3("?item"):::projected v9("?pages"):::projected v6("?pages0") v11("?published") v5("?published1"):::projected v10("?startpage") v8("?title"):::projected v7("?zoobankpub"):::projected c2(["wd:Q21386186"]):::iri v3 --"wdt:P1433"--> c2 v3 --"wdt:P356"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P577".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P433".-> v1 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P304".-> v6 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P2007".-> v7 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P1476".-> v8 end bind0[/"replace(?pages0,'-','–')"/] v6 --o bind0 bind0 --as--o v9 bind1[/"if(contains(?pages,'–'),substring-before(?pages,'–'),?pages)"/] v9 --o bind1 bind1 --as--o v10 bind2[/"if(contains(?pages,'–'),substring-after(?pages,'–'),?pages)"/] v9 --o bind2 bind2 --as--o v10 bind3[/"substring(?published1,'1^^xsd:integer','10^^xsd:integer')"/] v5 --o bind3 bind3 --as--o v11