query-7dc259956bc4f6580b626710a903ad53

rq turtle/ttl

TODO

Use at

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#>
tr Je crois select ?country (group_concat(?NatureLabelFr;separator=" ,") as ?NatureLabelFr) ?countryLabel  ?creationDate ?dissolutionDate

with {
  select ?country (coalesce(?countryLabelEn, ?countryLabelFr,  ?country) as ?countryLabel) ?creationDate ?dissolutionDate{
     ?country wdt:P31/wdt:P279* wd:Q3624078 # sovereign states, I don’t know if it’s the right item

     optional { ?country rdfs:label ?countryLabelFr filter(lang(?countryLabelFr)= "fr")} .
     optional { ?country rdfs:label ?countryLabelEn filter(lang(?countryLabelEn)= "en")}
     optional { ?country wdt:P571 ?creationDate }
     optional { ?country wdt:P576 ?dissolutionDate }

  } order by ?countryLabel
} as %datas

where {
  include %datas .
  optional{
      ?country wdt:P31/rdfs:label ?NatureLabelFr filter(lang(?NatureLabelFr)= "fr") .
  }
} group by ?country ?countryLabel  ?creationDate ?dissolutionDate

Query found at