Querying: Difference between revisions

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" }
  }
  }