wikdata_island_with_references.sparql

SELECT DISTINCT ?item ?itemLabel ?geonamesId ?coordinate
WHERE {
  ?item wdt:P31/wdt:P279* wd:Q23442.
  ?item wdt:P17 wd:Q252 .
  ?item wdt:P625 ?coordinate

  # Remove any triples that has reference in their coordinate
  MINUS {
    ?item p:P625 ?coordinateStatement .
    ?coordinateStatement prov:wasDerivedFrom ?ref .
    ?ref ?anyReference ?value .
  }

  ?sitelink schema:about ?item .
  ?sitelink schema:inLanguage 'ceb' .
  ?item wdt:P1566 ?geonamesId
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id,en". }
}
ORDER BY ?item