Ziterauzi KM: Difference between revisions

Ziterauzi KM (view source)

260 bytes removed , 1 month ago

58,048

edits

@@ Line 156: / Line 156: @@
 === Zenbat aipu du KM-en lan bakoitzak? ===
 <sparql tryit="1">
+#defaultView:BubbleChart
 PREFIX iwb: <https://wikibase.inguma.eus/entity/>
 PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
@@ Line 162: / Line 163: @@
 PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>
-select (count(?aipatzen_duena) as ?zenbat_aipu) ?oocc_item ?oocc_id ?oocc_title
+select ?oocc_item  ?oocc_itemLabel (count(?aipatzen_duena) as ?zenbat_aipu)
 where {
    ?oocc_item ip:P89 ?oocc_st.
    ?oocc_st ips:P89 ?oocc_id.
-   ?oocc_item idp:P10 ?oocc_title.
+   ?aipatzen_duena idp:P62 [idp:P88* ?oocc_item].
-  ?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
+group by ?oocc_item ?oocc_itemLabel ?zenbat_aipu
 order by desc(?zenbat_aipu)
 </sparql>