User:Data Gamer/Cypriot Mayors/Aglantzia Mayors

Mayor of Aglantzia (Q56459585)

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:Q56459585 }
  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:Q56459585 }   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
Charalambos Petrides	Mayor of Aglantzia	2017-01-01	2020-06-28	3	Kostas Kortas	Andreas Konstantinou
Andreas Petrou	Mayor of Aglantzia	1986-06-01 1992-01-01 1997-01-01 2002-01-01 2007-01-01	1991-12-31 1996-12-31 2001-12-31 2006-12-31 2011-12-31	1		Kostas Kortas
Kostas Kortas	Mayor of Aglantzia	2012-01-01	2016-12-31	2	Andreas Petrou	Charalambos Petrides
Andreas Konstantinou	Mayor of Aglantzia	2020-08-03		4	Charalambos Petrides

End of automatically generated list.