KM Wikidata export

KM aipatzen duten ASJU artikuluak

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 distinct ?aipatzen_duena  ?title ?data (group_concat(distinct strafter(str(?egilea),str(iwb:))) as ?egileak)
?issue ?sp ?ep
where {
  ?oocc_item ip:P89 ?oocc_st.
    
  ?aipatzen_duena idp:P37 iwb:Q13228; idp:P62 [idp:P88* ?oocc_item].
  filter not exists {?aipatzen_duena idp:P1 ?wd.}
  
  ?aipatzen_duena idp:P19 ?data; idp:P17 ?egilea; idp:P10 ?title. filter(lang(?title)="eu")
  ?aipatzen_duena idp:P20 ?doi.
  optional {?aipatzen_duena idp:P26 ?issue.}
  optional {?aipatzen_duena idp:P27 ?sp.}
  optional {?aipatzen_duena idp:P28 ?ep.}

}  
group by ?aipatzen_duena ?title ?data ?egileak ?issue ?sp ?ep

Try it!