Bureaucrats, emailconfirmed, Administrators
58,048
edits
KM Wikidata export: Difference between revisions
From Inguma Wikibase
→KM aipatzen duten ASJU artikuluak
(Created page with "= KM aipatzen duten ASJU artikuluak = <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 ?title ?data (group_concat(distinct strafter(str(?egilea),str(iwb:))) as ?egileak) ?issue ?sp ?ep where { ?oocc_it...") |
|||
| Line 23: | Line 23: | ||
} | } | ||
group by ?aipatzen_duena ?title ?data ?egileak ?issue ?sp ?ep | group by ?aipatzen_duena ?title ?data ?egileak ?issue ?sp ?ep | ||
</sparql> | |||
= Find Wikidata-article using DOI = | |||
<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 ?wb_item ?title ?doi ?wd_item ?wd_doi | |||
where { | |||
?wb_item idp:P37 iwb:Q13228; idp:P62 ?cit. | |||
filter not exists { ?wb_item idp:P1 ?linked_wd.} | |||
?wb_item idp:P19 ?data; idp:P10 ?title. filter(lang(?title)="eu") | |||
?wb_item idp:P20 ?doi. bind (ucase(?doi) as ?wd_doi) | |||
# bind(iri(concat(str(wd:),?linked_wd)) as ?wd_item) | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
select * where | |||
{?wd_item wdt:P356 ?wd_doi. | |||
} } | |||
} order by ?doi | |||
</sparql> | </sparql> | ||
