sparql-examples

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

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

011

rq turtle/ttl

Journals that cite retracted articles, sorted by citation count.

Use at

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