Bureaucrats, emailconfirmed, Administrators
58,048
edits
KM Wikidata export: Difference between revisions
→Export citations (for citation-to-wikidata.py)
| Line 279: | Line 279: | ||
} | } | ||
group by ?aipatzen_duena ?aipatzen_duenaLabel ?egileak ?data ?aldizkariaLabel ?oocc_item ?oocc_id ?oocc_title ?wd_cit_iturri ?wd_cit_xede ?wikidata_upload | group by ?aipatzen_duena ?aipatzen_duenaLabel ?egileak ?data ?aldizkariaLabel ?oocc_item ?oocc_id ?oocc_title ?wd_cit_iturri ?wd_cit_xede ?wikidata_upload | ||
order by ?aipatzen_duena | |||
</sparql> | |||
Galdeketa honek galdetzen du KM aipatzen duen lanen bat Wikidatan existitzen ez oten den: | |||
<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 ?aipatzen_duenaLabel (group_concat(?egileaLabel; SEPARATOR=", ") as ?egileak) (year(?data) as ?urtea) ?aldizkariaLabel ?oocc_item ?oocc_title | |||
where { | |||
?oocc_item ip:P89 ?oocc_st. | |||
?oocc_st ips:P89 ?oocc_id. | |||
?oocc_st ipq:P75 ?oocc_text. | |||
?oocc_item idp:P10 ?oocc_title. | |||
?oocc_item idp:P1 ?wd_cit_xede. | |||
?aipatzen_duena idp:P62 [idp:P88* ?oocc_item]. | |||
?aipatzen_duena idp:P19 ?data; idp:P37 ?aldizkaria; idp:P17 [rdfs:label ?egileaLabel]. filter(lang(?egileaLabel)="eu") | |||
filter not exists {?aipatzen_duena idp:P1 ?wd_cit_iturri.} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". } | |||
} | |||
group by ?aipatzen_duena ?aipatzen_duenaLabel ?egileak ?data ?aldizkariaLabel ?oocc_item ?oocc_id ?oocc_title | |||
order by ?aipatzen_duena | order by ?aipatzen_duena | ||
</sparql> | </sparql> | ||