query-9c4b84a6bc37de8fef5f5c3e930116ae

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 16 Jamaica Patrick Allen 16 State of Palestine Mahmoud Abbas 18 Nicaragua Daniel Ortega 18 Bhutan Jigme Khesar Namgyel Wangchuck 19 Togo Faure Essozimna Gnassingbé 20 Monaco Albert II, Prince of Monaco 20 Cambodia Norodom Sihamoni 21 Azerbaijan Ilham Aliyev 21 Andorra Joan Enric Vives Sicília 24 Luxembourg Henri, Grand Duke of Luxembourg 24 Syria Bashar al-Assad 24 Rwanda Paul Kagame 25 Morocco Mohammed VI of Morocco 25 Djibouti Ismail Omar Guelleh 26 Bahrain Hamad II of Bahrain 26 Jordan Abdullah II of Jordan 27 Republic of the Congo Denis Sassou-Nguesso 29 Lesotho Letsie III of Lesotho 30 Tajikistan Emomali Rahmon 30 Belarus Alexander Lukashenko 31 Eritrea Isaías Fortis 34 Norway Harald V of Norway 35 Liechtenstein Hans-Adam II, Prince of Liechtenstein 35 Iran Ali Khamenei 38 Eswatini Mswati III 39 Uganda Yoweri Museveni 42 Cameroon Paul Biya 45 Equatorial Guinea Teodoro Obiang 51 Sweden Carl XVI Gustaf of Sweden 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

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:P1906 ?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

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?country"):::projected v3("?end_date") v6("?item"):::projected v5("?office") v2("?posn") v1("?start_date") v7("?years"):::projected c3(["wd:Q3624078"]):::iri c10(["bd:serviceParam"]):::iri c5(["wd:Q5"]):::iri c12(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"p:qualifier/P582"--> e0v2 e0v2("?end_date"):::projected e0v1("?posn"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> v3 v2 --"p:qualifier/P582"--> v3 v4 --"p:direct/P31"--> c3 v4 --"p:direct/P1906"--> v5 v6 --"p:direct/P31"--> c5 v6 --"p:P39"--> v2 v2 --"p:statement/P39"--> v5 v2 --"p:qualifier/P580"--> v1 bind1[/"numeric-round(NOW() - ?start_date / '365.2425^^xsd:decimal')"/] v1 --o bind1 bind1 --as--o v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end