Topic on User talk:TomT0m

Hello, je ne sais pas si tu te souviens de cette requête mais elle ne semble plus marcher, une idée ? :

select ?country (group_concat(?NatureLabelFr;separator=" ,") as ?NatureLabelFr) ?countryLabel  ?creationDate ?dissolutionDate
with {
select ?country (coalesce(?countryLabelFr, ?countryLabelEn,  ?country) as ?countryLabel) ?creationDate ?dissolutionDate{
?country wdt:P31/wdt:P279* wd:Q3624078 # sovereign states, I don’t know if it’s the right item
MINUS { ?country (wdt:P31/wdt:P279*) wd:Q1790360. }#empires coloniaux
MINUS { ?country (wdt:P31/wdt:P279*) wd:Q1371288. } #états vassals
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

Try it!

Oui, cf. https://query.wikidata.org/#select%20%3Fcountry%20%28group_concat%28%3FNatureLabelFr%3Bseparator%3D%22%20%2C%22%29%20as%20%3FNatureLabel%29%20%3FcountryLabel%20%20%3FcreationDate%20%3FdissolutionDate%0Awith%20%7B%0Aselect%20%3Fcountry%20%28coalesce%28%3FcountryLabelFr%2C%20%3FcountryLabelEn%2C%20%20%3Fcountry%29%20as%20%3FcountryLabel%29%20%3FcreationDate%20%3FdissolutionDate%7B%0A%3Fcountry%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ3624078%20%23%20sovereign%20states%2C%20I%20don%E2%80%99t%20know%20if%20it%E2%80%99s%20the%20right%20item%0AMINUS%20%7B%20%3Fcountry%20%28wdt%3AP31%2Fwdt%3AP279%2a%29%20wd%3AQ1790360.%20%7D%23empires%20coloniaux%0AMINUS%20%7B%20%3Fcountry%20%28wdt%3AP31%2Fwdt%3AP279%2a%29%20wd%3AQ1371288.%20%7D%20%23%C3%A9tats%20vassals%0Aoptional%20%7B%20%3Fcountry%20rdfs%3Alabel%20%3FcountryLabelFr%20filter%28lang%28%3FcountryLabelFr%29%3D%20%22fr%22%29%7D%20.%0Aoptional%20%7B%20%3Fcountry%20rdfs%3Alabel%20%3FcountryLabelEn%20filter%28lang%28%3FcountryLabelEn%29%3D%20%22en%22%29%7D%0Aoptional%20%7B%20%3Fcountry%20wdt%3AP571%20%3FcreationDate%20%7D%0Aoptional%20%7B%20%3Fcountry%20wdt%3AP576%20%3FdissolutionDate%20%7D%0A%7D%20order%20by%20%3FcountryLabel%0A%7D%20as%20%25datas%0Awhere%20%7B%0Ainclude%20%25datas%20.%0Aoptional%7B%0A%3Fcountry%20wdt%3AP31%2Frdfs%3Alabel%20%3FNatureLabelFr%20filter%28lang%28%3FNatureLabelFr%29%3D%20%22fr%22%29%20.%0A%7D%0A%7D%20group%20by%20%3Fcountry%20%3FcountryLabel%20%20%3FcreationDate%20%3FdissolutionDate