query-6885cf8afc9f239b232f2ff9db33215c

rq turtle/ttl

PropertiesDictionary of Swedish National Biography ID (P3217)occupation (P106)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?occupationLabel (count(?subj) as ?nr) 
{
   {?subj wdt:P3217 ?SBLID} # Beskrivna i SBL

   minus {?subj wdt:P106 ?occupation}  
   SERVICE wikibase:label { bd:serviceParam wikibase:language "sv","en","no","da","de","pl"}
 }
   Group by ?occupationLabel
   order by desc(?nr)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?SBLID") v5("?nr") v4("?occupation") v2("?subj"):::projected c8(["no"]):::literal c10(["de"]):::literal c4(["bd:serviceParam"]):::iri c6(["sv"]):::literal c7(["en"]):::literal c11(["pl"]):::literal c9(["da"]):::literal v2 --"wdt:P3217"--> v3 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v2 --"wdt:P106"--> v4 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c4 --"wikibase:language"--> c6 c4 --"wikibase:language"--> c7 c4 --"wikibase:language"--> c8 c4 --"wikibase:language"--> c9 c4 --"wikibase:language"--> c10 c4 --"wikibase:language"--> c11 end bind2[/"count(?subj)"/] v2 --o bind2 bind2 --as--o v5