A set of SPARQL examples that are used in different TGX resources
Contributor: Egon Willighagen
Uses method in: https://www.wikidata.org/wiki/Wikidata:WikiProject_Retractions/SPARQL
Journals that cite retracted articles, sorted by citation count.
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?journal ?journalLabel (COUNT(DISTINCT ?citesRetracted) AS ?count) WHERE {
?citesRetracted wdt:P2860 / wdt:P31 wd:Q45182324 ;
wdt:P1433 ?journal .
?journal rdfs:label ?journalLabel . FILTER (LANG(?journalLabel) = "en") .
} GROUP BY ?journal ?journalLabel
ORDER BY DESC(?count)
LIMIT 100
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?citesRetracted"):::projected
v5("?count")
v4("?journal"):::projected
v2("?journalLabel"):::projected
a1((" "))
c4(["wd:Q45182324"]):::iri
f0[["?journalLabel = 'en'"]]
f0 --> v2
v3 --"wdt:P2860"--> a1
a1 --"wdt:P31"--> c4
v3 --"wdt:P1433"--> v4
v4 --"rdfs:label"--> v2
bind2[/"count(?citesRetracted)"/]
v3 --o bind2
bind2 --as--o v5