KM Wikidata export: Difference between revisions

KM Wikidata export (view source)

1,086 bytes added , 26 days ago

58,048

edits

@@ 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>