Bureaucrats, emailconfirmed, Administrators
56,015
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> | </sparql> |