KM Wikidata export: Difference between revisions

← Older edit

KM Wikidata export (view source)

Revision as of 10:12, 26 November 2024

1,265 bytes added , 3 days ago

→‎Export ASJU articles (for articles-to-wikidata.py)

DavidL

Bureaucrats, emailconfirmed, Administrators

58,049

edits

@@ Line 117: / Line 117: @@
 </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) =
 <sparql tryit="1">
@@ Line 144: / Line 173: @@
 group by ?aipatzen_duena ?wd ?inguma ?title ?data ?wd_egileak ?issue ?sp ?ep ?doi
 </sparql>
 = Export UZTARO articles (for uztaro-to-wikidata.py) =
 UZTARO-ko artikuluen zerrenda, bakoitza Wikidatara bidali izanaren datarekin