SPARQL examples: Difference between revisions

SPARQL examples (view source)

1,101 bytes added , 2 years ago

232

edits

@@ Line 20: / Line 20: @@
 bind(xsd:integer(strafter(str(?wikibase_item),"https://clb-lod.wikibase.cloud/entity/Q")) as ?order)
 } order by ?order
+</sparql>
+=== Distribution of MARC creator roles ===
+This will list MARC creator roles existing in the data, and number of creator statements.
+<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 ?marc_creator_role ?marc_creator_role_label (count(?bibItem) as ?number_of_creator_statements)
+where {
+?marc_creator_prop clbdp:P5 clbwb:Q33; wikibase:directClaim ?marc_creator_role; rdfs:label ?marc_creator_role_label .
+  filter (lang(?marc_creator_role_label)="en")
+?bibItem ?marc_creator_role [] .
+}
+group by ?marc_creator_role ?marc_creator_role_label ?number_of_creator_statements
+order by desc(?number_of_creator_statements)
 </sparql>