232
edits
Line 26: | Line 26: | ||
This will list MARC creator roles existing in the data, and number of creator statements. | This will list MARC creator roles existing in the data, and number of creator statements. | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
#defaultView:BarChart | |||
PREFIX clbwb: <https://clb-lod.wikibase.cloud/entity/> | PREFIX clbwb: <https://clb-lod.wikibase.cloud/entity/> | ||
PREFIX clbdp: <https://clb-lod.wikibase.cloud/prop/direct/> | PREFIX clbdp: <https://clb-lod.wikibase.cloud/prop/direct/> | ||
Line 34: | Line 35: | ||
PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/> | PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/> | ||
select ? | 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 | 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") | filter (lang(?marc_creator_role_label)="en") | ||
?bibItem ?marc_creator_role [] . | ?bibItem ?marc_creator_role [] . | ||
} | } | ||
group by ? | group by ?marc_creator_role ?marc_creator_role_label ?number_of_creator_statements | ||
order by desc(?number_of_creator_statements) | order by desc(?number_of_creator_statements) | ||
</sparql> | </sparql> |