query-a51ab74b40b282243f820b706dd11a8e

rq turtle/ttl

SELECT WRITTEN WORKS AND THEIR EDITIONS SELECT DISTINCT ?oclcWorkId ?work ?author ?authorLabel ?viaf_id ?workLabel ?subject ?subjectLabel ?edition ?isbn_13 ?edition_title ?edition_subTitle (YEAR(?pubDate) AS ?year) ?publisher ?publisherLabel ?placeOfPub ?placeOfPubLabel ?edition_image WHERE { #?work wdt:P5008 wd:Q100202113 . # CHANGE Q-NUMBER HERE TO CTRL PROJECT SCOPE ?work wdt:P31 wd:Q47461344 ; wdt:P5331 ?oclcWorkId ; wdt:P747 ?edition ; wdt:P50 ?author . OPTIONAL {?author wdt:P214 ?viaf_id } . ?work wdt:P921 ?subject . ?edition wdt:P577 ?pubDate . ?edition wdt:P123 ?publisher ; wdt:P291 ?placeOfPub . ?edition wdt:P1476 ?edition_title . OPTIONAL {?edition wdt:P1680 ?edition_subTitle } . OPTIONAL {?edition wdt:P18 ?edition_image } . OPTIONAL {?edition wdt:P212 ?isbn_13 } . SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr,de" } }ORDER BY ASC (?work) ?workLabel

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#SELECT WRITTEN WORKS AND THEIR EDITIONS
SELECT DISTINCT ?oclcWorkId ?work ?author ?authorLabel ?viaf_id ?workLabel ?subject ?subjectLabel ?edition ?isbn_13 ?edition_title ?edition_subTitle (YEAR(?pubDate) AS ?year) ?publisher ?publisherLabel ?placeOfPub ?placeOfPubLabel ?edition_image
WHERE
{
 #?work wdt:P5008 wd:Q100202113 . # CHANGE Q-NUMBER HERE TO CTRL PROJECT SCOPE
  ?work wdt:P31 wd:Q47461344 ; wdt:P5331 ?oclcWorkId ; wdt:P747 ?edition ; wdt:P50 ?author .
 OPTIONAL {?author wdt:P214  ?viaf_id } .
 ?work wdt:P921 ?subject .
 ?edition wdt:P577 ?pubDate . 
 ?edition wdt:P123 ?publisher ; wdt:P291 ?placeOfPub .
 ?edition wdt:P1476 ?edition_title .
 OPTIONAL {?edition wdt:P1680 ?edition_subTitle } .
 OPTIONAL {?edition wdt:P18 ?edition_image } .
 OPTIONAL {?edition wdt:P212 ?isbn_13 } .
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr,de" }
}ORDER BY ASC (?work) ?workLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?author"):::projected v4("?edition"):::projected v13("?edition_image"):::projected v12("?edition_subTitle"):::projected v11("?edition_title"):::projected v14("?isbn_13"):::projected v3("?oclcWorkId"):::projected v10("?placeOfPub"):::projected v8("?pubDate"):::projected v9("?publisher"):::projected v7("?subject"):::projected v6("?viaf_id"):::projected v1("?work"):::projected v2("?workLabel"):::projected v15("?year") c2(["wd:Q47461344"]):::iri c16(["bd:serviceParam"]):::iri c18(["en,fr,de"]):::literal v1 --"wdt:P31"--> c2 v1 --"wdt:P5331"--> v3 v1 --"wdt:P747"--> v4 v1 --"wdt:P50"--> v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P214".-> v6 end v1 --"wdt:P921"--> v7 v4 --"wdt:P577"--> v8 v4 --"wdt:P123"--> v9 v4 --"wdt:P291"--> v10 v4 --"wdt:P1476"--> v11 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P1680".-> v12 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P18".-> v13 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P212".-> v14 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c16 --"wikibase:language"--> c18 end bind0[/"year-from-dateTime(?pubDate)"/] v8 --o bind0 bind0 --as--o v15