A set of SPARQL examples that are used in different TGX resources
List of researchers at Maastricht University (via the ROR identifier) citing retracted articles.
PREFIX wd: <http://wikidata.org/entity/>
PREFIX wdt: <http://wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?researcher ?researcherLabel ?orcid ?count WITH {
SELECT ?researcher ?orcid
(COUNT(DISTINCT ?article) AS ?count)
WHERE {
VALUES ?ror { "02jz4aj89" } # 02jz4aj89 is Maastricht University
?researcher ( wdt:P108| wdt:P463 | wdt:P1416 ) / wdt:P361* ?organization .
OPTIONAL { ?researcher wdt:P496 ?orcid }
?organization wdt:P6782 ?ror .
?article wdt:P50 ?researcher; wdt:P2860 ?retractedArticle .
?retractedArticle wdt:P31 wd:Q45182324 .
} GROUP BY ?researcher ?orcid
ORDER BY DESC(?count)
} AS %RESEARCHERS WHERE {
INCLUDE %RESEARCHERS
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?count)