User:Data Gamer/Cypriot Mayors/Mesa Geitonia Mayors

Mayor of Mesa Geitonia Municipality (Q54864785)

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:Q54864785 }
  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!

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:Q54864785 }   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
Christos Messis	Mayor of Mesa Geitonia Municipality	2002-01-01 2007-01-01	2006-12-31 2011-06-01	3	Stelios Makrides	Doros Antoniou
Doros Antoniou	Mayor of Mesa Geitonia Municipality	2012-01-01 2017-01-01	2016-12-31	4	Christos Messis
Stelios Makrides	Mayor of Mesa Geitonia Municipality	1997-01-01	2001-12-31	2	Georgios Christoforou	Christos Messis
Georgios Christoforou	Mayor of Mesa Geitonia Municipality	1986-06-01 1992-01-01	1991-12-31 1996-12-31	1		Stelios Makrides

End of automatically generated list.