query-94f05b57fed6a037aaf0688ddf8f54ab

rq turtle/ttl

List of cacti without german description

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 bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?taxonName ?taxonRankLabel ?parentTaxonName (GROUP_CONCAT(?lang) AS ?langs) WHERE {
   ?item wdt:P225 ?taxonName .
   ?item wdt:P105 ?taxonRank .
   ?item wdt:P171/wdt:P225 ?parentTaxonName .
   ?item (wdt:P171)* wd:Q14560 . # Cactaceae
   OPTIONAL {?item schema:description ?itemDescription}
   BIND(lang(?itemDescription) as ?lang)   
   SERVICE wikibase:label {bd:serviceParam wikibase:language "de" .}
}
GROUP BY ?item ?taxonName  ?taxonRankLabel ?parentTaxonName
HAVING (!Contains(?langs,  "de"))
ORDER BY ASC(?taxonName)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v6("?itemDescription") v7("?lang"):::projected v8("?langs") v5("?parentTaxonName"):::projected v1("?taxonName"):::projected v4("?taxonRank") a1((" ")) c1(["de"]):::literal c8(["bd:serviceParam"]):::iri c5(["wd:Q14560"]):::iri f0[["not contains(?langs,'de')"]] f0 --> v8 v3 --"wdt:P225"--> v1 v3 --"wdt:P105"--> v4 v3 --"wdt:P171"--> a1 a1 --"wdt:P225"--> v5 v3 --"wdt:P171"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."schema:description".-> v6 end bind1[/"?itemDescription"/] v6 --o bind1 bind1 --as--o v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c1 end bind3[/"?lang"/] v7 --o bind3 bind3 --as--o v8