query-22ccdab6fe72737904c8b4cbeea1ce1e

rq turtle/ttl

🪣 Most common fish in the invasion biology literature

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#title: Most common fish in the invasion biology literature
#defaultView:BubbleChart

PREFIX target: <http://www.wikidata.org/prop/direct/P921>

SELECT ?count ?o ?taxonname 
WHERE {
   {
  SELECT (COUNT(?s) AS ?count) ?o WHERE {
    ?s target: ?o .
    ?o wdt:P105 wd:Q7432 .
    ?o wdt:P6104 wd:Q56241615 .
    ?o wdt:P938 ?fishbase .
  }
  GROUP BY ?o
  ORDER BY DESC(?count)
  LIMIT 100
}  ?o wdt:P225 ?taxonname .
}
ORDER BY DESC(?count)

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Invasion_biology