query-1e8330ee092b91c9e44586299ade8936

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: Occupation des personnes liées à UdeM-HEC-Poly (requête basée sur Nicolas Vigneron) 
#defaultView:BubbleChart
SELECT ?occupation1Label (COUNT(DISTINCT ?researcher) AS ?nb) WHERE {
  VALUES ?univ { wd:Q392189 wd:Q273527 wd:Q273619 wd:Q1054216 wd:Q67182995 wd:Q2945760 wd:Q3152656 wd:Q3151984 wd:Q3145326 wd:Q3145180 }  # et CHUM, Mila, Ste-Justine, gériatrie, MHI, SacréCoeur, Maisonneuve
  ?researcher (wdt:P108|wdt:P1416/wdt:P361*) ?univ. # Employés ou affilié ou étudiants et leurs sous-parties (dép., facultés, etc.)
  ?researcher wdt:P106 ?occupation1 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  FILTER NOT EXISTS { ?researcher wdt:P106 wd:Q1650915 }
  FILTER NOT EXISTS { ?researcher wdt:P106 wd:Q1622272} 
}
GROUP BY ?occupation1Label

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?nb") v3("?occupation1") v1("?researcher"):::projected v2("?univ") a1((" ")) c8(["bd:serviceParam"]):::iri c2(["wd:Q1622272"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal c3(["wd:Q1650915"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P106"--> e0c2 e0v1("?researcher"):::projected e0c2(["wd:Q1622272"]):::iri end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> c2 v1 --"wdt:P106"--> c2 f1[["not "]] subgraph f1e1["Exists Clause"] e1v1 --"wdt:P106"--> e1c2 e1v1("?researcher"):::projected e1c2(["wd:Q1650915"]):::iri end f1--EXISTS--> f1e1 f1 --> v1 f1 --> c1 f1 --> c3 v1 --"wdt:P106"--> c3 bind2[/VALUES ?univ/] bind2-->v2 bind20(["wd:Q392189"]) bind20 --> bind2 bind21(["wd:Q273527"]) bind21 --> bind2 bind22(["wd:Q273619"]) bind22 --> bind2 bind23(["wd:Q1054216"]) bind23 --> bind2 bind24(["wd:Q67182995"]) bind24 --> bind2 bind25(["wd:Q2945760"]) bind25 --> bind2 bind26(["wd:Q3152656"]) bind26 --> bind2 bind27(["wd:Q3151984"]) bind27 --> bind2 bind28(["wd:Q3145326"]) bind28 --> bind2 bind29(["wd:Q3145180"]) bind29 --> bind2 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v1 --"wdt:P1416"--> a1 a1 --"wdt:P361"--> v2 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v1 --"wdt:P108"--> v2 end union0r <== or ==> union0l end v1 --"wdt:P106"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end bind4[/"count(?researcher)"/] v1 --o bind4 bind4 --as--o v4