Bureaucrats, emailconfirmed, Administrators
58,048
edits
KM Wikidata export: Difference between revisions
→Export citations (for citation-to-wikidata.py)
| Line 221: | Line 221: | ||
</sparql> | </sparql> | ||
= Export citations (for citation-to-wikidata.py) = | = Export citations (for citation-to-wikidata.py) = | ||
Galdeketa honek Wikidatan oraindik idatzi ez diren aipu-erlazioak zerrendatzen ditu. | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
PREFIX iwb: <https://wikibase.inguma.eus/entity/> | PREFIX iwb: <https://wikibase.inguma.eus/entity/> | ||
| Line 228: | Line 229: | ||
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | ||
select distinct ?aipatzen_duena ?aipatzen_duenaLabel (group_concat(?egileaLabel; SEPARATOR=", ") as ?egileak) (year(?data) as ?urtea) ?oocc_item ?oocc_title ?wd_cit_iturri ?wd_cit_xede | select distinct ?aipatzen_duena ?aipatzen_duenaLabel (group_concat(?egileaLabel; SEPARATOR=", ") as ?egileak) (year(?data) as ?urtea) ?aldizkariaLabel ?oocc_item ?oocc_title ?wd_cit_iturri ?wd_cit_xede | ||
where { | where { | ||
?oocc_item ip:P89 ?oocc_st. | ?oocc_item ip:P89 ?oocc_st. | ||
| Line 237: | Line 238: | ||
?aipatzen_duena idp:P62 [idp:P88* ?oocc_item]. | ?aipatzen_duena idp:P62 [idp:P88* ?oocc_item]. | ||
?aipatzen_duena idp:P19 ?data; idp:P17 [rdfs:label ?egileaLabel]. filter(lang(?egileaLabel)="eu") | ?aipatzen_duena idp:P19 ?data; idp:P37 ?aldizkaria; idp:P17 [rdfs:label ?egileaLabel]. filter(lang(?egileaLabel)="eu") | ||
?aipatzen_duena idp:P1 ?wd_cit_iturri. | |||
bind(iri(concat(str(wd:),?wd_cit_iturri)) as ?wd_cit_iturri_item) | |||
bind(iri(concat(str(wd:),?wd_cit_xede)) as ?wd_cit_xede_item) | |||
filter not exists { | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
select ?wd_cit_iturri_item ?wd_cit_xede_item where {?wd_cit_iturri_item wdt:P2860 ?wd_cit_xede_item. } } | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | ||
} | } | ||
group by ?aipatzen_duena ?aipatzen_duenaLabel ?egileak ?data ?oocc_item ?oocc_id ?oocc_title ?wd_cit_iturri ?wd_cit_xede | group by ?aipatzen_duena ?aipatzen_duenaLabel ?egileak ?data ?aldizkariaLabel ?oocc_item ?oocc_id ?oocc_title ?wd_cit_iturri ?wd_cit_xede | ||
order by ?aipatzen_duena | order by ?aipatzen_duena | ||
</sparql> | </sparql> | ||