query-8394cca706862a203483de5a854485a9

rq turtle/ttl

BHL bibliography ID (P4327): List

Use at

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#>
SELECT ?item ?publicationId ?title (YEAR(?published) as ?year) ?instanceOfLabel WHERE {
   ?item wdt:P4327 ?publicationId .
   ?item wdt:P31 ?instanceOf . 
   OPTIONAL {?item wdt:P1476 ?title} .
   OPTIONAL {?item wdt:P577 ?published} .
   OPTIONAL {?instanceOf rdfs:label ?instanceOfLabel . FILTER(lang(?instanceOfLabel)="en")}
   #BIND(wd:Q732577 AS ?publicationType) # publication
   BIND(wd:Q5633421 AS ?publicationType) # scientific journal
   FILTER(sameTerm(?instanceOf, ?publicationType))
}
ORDER BY ASC(?instanceOfLabel) ASC(?title)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?instanceOf") v1("?instanceOfLabel"):::projected v5("?item"):::projected v6("?publicationId"):::projected v8("?publicationType") v7("?published"):::projected v2("?title"):::projected v8("?year") f0[["sameterm(?instanceOf,?publicationType)"]] f0 --> v3 f0 --> v8 v5 --"wdt:P4327"--> v6 v5 --"wdt:P31"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P1476".-> v2 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P577".-> v7 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."rdfs:label".-> v1 end bind1[/"'wd:Q5633421'"/] bind1 --as--o v8 bind2[/"year-from-dateTime(?published)"/] v7 --o bind2 bind2 --as--o v8