query-7e7072428ebdb41002c3cd36961d663d
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?commune ?communeLabel ?start ?lp WHERE
{
{
SELECT ?item (MAX(?start_) as ?start)
WHERE
{
?item wdt:P31 wd:Q747074.
OPTIONAL { ?item p:P131 ?stat .
?stat ps:P131 ?commune .
OPTIONAL { ?stat pq:P580 ?start_ . }
OPTIONAL { ?commune wdt:P395 ?lp . } }
BIND(IF(!BOUND(?start_),now(),?start_) as ?start_)
FILTER(BOUND(?lp))
} GROUP BY ?item } ?item wdt:P31 wd:Q747074.
OPTIONAL { ?item p:P131 ?stat .
?stat ps:P131 ?commune .
OPTIONAL { ?stat pq:P580 ?start_ . }
OPTIONAL { ?commune wdt:P395 ?lp . } }
BIND(IF(!BOUND(?start_),now(),?start_) as ?start_)
FILTER(BOUND(?lp))
FILTER(?start = ?start_)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}