query-40f23fc657951dadf4c68f6f6af3de90

rq turtle/ttl

List of all travelogues with their described places

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?reisebericht ?reiseberichtLabel ?mainSubject ?mainSubjectLabel ?ortAlt ?seite ?sortNr ?refUrl WHERE {
  ?reisebericht wdt:P1343 wd:Q105102869;
    p:P921 ?mainSubjectStmt.
  ?mainSubjectStmt ps:P921 ?mainSubject;
    prov:wasDerivedFrom ?refNode.
  ?refNode pr:P304 ?seite;
    pr:P1545 ?sortNr.
  OPTIONAL { ?refNode pr:P1932 ?ortAlt. }
  OPTIONAL { ?refNode pr:P854 ?refUrl. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (?reisebericht) (xsd:integer(?sortNr))

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?mainSubject"):::projected v3("?mainSubjectStmt") v7("?ortAlt"):::projected v5("?refNode") v8("?refUrl"):::projected v1("?reisebericht"):::projected v6("?seite"):::projected v2("?sortNr"):::projected c2(["wd:Q105102869"]):::iri c11(["bd:serviceParam"]):::iri c13(["#91;AUTO_LANGUAGE#93;,en"]):::literal v1 --"p:direct/P1343"--> c2 v1 --"p:P921"--> v3 v3 --"p:statement/P921"--> v4 v3 --"prov:wasDerivedFrom"--> v5 v5 --"p:reference/P304"--> v6 v5 --"p:reference/P1545"--> v2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:reference/P1932".-> v7 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v5 -."p:reference/P854".-> v8 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end