query-17958e05becf67feb6ef7365ef4da3f0

rq turtle/ttl

List of modern trivial Dutch plant names, starting with 'S' or 's' SELECT DISTINCT ?dutchTrivialNameModern ?scientificNameModern ?scientificNameInFB ?dutchTrivialNameInFB ?plate ?plateLabel ?plateImage 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') FILTER (STRSTARTS(UCASE(STR(?dutchTrivialNameModern)), 'S'))
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". } } ORDER BY ?dutchTrivialNameModern

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
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#>
PREFIX bd: <http://www.bigdata.com/rdf#>
# List of modern trivial Dutch plant names, starting with 'S' or 's'
SELECT DISTINCT 
?dutchTrivialNameModern ?scientificNameModern ?scientificNameInFB ?dutchTrivialNameInFB 
?plate ?plateLabel ?plateImage
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')
  FILTER (STRSTARTS(UCASE(STR(?dutchTrivialNameModern)), 'S'))             
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". } 
}
ORDER BY ?dutchTrivialNameModern

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?dutchTrivialNameInFB"):::projected v1("?dutchTrivialNameModern"):::projected v8("?plantDecpicted") v6("?plate"):::projected v7("?plateImage"):::projected v4("?scientificNameInFB"):::projected v2("?scientificNameModern"):::projected v5("?volume") c4(["wd:Q117860156"]):::iri c13(["#91;AUTO_LANGUAGE#93;,nl"]):::literal c11(["bd:serviceParam"]):::iri f0[["starts-with(upper-case(str(?dutchTrivialNameModern)),'S')"]] f0 --> v1 f1[["?dutchTrivialNameModern = 'nl'"]] f1 --> v1 f2[["?scientificNameModern = 'la'"]] f2 --> v2 f3[["?dutchTrivialNameInFB = 'nl'"]] f3 --> v3 f4[["?scientificNameInFB = 'la'"]] f4 --> v4 c4 --"wdt:P527"--> v5 v5 --"wdt:P527"--> v6 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P18".-> v7 end v6 --"wdt:P1476"--> v4 v6 --"wdt:P1476"--> v3 v6 --"wdt:P180"--> v8 v8 --"rdfs:label"--> v2 v8 --"rdfs:label"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end