Querying: Difference between revisions

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