query-88d301e2c4357b28b6e3ce797216c4f4

rq turtle/ttl

Species with their genus, family and order

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?species ?taxonName ?speciesLabel ?genusLabel ?familyLabel ?orderLabel ?order WHERE {
  VALUES ?species {wd:Q146149 wd:Q165145 wd:Q145992 wd:Q133128 wd:Q158776 wd:Q26899 wd:Q22699 wd:Q156895 wd:Q26745 wd:Q158746 wd:Q156831}
  ?species wdt:P105 wd:Q7432 .
  ?species wdt:P225 ?taxonName .
  ?species wdt:P171* ?genus .
  ?genus wdt:P105 wd:Q34740 .
  ?genus wdt:P171* ?family .
  ?family wdt:P105 wd:Q35409 .
  ?family wdt:P171* ?order .
  ?order wdt:P105 wd:Q36602 .
  SERVICE wikibase:label {bd:serviceParam wikibase:language "de"}
  FILTER(?order NOT IN (wd:Q14107023))
  FILTER(?family NOT IN (wd:Q1450881))
}
ORDER BY ?orderLabel ?familyLabel ?genusLabel ?speciesLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?family") v2("?familyLabel"):::projected v9("?genus") v3("?genusLabel"):::projected v6("?order"):::projected v1("?orderLabel"):::projected v7("?species"):::projected v4("?speciesLabel"):::projected v8("?taxonName"):::projected c13(["de"]):::literal c8(["wd:Q35409"]):::iri c4(["wd:Q7432"]):::iri c7(["wd:Q34740"]):::iri c11(["bd:serviceParam"]):::iri c9(["wd:Q36602"]):::iri f0[["?family != 'wd:Q1450881'"]] f0 --> v5 f1[["?order != 'wd:Q14107023'"]] f1 --> v6 bind2[/VALUES ?species/] bind2-->v7 bind20(["wd:Q146149"]) bind20 --> bind2 bind21(["wd:Q165145"]) bind21 --> bind2 bind22(["wd:Q145992"]) bind22 --> bind2 bind23(["wd:Q133128"]) bind23 --> bind2 bind24(["wd:Q158776"]) bind24 --> bind2 bind25(["wd:Q26899"]) bind25 --> bind2 bind26(["wd:Q22699"]) bind26 --> bind2 bind27(["wd:Q156895"]) bind27 --> bind2 bind28(["wd:Q26745"]) bind28 --> bind2 bind29(["wd:Q158746"]) bind29 --> bind2 bind210(["wd:Q156831"]) bind210 --> bind2 v7 --"wdt:P105"--> c4 v7 --"wdt:P225"--> v8 v7 --"wdt:P171"--> v9 v9 --"wdt:P105"--> c7 v9 --"wdt:P171"--> v5 v5 --"wdt:P105"--> c8 v5 --"wdt:P171"--> v6 v6 --"wdt:P105"--> c9 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end