query-6f443641b9640701b299cb09450f3b24

rq turtle/ttl

Feddes Repertorium Specierum Novarum Regni Vegetabilis (Q5550932)

Use at

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 ?lang ?title WHERE {  
  ?item wdt:P1433 wd:Q5550932 .
  OPTIONAL {?item wdt:P577 ?published1} .
  OPTIONAL {?item wdt:P478 ?volume} .
  OPTIONAL {?item wdt:P433 ?issue0} .
  OPTIONAL {?item wdt:P304 ?pages0} . 
  OPTIONAL {?item wdt:P356 ?doi} .
  OPTIONAL {?item wdt:P1476 ?title} . 
  BIND(LANG(?title) AS ?lang)
  BIND(REPLACE(?pages0, "-", "–") AS ?pages)
  BIND(REPLACE(?issue0, "-", "–") AS ?issue)
  BIND(if(contains(?pages,  "–"), strbefore(?pages, "–"), ?pages) as ?startpage)
  BIND(if(contains(?pages,  "–"), strafter(?pages, "–"), ?pages) as ?endpage)
  BIND(if(contains(?issue,  "–"), strbefore(?issue, "–"), ?issue) as ?startissue)
  #FILTER (strStarts(?title, "(")) 
}
ORDER BY ASC(xsd:integer(?volume)) ASC(xsd:integer(?startissue)) ASC(xsd:integer(?startpage))

Query found at

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