KM Wikidata export: Difference between revisions

KM Wikidata export (view source)

987 bytes added , 26 days ago

58,048

edits

@@ Line 47: / Line 47: @@
 }     order by ?doi
+</sparql>
+= Find Wikidata-creator using inguma =
+<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 ?egilea ?egilea_label ?wd ?wikidata ?inguma ?ing_wikidata
+where {
+  ?oocc_item ip:P89 ?oocc_st.
+  ?aipatzen_duena idp:P37 iwb:Q13228; idp:P62 [idp:P88* ?oocc_item].
+  ?aipatzen_duena idp:P19 ?data; idp:P17 ?egilea; idp:P10 ?title. filter(lang(?title)="eu")
+  ?egilea rdfs:label ?egilea_label. filter(lang(?egilea_label)="en")
+  optional {?egilea idp:P3 ?inguma.}
+  optional {
+   SERVICE <https://query.wikidata.org/sparql> {
+           select ?ing_wikidata ?inguma where
+                            {?ing_wikidata wdt:P7558 ?inguma.}
+   } }
+   optional {?egilea idp:P1 ?wd. bind(iri(concat(str(wd:),?wd)) as ?wikidata)}
+  }
 </sparql>