query-7f1ac0caa748b0a5dd25a568e3dec1a5

rq turtle/ttl

Propertiesmaintained by WikiProject (P6104)DOI (P356)author name string (P2093)cites work (P2860)

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX target: <http://www.wikidata.org/entity/Q56241615>

SELECT
  # Number of works with the author
  ?count

  # Author score - 3 points for authoring a work, 1 for being cited
  ?score

  # Author as a string
  ?author

  # Build URL to the Author disambiguator tool
  (URI(CONCAT(
      'https://author-disambiguator.toolforge.org/names_oauth.php?doit=Look+for+author&name=',
      ENCODE_FOR_URI(?author))) AS ?resolver_url)

# Generate a score for each author

WHERE {
   {
  SELECT
    (COUNT(?work) AS ?count)
    ?author
  WHERE {
     {
  SELECT DISTINCT ?work WHERE {
    ?work wdt:P6104 target: ;
          wdt:P356 ?doi .
  }
  LIMIT 1000
}    ?work wdt:P2093 ?author .
  }
  GROUP BY ?author
}   {
  SELECT (SUM(?score_) AS ?score) ?author
  WHERE {
    {
      # Assign them 3 points if they are an author of a work on the subject
      SELECT (3 AS ?score_) ?author ?work WHERE {
        ?work wdt:P2093 ?author .
        ?work wdt:P6104 target: .
      }
    }
    UNION
    {
      # Assign them 1 point if they are the author of a work that is cited by a work on the subject
      SELECT (1 AS ?score_) ?author ?work WHERE {
        ?work wdt:P2093 ?author .
        ?citing_work wdt:P2860 ?work .
        ?citing_work wdt:P6104 target: .
      }
    }
  }
  GROUP BY ?author
}
  # Label the result
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
}
ORDER BY DESC(?count) DESC(?score)
LIMIT 200

Query found at

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