KM Wikidata export: Difference between revisions

Line 76: Line 76:
    
    
   }   
   }   
</sparql>
= Export ASJU articles (for articles-to-wikidata.py) =
<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 distinct ?aipatzen_duena ?wd ?inguma ?title ?data (group_concat(distinct concat('"',?sordinal,'": "',?wd_egilea,'"'); SEPARATOR=", ") as ?wd_egileak)
?issue ?sp ?ep ?doi
where {
 
  ?aipatzen_duena idp:P37 iwb:Q13228; idp:P62 ?cit.
  ?aipatzen_duena idp:P19 ?data; ip:P17 [ips:P17 ?egilea; ipq:P36 ?sordinal]; idp:P10 ?title. filter(lang(?title)="eu")
  ?aipatzen_duena idp:P20 ?doi.
  ?egilea idp:P1 ?wd_egilea.
  filter not exists {?aipatzen_duena idp:P1 ?wd.}
  optional {?aipatzen_duena idp:P12 ?inguma.}
  optional {?aipatzen_duena idp:P26 ?issue.}
  optional {?aipatzen_duena idp:P27 ?sp.}
  optional {?aipatzen_duena idp:P28 ?ep.}
}
group by ?aipatzen_duena ?wd ?inguma ?title ?data ?wd_egileak ?issue ?sp ?ep ?doi
</sparql>
</sparql>
Bureaucrats, emailconfirmed, Administrators
56,015

edits