A set of SPARQL examples that are used in different TGX resources
License: https://www.gnu.org/licenses/gpl-3.0
Uses method in: https://github.com/WDscholia/scholia/tree/master/scholia/app/templates/venue_most-cited-authors.sparql
Venue aspect: Most cited authors published in venue
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