SPARQL examples: Difference between revisions

SPARQL examples (view source)

804 bytes added , 2 years ago

232

edits

@@ Line 46: / Line 46: @@
 group by ?marc_creator_role ?marc_creator_role_label ?number_of_creator_statements
 order by desc(?number_of_creator_statements)
+</sparql>
+=== How many NKCR creators don't have are not on Wikidata? ===
+This gives the number of NKCR-disambiguated authors not found on Wikidata.
+<sparql Tryit="1">
+PREFIX clbwb: <https://clb-lod.wikibase.cloud/entity/>
+PREFIX clbdp: <https://clb-lod.wikibase.cloud/prop/direct/>
+PREFIX clbp: <https://clb-lod.wikibase.cloud/prop/>
+PREFIX clbps: <https://clb-lod.wikibase.cloud/prop/statement/>
+PREFIX clbpq: <https://clb-lod.wikibase.cloud/prop/qualifier/>
+PREFIX clbpr: <https://clb-lod.wikibase.cloud/prop/reference/>
+PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/>
+select
+  (count(?nkcr) as ?nkcr_count)
+  (count(?wikidata) as ?wikidata_count)
+where {
+  ?wikibase_item clbdp:P5 clbwb:Q5;
+                 clbdp:P8 ?nkcr .
+  optional {?wikibase_item clbdp:P1 ?wikidata .}
 </sparql>