User:Data Gamer/Cypriot Mayors/Ypsonas Mayors

Mayor of Ypsonas Municipality (Q54263502)

Some mayors were in office two or three non-continuous term. This is not showing in the list. The check can be done with query.

SELECT ?officeLabel ?item ?itemLabel ?itemDescription ?start ?end ?order ?predecessorLabel ?successorLabel ?ordernumber
{
  ?item p:P39 ?fc_stmt .
  ?fc_stmt ps:P39 ?office ; pq:P580 ?start  .
  values ?office { wd:Q54263502 }
  optional { ?fc_stmt pq:P582 ?end } 
  optional { ?fc_stmt pq:P1545 ?order 
    bind(if(strlen(str(?order))=1,concat("0",?order),?order) as  ?ordernumber)            
           }
  optional { ?fc_stmt  pq:P1365 ?predecessor }
  optional { ?fc_stmt  pq:P1366 ?successor}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} order by ?ordernumber

Try it!

Manually update list

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT ?office ?item ?itemLabel ?itemDescription ?start ?end ?order ?predecessor ?successor { ?item p:P39 ?fc_stmt . ?fc_stmt ps:P39 ?office ; pq:P580 ?start . values ?office { wd:Q54263502 } optional { ?fc_stmt pq:P582 ?end . } optional { ?fc_stmt pq:P1545 ?order . bind(if(strlen(str(?order))=1,concat("0",?order),?order) as ?ordernumber) } optional { ?fc_stmt pq:P1365 ?predecessor . } optional { ?fc_stmt pq:P1366 ?successor . } } order by ?start

Wikidata	?office	?start	?end	?order	?predecessor	?successor
Pantelis Eftychiou Georgiou	Mayor of Ypsonas Municipality	2017-01-01		2	Aristos Aristeidou
Aristos Aristeidou	Mayor of Ypsonas Municipality	2012-01-01	2016-12-31	1		Pantelis Eftychiou Georgiou

End of automatically generated list.