sparql-examples

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

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

006

rq turtle/ttl

List of researchers at Maastricht University (via the ROR identifier) citing retracted articles.

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 ?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)