Bureaucrats, emailconfirmed, Administrators
58,049
edits
KM Wikidata export: Difference between revisions
From Inguma Wikibase
→Export ASJU articles (for articles-to-wikidata.py)
| Line 117: | Line 117: | ||
</sparql> | </sparql> | ||
= Aldizkarika, zenbat artikuluk aipatzen du KM? = | |||
<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 ?aldizkariaLabel (count(distinct ?aipatzen_duena) as ?zenbat_artikulu) | |||
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") | |||
?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". } | |||
} | |||
group by ?aldizkariaLabel ?zenbat_artikulu | |||
</sparql> | |||
= Export ASJU articles (for articles-to-wikidata.py) = | = Export ASJU articles (for articles-to-wikidata.py) = | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
| Line 144: | Line 173: | ||
group by ?aipatzen_duena ?wd ?inguma ?title ?data ?wd_egileak ?issue ?sp ?ep ?doi | group by ?aipatzen_duena ?wd ?inguma ?title ?data ?wd_egileak ?issue ?sp ?ep ?doi | ||
</sparql> | </sparql> | ||
= Export UZTARO articles (for uztaro-to-wikidata.py) = | = Export UZTARO articles (for uztaro-to-wikidata.py) = | ||
UZTARO-ko artikuluen zerrenda, bakoitza Wikidatara bidali izanaren datarekin | UZTARO-ko artikuluen zerrenda, bakoitza Wikidatara bidali izanaren datarekin | ||
