Bureaucrats, emailconfirmed, Administrators
54,405
edits
Ziterauzi KM: Difference between revisions
→SPARQL galdeketa
| Line 21: | Line 21: | ||
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | ||
select ?bib_item (strafter(str(?bib_item),"https://wikibase.inguma.eus/entity/") as ?qid) ?EPG_bib ?Dialnet_id ?Inguma_id | select ?bib_item (strafter(str(?bib_item),"https://wikibase.inguma.eus/entity/") as ?qid) ?EPG_bib ?Dialnet_id ?Inguma_id ?worldcat_id | ||
?bib_itemLabel (YEAR(?date) as ?year) | ?bib_itemLabel (YEAR(?date) as ?year) | ||
where { | where { | ||
| Line 28: | Line 28: | ||
optional {?bib_item idp:P86 ?Dialnet_id.} | optional {?bib_item idp:P86 ?Dialnet_id.} | ||
optional {?bib_item idp:P12 ?Inguma_id.} | optional {?bib_item idp:P12 ?Inguma_id.} | ||
optional {?bib_item idp:P46 ?worldcat_id.} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | ||
} group by ?bib_item ?EPG_bib ?Dialnet_id ?Inguma_id ?bib_itemLabel ?date | } group by ?bib_item ?EPG_bib ?Dialnet_id ?Inguma_id ?worldcat_id ?bib_itemLabel ?date | ||
order by xsd:integer(?year) lcase(?label) | order by xsd:integer(?year) lcase(?label) | ||
</sparql> | </sparql> | ||