sparql-examples

A set of SPARQL examples that are used in different TGX resources

View the Project on GitHub BiGCAT-UM/sparql-examples

217

rq turtle/ttl

Venue aspect: Most cited authors published in venue

Use at

PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
# title: Most cited authors published in venue

PREFIX target: <http://www.wikidata.org/entity/Q6294930>

SELECT
  ?count
  ?author ?authorLabel
  ?orcid
  ?example_cited_work ?example_cited_workLabel
  ?example_citing_work ?example_citing_workLabel
WITH {
  # Count the number of citations
  SELECT
    ?author
    (COUNT(?cited_work) AS ?count)
    (SAMPLE(?cited_work) AS ?example_cited_work)
    (SAMPLE(?citing_work) AS ?example_citing_work)
  WHERE {
    ?cited_work wdt:P1433 target: .
    ?citing_work wdt:P2860 ?cited_work .
    ?cited_work wdt:P50 ?author .
  }
  GROUP BY ?author
} AS %result
WHERE {
  INCLUDE %result 
          
  # Include optional ORCID iD
  OPTIONAL { ?author wdt:P496 ?orcid . }
  
  # Label the results
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . } 
}
ORDER BY DESC(?count)
LIMIT 100

graph TD