query-a7cc2b2609435bd775cae81ad3e10eb1

rq turtle/ttl

List of all plates, all volumes, with their depecited plants, their historical and modern botanical (scientific) and Dutch (trivial) names, and Dutch Wikipedia articles about the plants. SELECT DISTINCT ?volume ?volumeLabel ?plate ?plateLabel ?plateImage ?plantDecpicted ?scientificNameInFB ?dutchTrivialNameInFB ?scientificNameModern ?dutchTrivialNameModern ?plantDecpictedWikipediaNL WHERE { wd:Q117860156 wdt:P527 ?volume. ?volume wdt:P527 ?plate. OPTIONAL{?plate wdt:P18 ?plateImage.}

?plate wdt:P1476 ?scientificNameInFB. FILTER(lang(?scientificNameInFB)='la') ?plate wdt:P1476 ?dutchTrivialNameInFB. FILTER(lang(?dutchTrivialNameInFB)='nl')

?plate wdt:P180 ?plantDecpicted. ?plantDecpicted rdfs:label ?scientificNameModern . FILTER(lang(?scientificNameModern)='la') ?plantDecpicted rdfs:label?dutchTrivialNameModern . FILTER(lang(?dutchTrivialNameModern)='nl')

OPTIONAL{?plantDecpictedWikipediaNL schema:about ?plantDecpicted; schema:isPartOf https://nl.wikipedia.org/.}

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". } } ORDER BY ?volumeLabel ?plateLabel

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# List of all plates, all volumes, with their depecited plants, their historical and modern botanical (scientific) and Dutch (trivial) names, and Dutch Wikipedia articles about the plants.
SELECT DISTINCT 
?volume ?volumeLabel 
?plate ?plateLabel ?plateImage
?plantDecpicted
?scientificNameInFB ?dutchTrivialNameInFB ?scientificNameModern ?dutchTrivialNameModern
?plantDecpictedWikipediaNL
WHERE 
{
  wd:Q117860156 wdt:P527 ?volume.
  ?volume wdt:P527 ?plate.
  OPTIONAL{?plate wdt:P18 ?plateImage.}

  ?plate wdt:P1476 ?scientificNameInFB. FILTER(lang(?scientificNameInFB)='la')
  ?plate wdt:P1476 ?dutchTrivialNameInFB. FILTER(lang(?dutchTrivialNameInFB)='nl')

  ?plate wdt:P180 ?plantDecpicted.
  ?plantDecpicted rdfs:label ?scientificNameModern . FILTER(lang(?scientificNameModern)='la')
  ?plantDecpicted rdfs:label?dutchTrivialNameModern . FILTER(lang(?dutchTrivialNameModern)='nl')

  OPTIONAL{?plantDecpictedWikipediaNL schema:about ?plantDecpicted; 
           schema:isPartOf <https://nl.wikipedia.org/>.}

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". } 
}
ORDER BY ?volumeLabel ?plateLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?dutchTrivialNameInFB"):::projected v3("?dutchTrivialNameModern"):::projected v10("?plantDecpicted"):::projected v11("?plantDecpictedWikipediaNL"):::projected v8("?plate"):::projected v9("?plateImage"):::projected v2("?plateLabel"):::projected v6("?scientificNameInFB"):::projected v4("?scientificNameModern"):::projected v7("?volume"):::projected v1("?volumeLabel"):::projected c3(["wd:Q117860156"]):::iri c15(["#91;AUTO_LANGUAGE#93;,nl"]):::literal c13(["bd:serviceParam"]):::iri c11([https://nl.wikipedia.org/]):::iri f0[["?dutchTrivialNameModern = 'nl'"]] f0 --> v3 f1[["?scientificNameModern = 'la'"]] f1 --> v4 f2[["?dutchTrivialNameInFB = 'nl'"]] f2 --> v5 f3[["?scientificNameInFB = 'la'"]] f3 --> v6 c3 --"wdt:P527"--> v7 v7 --"wdt:P527"--> v8 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v8 -."wdt:P18".-> v9 end v8 --"wdt:P1476"--> v6 v8 --"wdt:P1476"--> v5 v8 --"wdt:P180"--> v10 v10 --"rdfs:label"--> v4 v10 --"rdfs:label"--> v3 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v11 -."schema:about".-> v10 v11 --"schema:isPartOf"--> c11 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end