80,516
edits
Querying: Difference between revisions
→Cleanup queries
| Line 218: | Line 218: | ||
OPTIONAL { ?statement ogpq:P22 ?latestdate.} | OPTIONAL { ?statement ogpq:P22 ?latestdate.} | ||
} | } | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | |||
} | |||
== Regions without status statements === | |||
Useful for finding errors in bulk uploads [https://tinyurl.com/2y26wh6q run] | |||
SELECT ?region ?regionLabel | |||
WHERE | |||
{ | |||
?region ogt:P6 og:Q1. | |||
MINUS {?region ogp:P15 ?statement.} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } | ||
} | } | ||