User:Data Gamer/Cypriot Mayors/Germasogeia Mayors

Mayor of Germasogeia Municipality (Q54865660)

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:Q54865660 }
  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:Q54865660 }   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
Kyriakos Xydias	Mayor of Germasogeia Municipality	2017-01-01		3	Andreas Gavrielides
Panicos Louroutziatis	Mayor of Germasogeia Municipality	1994-05-01 1997-01-01 2002-01-01	1996-12-31 2001-12-31 2006-12-31	1		Andreas Gavrielides
Andreas Gavrielides	Mayor of Germasogeia Municipality	2007-01-01 2012-01-01	2011-12-31 2016-12-31	2	Panicos Louroutziatis	Kyriakos Xydias

End of automatically generated list.