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://wikidata.org/entity/>
PREFIX wdt: <http://wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?journal ?journalLabel ?count WITH {
  SELECT ?journal (COUNT(DISTINCT ?citesRetracted) AS ?count) WHERE {
    ?citesRetracted wdt:P2860 / wdt:P31 wd:Q45182324 ;
                    wdt:P1433 ?journal .
  } GROUP BY ?journal
    ORDER BY DESC(?count)
    LIMIT 100
} AS %JOURNALS {
  INCLUDE %JOURNALS
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?count)