232
edits
Line 32: | Line 32: | ||
PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/> | PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/> | ||
select ?wikibase_item ?label | select ?wikibase_item ?label | ||
(iri(concat("http://www.wikidata.org/entity/",?wikidata)) as ?wikidata_link) | |||
(iri(concat("https://aleph.nkp.cz/F/?func=find-c&local_base=aut&ccl_term=ica=",?nkcr)) as ?nkcr_link) | |||
(count(?bibitem) as ?author_roles) | |||
where { | where { | ||
Line 38: | Line 41: | ||
?wikibase_item clbdp:P8 ?nkcr . | ?wikibase_item clbdp:P8 ?nkcr . | ||
optional {?wikibase_item clbdp:P1 ?wikidata .} | optional {?wikibase_item clbdp:P1 ?wikidata .} | ||
?bibitem clbdp:P12 ?wikibase_item. | optional {?bibitem clbdp:P12 ?wikibase_item .} | ||
} group by ?wikibase_item ?label ?nkcr ?wikidata ? | } group by ?wikibase_item ?label ?nkcr ?wikidata ?author_roles order by desc(?author_roles) | ||
</sparql> | </sparql> | ||
See also some more [[SPARQL examples]]. | See also some more [[SPARQL examples]]. |