80,516
edits
Querying: Difference between revisions
→Cleanup queries
(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" } | |||
} | } | ||