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/sponsor_topics-of-sponsored-works.sparql
Sponsor aspect: topics of sponsored works
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#>
#defaultView:BubbleChart
PREFIX target: <http://www.wikidata.org/entity/Q1200258>
SELECT
?count ?topic ?topicLabel
WITH {
SELECT (COUNT(?work) AS ?count) ?topic
WHERE {
?work wdt:P859+ target: .
?work wdt:P921 ?topic .
}
GROUP BY ?topic
ORDER BY DESC(?count)
LIMIT 200
} AS %result
WHERE {
INCLUDE %result
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" . }
}
ORDER BY DESC(?count)
graph TD