Ziterauzi KM: Difference between revisions

Line 32: Line 32:
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/>


select ?oocc_item ?oocc_id ?oocc_title (group_concat(?lehen_arg) as ?lehen_argi) ?oocc_text ?jatorrizkoa (year(?jat_data) as ?jat_urtea)
select ?oocc_item ?zotero_link ?oocc_id ?oocc_title (group_concat(?lehen_arg) as ?lehen_argi) ?oocc_text ?jatorrizko_argitalpena
where {
where {
   ?oocc_item ip:P89 ?oocc_st.
   ?oocc_item ip:P89 ?oocc_st.
Line 40: Line 40:
   ?oocc_item idp:P10 ?oocc_title.
   ?oocc_item idp:P10 ?oocc_title.
   optional {
   optional {
     ?oocc_item idp:P90 ?jatorrizkoa.
     ?oocc_st ipq:P91 ?jatorria.
     ?jatorrizkoa idp:P19 ?jat_data.
     bind(iri(concat(str(iwb:),?jatorria)) as ?jatorrizko_argitalpena)
  }
  }
  optional {
    ?oocc_item idp:P71 ?zotero.
    bind(iri(concat("https://www.zotero.org/groups/5597887/ziterauzi/items/",?zotero,"/item-details")) as ?zotero_link)
    }
  }   
  }   
group by ?oocc_item ?oocc_id ?oocc_title ?lehen_argi ?oocc_text ?jatorrizkoa ?jat_data
group by ?oocc_item ?zotero_link ?oocc_id ?oocc_title ?lehen_argi ?oocc_text ?jatorrizko_argitalpena
order by xsd:integer(?oocc_id)
order by xsd:integer(?oocc_id)
</sparql>
</sparql>
Bureaucrats, emailconfirmed, Administrators
54,405

edits