Bureaucrats, emailconfirmed, Administrators
58,048
edits
Ziterauzi KM: Difference between revisions
→Mitxelenaren lanetako aipuak, OOCC-ko itemei lotuta
| Line 113: | Line 113: | ||
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | ||
select ?aipatzen_duena ?aipatzen_duenaLabel ?jatorrizko_argitalpena ?oocc_item ?oocc_id ?oocc_title | select ?aipatzen_duena ?aipatzen_duenaLabel (group_concat(?egileaLabel) as ?egileak) (year(?data) as ?urtea) ?jatorrizko_argitalpena ?oocc_item ?oocc_id ?oocc_title | ||
where { | where { | ||
?oocc_item ip:P89 ?oocc_st. | ?oocc_item ip:P89 ?oocc_st. | ||
| Line 121: | Line 121: | ||
?oocc_st ipq:P91 ?jatorria. bind(iri(concat(str(iwb:),?jatorria)) as ?jatorrizko_argitalpena) | ?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: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". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | ||
} | } | ||
group by ?aipatzen_duena ?aipatzen_duenaLabel ?egileak ?data ?jatorrizko_argitalpena ?oocc_item ?oocc_id ?oocc_title | |||
order by xsd:integer(?oocc_id) | order by xsd:integer(?oocc_id) | ||
</sparql> | </sparql> | ||
=== Aipuen grafoa === | === Aipuen grafoa === | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||