KM Wikidata export: Difference between revisions

Line 77: Line 77:
   }   
   }   
</sparql>
</sparql>
= Find KM items not linked to OOCC =
<sparql tryit="1">
PREFIX iwb: <https://wikibase.inguma.eus/entity/>
PREFIX idp: <https://wikibase.inguma.eus/prop/direct/>
select ?older ?olderLabel
where {?aip idp:P62 ?older. ?older idp:P17 iwb:Q201.
      filter not exists {?older idp:P88 ?oocc .} # exclude items linked to OOCC
      filter not exists {?older idp:P89 ?oocc_id .} # exclude OOCC items themselves
      filter not exists {?contained idp:P42 ?older .} # exclude containers
     
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en,eu". }
      } group by ?older ?olderLabel
</sparql>
= Export ASJU articles (for articles-to-wikidata.py) =
= Export ASJU articles (for articles-to-wikidata.py) =
<sparql tryit="1">
<sparql tryit="1">
Bureaucrats, emailconfirmed, Administrators
58,049

edits