query-616d1292980fbd0280c676a55babbc4c

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 27 State of Palestine Mohammad Mustafa 27 Democratic Republic of the Congo Judith Tuluka Suminwa 27 Portugal Luís Montenegro 27 Senegal Bassirou Diomaye Diakhar Faye 26 Iceland Bjarni Benediktsson 26 Ireland Simon Harris 22 Solomon Islands Jeremiah Manele 22 Serbia Miloš Vučević 21 Singapore Lawrence Wong 21 Kuwait Ahmad Al Abdullah Al Sabah 20 Taiwan Cho Jung-tai 15 North Macedonia Hristijan Mickoski 14 Panama José Raúl Mulino 14 Kingdom of the Netherlands Dick Schoof 13 United Kingdom Keir Starmer 12 Nepal Khadga Prasad Sharma Oli 11 Estonia Kristen Michal 10 Iran Masoud Pezeshkian 8 Tunisia Kamel Madouri 7 Thailand Paetongtarn Shinawatra 7 Equatorial Guinea Manuel Osa Nsue Nsua 6 Bulgaria Dimitar Glavchev 5 Monaco Didier Guillaume 4 France Michel Barnier 3 Syria Mohammad Ghazi al-Jalali 3 Jordan Jafar A Hassan 2 Sri Lanka Anura Kumara Dissanayake 1 Japan Shigeru Ishiba 1 Mexico Claudia Sheinbaum -2 Indonesia Prabowo Subianto Weeks 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 ?weeks
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)/7) AS ?weeks)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?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("?weeks"):::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/P1313"--> 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 / '7^^xsd:integer')"/] v1 --o bind1 bind1 --as--o v7 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 end