Bureaucrats, emailconfirmed, Administrators
56,015
edits
KM Wikidata export: Difference between revisions
→Export OOCC articles (for oocc-to-wikidata.py)
| Line 112: | Line 112: | ||
PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | PREFIX ipq: <https://wikibase.inguma.eus/prop/qualifier/> | ||
select distinct ?oocc_item ?title (group_concat(distinct concat('"',?sordinal,'": "',?wd_egilea,'"'); SEPARATOR=", ") as ?wd_egileak) | select distinct ?oocc_item ?title (lang(?title) as ?title_lang) ?wd_lang (group_concat(distinct concat('"',?sordinal,'": "',?wd_egilea,'"'); SEPARATOR=", ") as ?wd_egileak) | ||
?pag ?oocc | ?pag ?oocc (count(?citing) as ?citations) (min(?old_date) as ?data) ?wd_container ?oocc_wd | ||
where { | where { | ||
| Line 121: | Line 121: | ||
?citing idp:P62 ?km_item. | ?citing idp:P62 ?km_item. | ||
?km_item idp:P19 ?old_date. | ?km_item idp:P19 ?old_date. | ||
?oocc idp:P1 ? | ?oocc idp:P1 ?wd_container. | ||
?oocc_item idp:P19 ?data; ip:P17 ?creator_st. | ?oocc_item idp:P19 ?data; ip:P17 ?creator_st. | ||
optional {?creator_st ips:P17 ?egilea.} | optional {?creator_st ips:P17 ?egilea.} | ||
optional {?creator_st ipq:P36 ?sordinal.} | optional {?creator_st ipq:P36 ?sordinal.} | ||
?oocc_item idp:P10 ?title. | ?oocc_item idp:P10 ?title. | ||
?oocc_item idp: | ?oocc_item idp:P16 [idp:P1 ?wd_lang]. | ||
?egilea idp:P1 ?wd_egilea. | ?egilea idp:P1 ?wd_egilea. | ||
# filter not exists {?oocc_item idp:P1 ?wd.} | # filter not exists {?oocc_item idp:P1 ?wd.} | ||
| Line 133: | Line 133: | ||
optional {?oocc_item idp:P26 ?issue.} | optional {?oocc_item idp:P26 ?issue.} | ||
optional {?oocc_item idp:P80 ?pag.} | optional {?oocc_item idp:P80 ?pag.} | ||
optional {?oocc_item idp:P1 ?oocc_wd.} | |||
} | } | ||
group by ?oocc_item ?title ?wd_egileak ?pag ?oocc | group by ?oocc_item ?title ?wd_lang ?wd_egileak ?pag ?oocc ?citations ?data ?wd_container ?oocc_wd | ||
order by desc(?citations) | order by desc(?citations) | ||
</sparql> | </sparql> | ||