query-34aa90e465ff67b4972a87be4625bd83

rq turtle/ttl

Bergey's Manual of Systematics of Archaea and Bacteria (Q55953029)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item ?doi (SUBSTR(?published1, 1, 10) as ?published) ?pages ?title WHERE {  
  ?item wdt:P1433 wd:Q55953029 .
  ?item wdt:P356 ?doi . 
  OPTIONAL {?item wdt:P577 ?published1} .
  OPTIONAL {?item wdt:P478 ?volume} .
  OPTIONAL {?item wdt:P433 ?issue} .
  OPTIONAL {?item wdt:P304 ?pages0} . 
  OPTIONAL {?item wdt:P1476 ?title} .
  BIND(REPLACE(?pages0, "-", "–") AS ?pages) 
  BIND(strbefore(?pages, "–") as ?startpage) 
  BIND(strafter(?pages, "–") as ?endpage) 
}
ORDER BY ASC(?doi)

Query found at

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