80,516
edits
Querying: Difference between revisions
→Cleanup queries
| Line 186: | Line 186: | ||
MINUS {?seat ogt:P10 ?geo.} | MINUS {?seat ogt:P10 ?geo.} | ||
OPTIONAL {?seat ogt:P3 ?wikidata.} | OPTIONAL {?seat ogt:P3 ?wikidata.} | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | |||
} | |||
=== Seats without regions === | |||
During the initial setup, certain regions listed seats, but there was no reciprocal listing of region for the seat items. This query includes date qualifiers, where present. [https://tinyurl.com/228d48rc run] | |||
SELECT ?region ?regionLabel ?seat ?seatLabel ?starttime ?endtime ?latestdate | |||
WHERE | |||
{ | |||
?region ogt:P14 ?seat. | |||
MINUS {?seat ogt:P11 ?region.} | |||
OPTIONAL { | |||
?region ogp:P14 ?statement. | |||
?statement ogps:P14 ?seat. | |||
?statement ogpq:P7 ?starttime. | |||
OPTIONAL { ?statement ogpq:P8 ?endtime.} | |||
OPTIONAL { ?statement ogpq:P22 ?latestdate.} | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | ||
} | } | ||