Bureaucrats, emailconfirmed, Administrators
58,048
edits
KM Wikidata export: Difference between revisions
→Export ASJU articles (for articles-to-wikidata.py)
| Line 144: | Line 144: | ||
group by ?aipatzen_duena ?wd ?inguma ?title ?data ?wd_egileak ?issue ?sp ?ep ?doi | group by ?aipatzen_duena ?wd ?inguma ?title ?data ?wd_egileak ?issue ?sp ?ep ?doi | ||
</sparql> | </sparql> | ||
= Export UZTARO articles (for uztaro-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 ?artikulua ?wd ?inguma ?title ?data (group_concat(distinct concat('"',?sordinal,'": "',?wd_egilea,'"'); SEPARATOR=", ") as ?wd_egileak) | |||
?issue ?sp ?ep ?doi ?ojs_landing ?wd_upload | |||
where { | |||
?artikulua idp:P37 iwb:Q13091.# ; idp:P59 iwb:Q13367. | |||
?artikulua idp:P19 ?data; ip:P17 [ips:P17 ?egilea; ipq:P36 ?sordinal]; idp:P10 ?title. filter(lang(?title)="eu") | |||
optional {?artikulua idp:P20 ?doi.} | |||
?egilea idp:P1 ?wd_egilea. | |||
optional {?artikulua idp:P1 ?wd. bind(iri(concat(str(wd:),?wd)) as ?wikidata_item) | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
select ?wikidata_item ?wd_upload where {?wikidata_item p:P31 [ps:P31 wd:Q13442814; prov:wasDerivedFrom [pr:P248 wd:Q12259621; pr:P813 ?wd_upload]].} | |||
} | |||
} | |||
optional {?artikulua idp:P12 ?inguma.} | |||
?artikulua idp:P26 ?issue. | |||
optional {?artikulua idp:P27 ?sp.} | |||
optional {?artikulua idp:P28 ?ep.} | |||
?artikulua idp:P24 ?ojs_landing. | |||
} | |||
group by ?artikulua ?wd ?inguma ?title ?data ?wd_egileak ?issue ?sp ?ep ?doi ?ojs_landing ?wd_upload | |||
</sparql> | |||
= Export OOCC articles (for oocc-to-wikidata.py) = | = Export OOCC articles (for oocc-to-wikidata.py) = | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||