Ziterauzi KM: Difference between revisions

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 (group_concat(?egileaLabel) as ?egileak) (year(?data) as ?urtea) ?jatorrizko_argitalpena ?oocc_item ?oocc_id ?oocc_title  
select ?aipatzen_duena ?aipatzen_duenaLabel (group_concat(?egileaLabel) as ?egileak) (year(?data) as ?urtea) ?oocc_item ?oocc_id ?oocc_title  
where {
where {
   ?oocc_item ip:P89 ?oocc_st.
   ?oocc_item ip:P89 ?oocc_st.
Line 119: Line 119:
   ?oocc_st ipq:P75 ?oocc_text.
   ?oocc_st ipq:P75 ?oocc_text.
   ?oocc_item idp:P10 ?oocc_title.
   ?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:P62 [idp:P88 ?oocc_item].} union {?aipatzen_duena idp:P62 ?oocc_item.}
 
   ?aipatzen_duena idp:P19 ?data; idp:P17 [rdfs:label ?egileaLabel]. filter(lang(?egileaLabel)="eu")
   ?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". }
Line 127: Line 128:
order by xsd:integer(?oocc_id)
order by xsd:integer(?oocc_id)
</sparql>
</sparql>
=== Aipuen grafoa ===
=== Aipuen grafoa ===
<sparql tryit="1">
<sparql tryit="1">
Bureaucrats, emailconfirmed, Administrators
58,048

edits