query-2e4697346e5cc5de91ce1a7d9643b4e6

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 ?kingdomname ?speciesname
  ?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
#  HAVING (?count > 25)

}  ?topic wdt:P171* ?kingdom .
  ?kingdom wdt:P105 wd:Q36732;
         wdt:P225 ?kingdomname .
}
GROUP BY ?topic ?kingdomname ?speciesname ?count ?taxon_curation
ORDER BY ASC(?kingdomname) DESC(?count)

Query found at