query-090f6a8b0d185ac53bbcfc8cdd3b1cf4

rq turtle/ttl

People with more than one honorary degree but no enwiki page

Per enwiki WP:NPROF 1: "For the purposes of partially satisfying Criterion 1, significant academic awards and honors may include [...] honorary degrees"

SELECT DISTINCT ?person ?personLabel ?personDescription ?degrees WHERE { { SELECT DISTINCT ?person (COUNT(DISTINCT ?degree) as ?degrees) WHERE { { ?person wdt:P166 ?degree . ?degree wdt:P279 wd:Q11415564 . } UNION { ?person p:P166 ?degree. ?degree ps:P166 wd:Q11415564. } } GROUP BY ?person } FILTER ( ?degrees > 1 ) SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } FILTER NOT EXISTS { [] schema:about ?person ; schema:isPartOf https://en.wikipedia.org/ } } ORDER BY DESC (?degrees)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# People with more than one honorary degree but no enwiki page
# Per enwiki WP:NPROF 1: "For the purposes of partially satisfying Criterion 1, significant academic awards and honors may include [...] honorary degrees"
SELECT DISTINCT ?person ?personLabel ?personDescription ?degrees WHERE {
  { SELECT DISTINCT ?person (COUNT(DISTINCT ?degree) as ?degrees) WHERE {
  { ?person wdt:P166 ?degree . ?degree wdt:P279 wd:Q11415564 . } UNION { ?person p:P166 ?degree. ?degree ps:P166 wd:Q11415564. }
  } GROUP BY ?person } FILTER ( ?degrees > 1 )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } 
  FILTER NOT EXISTS { [] schema:about ?person ; schema:isPartOf <https://en.wikipedia.org/> }
} ORDER BY DESC (?degrees)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?degree") v4("?degrees"):::projected v2("?person"):::projected a1((" ")) c13(["en"]):::literal c3([https://en.wikipedia.org/]):::iri c11(["bd:serviceParam"]):::iri c7(["wd:Q11415564"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0a1 --"schema:about"--> e0v1 e0a1 --"schema:isPartOf"--> e0c3 e0v1("?person"):::projected e0a1((" ")):::projected e0c3([https://en.wikipedia.org/]):::iri end f0--EXISTS--> f0e0 f0 --> a1 f0 --> c1 f0 --> v2 f0 --> c2 f0 --> c3 a1 --"schema:about"--> v2 a1 --"schema:isPartOf"--> c3 f1[["?degrees > '1^^xsd:integer'"]] f1 --> v4 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v2 --"p:P166"--> v3 v3 --"p:statement/P166"--> c7 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"p:direct/P166"--> v3 v3 --"p:direct/P279"--> c7 end union0r <== or ==> union0l end bind3[/"count(?degree)"/] v3 --o bind3 bind3 --as--o v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c11 --"wikibase:language"--> c13 end