query-d063aecf30954c694ee41d44f71123ad

rq turtle/ttl

Propertiesmaintained by WikiProject (P6104)main subject (P921)taxon name (P225)taxon rank (P105)image (P18)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT 
DISTINCT 
?taxon ?taxonname 
?papercount
?linkcount
?score
WHERE {
   {
  SELECT 
  ?taxon ?taxonname 
         (COUNT(?paper) AS ?papercount)
         {
           ?paper wdt:P6104 wd:Q56241615 ;
                  wdt:P921 ?taxon .
           ?taxon wdt:P225 ?taxonname ;
                  wdt:P105 wd:Q7432 .
           MINUS {?taxon wdt:P18 ?image}

         }
  GROUP BY ?taxon ?taxonname ?papercount 

}          ?taxon wikibase:sitelinks ?linkcount .
  BIND ((?papercount +1) * (?linkcount +1 ) AS ?score)
}
GROUP BY ?taxon ?taxonname ?papercount ?linkcount ?score
ORDER BY DESC(?score)
LIMIT 200

Query found at