query-5f477e270f2afae838657c54c64523f8

rq turtle/ttl

| Query: Recent changes | Find images | TABernacle | PetScan | WDQS . Manual changes to the list will be removed on the next update! a botThis list is periodically updated by Manually update list 7 Angola João Lourenço 7 Rwanda Édouard Ngirente 8 Mauritius Pravind Jugnauth 8 The Gambia Adama Barrow 8 Uzbekistan Abdulla Nigmatovich Aripov 8 Croatia Andrej Plenković 8 Yemen Abdel-Aziz bin Habtour 8 Cape Verde Ulisses Correia e Silva 9 Benin Patrice Talon 9 Kiribati Taneti Maamau 9 Jamaica Andrew Holness 9 Canada Justin Trudeau 9 Trinidad and Tobago Keith Rowley 10 Namibia Saara Kuugongelwa 10 Indonesia Joko Widodo 10 Turkey Recep Tayyip Erdoğan 10 Antigua and Barbuda Gaston Browne 10 India Narendra Modi 11 Tajikistan Kokhir Rasulzoda 11 Albania Edi Rama 12 Djibouti Abdoulkader Kamil Mohamed 12 Venezuela Nicolás Maduro 13 South Sudan Salva Kiir Mayardit 14 Hungary Viktor Orbán 18 Nicaragua Daniel Ortega 19 United Arab Emirates Mohammed bin Rashid Al Maktoum 21 Dominica Roosevelt Skerrit 24 Saint Vincent and the Grenadines Ralph Gonsalves 31 Eritrea Isaías Fortis 57 Brunei Hassanal Bolkiah I of Brunei Years Country Person image End of automatically generated list.The underlying query that generates this report is:

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 DISTINCT ?item ?itemLabel ?country ?countryLabel ?years
WHERE {      
  ?country wdt:P31 wd:Q3624078 ; wdt:P1313 ?office .
  ?item wdt:P31 wd:Q5 ; p:P39 ?posn .
  ?posn ps:P39 ?office ; pq:P580 ?start_date .
  FILTER NOT EXISTS { ?posn pq:P582 ?end_date }
  BIND(ROUND((NOW() - ?start_date)/365.2425) AS ?years)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?start_date
LIMIT 30

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Heads_of_state_and_government/Longest_Heads_of_Government