query-caa50df132a1ab9509335b84a357b71e

rq turtle/ttl

Propertiesinstance of (P31)subclass of (P279)located in the administrative territorial entity (P131)successful candidate (P991)point in time (P585)

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 ?desc ?state ?stateLabel ?eyear ?member ?memberLabel 
WHERE {
  BIND(wd:Q22048 as ?state) # Odisha
  BIND (wd:Q3532431 as ?name)
  BIND (wd:Q3429959 as ?constituency)
  ?item wdt:P31/wdt:P279* ?constituency. # constituency
  ?item p:P131 ?statement . # get state name   
  ?item wdt:P131 ?state .    
   ?item p:P585 [
        ps:P585 ?eyear ;
        pq:P991 ?member;
   ].

  #Filter (year(?eyear) = 2014) .
  #optional{?item wdt:P991 ?member  .}

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   OPTIONAL {
     ?item rdfs:label ?desc filter (lang(?desc) = "en").
   }  
}

Query found at

• https://www.wikidata.org/wiki/User:MKar/Query