Ziterauzi KM: Difference between revisions

Ziterauzi KM (view source)

973 bytes added , 1 month ago

54,405

edits

@@ Line 138: / Line 138: @@
         SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". }
        }
+</sparql>
+=== Zenbat aipu du KM-en lan bakoitzak? ===
+<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 (count(?aipatzen_duena) as ?zenbat_aipu) ?oocc_item ?oocc_id ?oocc_title
+where {
+  ?oocc_item ip:P89 ?oocc_st.
+  ?oocc_st ips:P89 ?oocc_id.
+  ?oocc_item idp:P10 ?oocc_title.
+  ?oocc_st ipq:P91 ?jatorria. bind(iri(concat(str(iwb:),?jatorria)) as ?jatorrizko_argitalpena)
+  {?aipatzen_duena idp:P62 ?jatorrizko_argitalpena.} union {?aipatzen_duena idp:P62 ?oocc_item.}
+  ?aipatzen_duena idp:P19 ?data; idp:P17 [rdfs:label ?egileaLabel]. filter(lang(?egileaLabel)="eu")
+ SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". }
+}
+group by ?zenbat_aipu ?oocc_item ?oocc_id ?oocc_title
+order by desc(?zenbat_aipu)
 </sparql>