wikidata_island_of_indonesia_with_sitelink_in_any_language.sparql

SELECT DISTINCT ?item ?itemLabel ?administrativeLabel ?sitelink ?lang ?geonamesId
WHERE {
  ?item wdt:P31/wdt:P279* wd:Q23442.
  {
    {
      ?wilayahDiIndonesia wdt:P279 wd:Q1434505.
      ?administrative wdt:P31/wdt:P279* ?wilayahDiIndonesia.
      ?item wdt:P131 ?administrative.
    } UNION {
      ?item wdt:P17 wd:Q252
    }
  }
  ?sitelink schema:about ?item .
  ?sitelink schema:inLanguage ?lang .
  FILTER (?lang = 'ceb').
  ?item wdt:P1566 ?geonamesId
  SERVICE wikibase:label { bd:serviceParam wikibase:language "id,en". }
} ORDER BY ?item