query-c7485d129395fecf37efd6ced4ce2612

rq turtle/ttl

title: Researchers at a particular research organization citing retracted articles (ROR) 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)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Researchers at a particular research organization citing retracted articles (ROR)
SELECT ?researcher ?researcherLabel ?orcid ?count WHERE {
   {
  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)
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?article") v8("?count"):::projected v5("?orcid"):::projected v4("?organization") v3("?researcher"):::projected v7("?retractedArticle") v2("?ror") a1((" ")) c12(["bd:serviceParam"]):::iri c10(["wd:Q45182324"]):::iri c14(["#91;AUTO_LANGUAGE#93;,en"]):::literal bind0[/VALUES ?ror/] bind0-->v2 bind00(["02jz4aj89"]) bind00 --> bind0 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; v3 --"wdt:P1416"--> a1 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v3 --"wdt:P463"--> a1 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v3 --"wdt:P108"--> a1 end union0r <== or ==> union0l end a1 --"wdt:P361"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P496".-> v5 end v4 --"wdt:P6782"--> v2 v6 --"wdt:P50"--> v3 v6 --"wdt:P2860"--> v7 v7 --"wdt:P31"--> c10 bind2[/"count(?article)"/] v6 --o bind2 bind2 --as--o v8 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end