query-fab9e56c8de7d66e5a5d32a9bded9477

rq turtle/ttl

Search for missing descriptions in a target language and match with description string SELECT DISTINCT ?item ?itemLabel ?itemDescription ?datePrix ?itemPrenomLabel ?itemNomLabel ?itemGenreLabel ?itemNaissanceLabel ?cityPopulation ?itemDateNaissance ?prixLabel WHERE { ?item wdt:P31 wd:Q5. # instance of human OPTIONAL {?item wdt:P735 ?itemPrenom.} OPTIONAL {?item wdt:P734 ?itemNom.} OPTIONAL {?item wdt:P21 ?itemGenre.} ?item wdt:P19 ?itemNaissance.

?itemNaissance wdt:P1082 ?population .

# Now select the population value of the ?city # (wdt: properties use only statements of "preferred" rank if any, usually meaning "current population") ?itemNaissance p:P1082 ?populationStatement . ?populationStatement ps:P1082 ?cityPopulation. ?populationStatement pq:P585 ?date FILTER NOT EXISTS { ?itemNaissance p:P1082/pq:P585 ?date_ . FILTER (?date_ > ?date) }

OPTIONAL {?item wdt:P569 ?itemDateNaissance.}

?item p:P166 ?award_statement . ?award_statement ps:P166 ?prix . ?prix wdt:P361 wd:Q3405853 . OPTIONAL {?award_statement pq:P585 ?datePrix.} OPTIONAL {?award_statement prov:wasDerivedFrom ?ref}

SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }

}

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 prov: <http://www.w3.org/ns/prov#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Search for missing descriptions in a target language and match with description string
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?datePrix ?itemPrenomLabel ?itemNomLabel ?itemGenreLabel ?itemNaissanceLabel ?cityPopulation ?itemDateNaissance ?prixLabel WHERE {
  ?item wdt:P31 wd:Q5.  # instance of human
  OPTIONAL {?item wdt:P735 ?itemPrenom.}
  OPTIONAL {?item wdt:P734 ?itemNom.}
  OPTIONAL {?item wdt:P21 ?itemGenre.}
  ?item wdt:P19 ?itemNaissance.
#  ?itemNaissance wdt:P1082 ?population .


  # Now select the population value of the ?city
 # (wdt: properties use only statements of "preferred" rank if any, usually meaning "current population")
   ?itemNaissance p:P1082 ?populationStatement .
   ?populationStatement ps:P1082 ?cityPopulation.
   ?populationStatement pq:P585 ?date
   FILTER NOT EXISTS { ?itemNaissance p:P1082/pq:P585 ?date_ . FILTER (?date_ > ?date) } 

  OPTIONAL {?item wdt:P569 ?itemDateNaissance.}

  ?item p:P166 ?award_statement .
  ?award_statement ps:P166 ?prix .
  ?prix wdt:P361 wd:Q3405853 . 
  OPTIONAL {?award_statement pq:P585 ?datePrix.} 
  OPTIONAL {?award_statement prov:wasDerivedFrom ?ref}


 SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }

}

Query found at

• https://www.wikidata.org/wiki/User:Dirac/Prix_du_Qu%C3%A9bec