User:Data Gamer/Cypriot Mayors/Agia Napa Mayors

Mayor of Agia Napa (Q56459504)

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:Q56459504 }
  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:Q28077811 }   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
Alexis Galanos	Mayor of Famagusta	2007-01-01 2012-01-01 2017-01-01	2011-12-31 2016-12-31 2019-07-15	12	Yannakis Skordis	Simos Ioannou
Kikis Kazamias	Mayor of Famagusta	2002-01-01	2003-02-28	10	Andreas Pouyiouros	Yannakis Skordis
Andreas Pouyiouros	Mayor of Famagusta	1953-01-01 1964-01-01 1992-01-01 1997-01-01	1963-01-01 1978-01-01 1996-12-31 2001-12-31	8	Adam Adamantos Prodromos Papavasileiou	Prodromos Papavasileiou Kikis Kazamias
Simos Ioannou	Mayor of Famagusta	2019-08-26		13	Alexis Galanos
Adam Adamantos	Mayor of Famagusta	1943-01-01	1953-01-01	7	Georgios Emfietzis	Andreas Pouyiouros
Yannakis Skordis	Mayor of Famagusta	2003-03-01	2006-12-31	11	Kikis Kazamias	Alexis Galanos
Sotirios Michaelides Emfietzis	Mayor of Famagusta	1878-01-01 1882-01-01	1879-01-01 1886-01-01	1	Evaggelis Loizou	Evaggelis Loizou Loukas Georgiou
Evaggelis Loizou	Mayor of Famagusta	1879-01-01	1882-01-01	2	Sotirios Michaelides Emfietzis	Sotirios Michaelides Emfietzis
Loukas Georgiou	Mayor of Famagusta	1886-01-01 1905-01-01 1910-01-01	1887-01-01 1906-01-01 1916-01-01	3	Sotirios Michaelides Emfietzis Chrisostomos Loizou Louis Louizou	Chrisostomos Loizou Georgios Emfietzis
Chrisostomos Loizou	Mayor of Famagusta	1887-01-01 1906-01-01	1893-01-01 1907-01-01	4	Loukas Georgiou	Loukas Georgiou Louis Louizou
Louis Louizou	Mayor of Famagusta	1907-01-01	1910-01-01	5	Chrisostomos Loizou	Loukas Georgiou
Georgios Emfietzis	Mayor of Famagusta	1916-01-01	1943-01-01	6	Loukas Georgiou	Adam Adamantos
Prodromos Papavasileiou	Mayor of Famagusta	1978-01-01	1987-01-01	9	Andreas Pouyiouros	Andreas Pouyiouros

End of automatically generated list.