Bureaucrats, emailconfirmed, Administrators
58,048
edits
Ziterauzi KM: Difference between revisions
From Inguma Wikibase
→Aipuen grafoa
| Line 138: | Line 138: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | ||
} | } | ||
</sparql> | |||
=== Zenbat aipu du KM-en lan bakoitzak? === | |||
<sparql tryit="1"> | |||
PREFIX iwb: <https://wikibase.inguma.eus/entity/> | |||
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/> | |||
PREFIX ip: <https://wikibase.inguma.eus/prop/> | |||
PREFIX ips: <https://wikibase.inguma.eus/prop/statement/> | |||
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | |||
select (count(?aipatzen_duena) as ?zenbat_aipu) ?oocc_item ?oocc_id ?oocc_title | |||
where { | |||
?oocc_item ip:P89 ?oocc_st. | |||
?oocc_st ips:P89 ?oocc_id. | |||
?oocc_item idp:P10 ?oocc_title. | |||
?oocc_st ipq:P91 ?jatorria. bind(iri(concat(str(iwb:),?jatorria)) as ?jatorrizko_argitalpena) | |||
{?aipatzen_duena idp:P62 ?jatorrizko_argitalpena.} union {?aipatzen_duena idp:P62 ?oocc_item.} | |||
?aipatzen_duena idp:P19 ?data; idp:P17 [rdfs:label ?egileaLabel]. filter(lang(?egileaLabel)="eu") | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | |||
} | |||
group by ?zenbat_aipu ?oocc_item ?oocc_id ?oocc_title | |||
order by desc(?zenbat_aipu) | |||
</sparql> | </sparql> | ||
