KM Wikidata export: Difference between revisions

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

edits