query-c6693292cecb82f46d7bc0cbe161da85

rq turtle/ttl

taxon common name (P1843)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
SELECT ?itemLink ?qId ?taxonName ?deCommonName WHERE {
  ?item wdt:P225 ?taxonName .
  ?item wdt:P1843 ?deCommonName .
  FILTER(lang(?deCommonName) = 'de' )
  BIND(str(?item) as ?url)
  BIND(strafter(?url, "http://www.wikidata.org/entity/") as ?qId)
  BIND(uri(concat("https://www.wikidata.org/wiki/",?qId)) AS ?itemLink)
} 
ORDER BY ASC(?taxonName)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?deCommonName"):::projected v3("?item") v6("?itemLink"):::projected v5("?qId"):::projected v1("?taxonName"):::projected v4("?url") f0[["?deCommonName = 'de'"]] f0 --> v2 v3 --"wdt:P225"--> v1 v3 --"wdt:P1843"--> v2 bind1[/"str(?item)"/] v3 --o bind1 bind1 --as--o v4 bind2[/"substring-after(?url,'http://www.wikidata.org/entity/')"/] v4 --o bind2 bind2 --as--o v5 bind3[/"concat('https://www.wikidata.org/wiki/',?qId)"/] v5 --o bind3 bind3 --as--o v6