Querying: Difference between revisions

(cleaning query)
Line 174: Line 174:
   OPTIONAL {?seat rdfs:label ?seat_ar filter (lang(?seat_ar) = "ar")}.   
   OPTIONAL {?seat rdfs:label ?seat_ar filter (lang(?seat_ar) = "ar")}.   
    
    
}
=== Seats without geolocation ===
Wikidata ID can be used to supply geolocation. [https://tinyurl.com/273jk9c4 run]
SELECT ?sancak ?sancakLabel ?seat ?seatLabel ?wikidata
WHERE
{
  ?sancak ogt:P15 og:Q4.
  ?sancak ogt:P14 ?seat.
  MINUS {?seat ogt:P10 ?geo.}
  OPTIONAL {?seat ogt:P3 ?wikidata.} 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
  }
  }