query-ff4db2d1d3b21b0905725976c85d4650

rq turtle/ttl

List of all genera and species of cacti with articles in dewiki

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>SELECT ?item ?name ?article WHERE {
      ?item wdt:P225 ?name .
      {
        ?item wdt:P105 wd:Q7432 .
      } UNION {
        ?item wdt:P105 wd:Q34740 .
      }
      ?item (wdt:P171)* wd:Q14560 .
      OPTIONAL {
          ?article schema:about ?item .
          ?article schema:inLanguage "de" .
          FILTER (SUBSTR(str(?article), 1, 25) = "https://de.wikipedia.org/")
        }
}
ORDER BY ASC(?name)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?article"):::projected v3("?item"):::projected v1("?name"):::projected c12(["de"]):::literal c6(["wd:Q7432"]):::iri c7(["wd:Q34740"]):::iri c9(["wd:Q14560"]):::iri v3 --"wdt:P225"--> v1 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v3 --"wdt:P105"--> c7 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v3 --"wdt:P105"--> c6 end union0r <== or ==> union0l end v3 --"wdt:P171"--> c9 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."schema:about".-> v3 v2 --"schema:inLanguage"--> c12 end