query-e8a77b216749e2537eaeb54632d4f711

rq turtle/ttl

Propertiesmaintained by WikiProject (P6104)main subject (P921)taxon name (P225)taxon rank (P105)parent taxon (P171)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT 
  DISTINCT 
  ?topic ?speciesname ?classname 
  ?count
  (CONCAT('https://scholia.toolforge.org/taxon/', ENCODE_FOR_URI(REPLACE(STR(?topic), ".*Q", "Q")), '/curation') AS ?taxon_curation) 


WHERE {
   {
  SELECT DISTINCT ?topic ?speciesname ?count WHERE {
     {
  SELECT DISTINCT ?topic 
  (COUNT(?paper) AS ?count)
  WHERE {
  ?paper wdt:P6104 wd:Q56241615 ;
         wdt:P921 ?topic .
  }  
  GROUP BY ?topic ?count
}  ?topic wdt:P225 ?speciesname ;
         wdt:P105 wd:Q7432 .

  }
  GROUP BY ?topic ?speciesname ?count

}  ?topic wdt:P171* ?class .
  ?class wdt:P105 wd:Q37517;
         wdt:P225 ?classname .
}
GROUP BY ?topic ?speciesname ?classname ?count ?taxon_curation
ORDER BY DESC(?count)

Query found at