User:Xaris333/Cypriot ministers/Cyprus Ministers of Communications and Works

Cyprus Minister of Communications and Works (Q38112367)

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:Q38112367 }
  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:Q38112367 } 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	item	polignosi
Giorgos Lillikas	Cyprus Minister of Communications and Works	2004-04-15	2004-05-19	18	Kikis Kazamias	Haris Thrasou	Q694791	11092
Erato Kozakou Marcoullis	Cyprus Minister of Communications and Works	2010-03-02	2011-08-05	22	Nikos Nicolaides	Efthimios Flourentzou	Q2075776	11094
Kikis Kazamias	Cyprus Minister of Communications and Works	2003-03-01	2004-04-14	17	Averof Neofytou	Giorgos Lillikas	Q6406296	11082
Nikos Nicolaides	Cyprus Minister of Communications and Works	2008-02-29	2010-03-02	21	Maria Malactou Pampalli	Erato Kozakou Marcoullis	Q12912924	10045
Nikos Pattichis	Cyprus Minister of Communications and Works	1974-08-08	1975-01-14	5	Yiangos Zambarloukos	Georgios Tombazos	Q15230576	8626
Averof Neofytou	Cyprus Minister of Communications and Works	1999-08-25	2003-02-28	16	Leontios Ierodiakonou	Kikis Kazamias	Q15951474	11097
Tasos Mitsopoulos	Cyprus Minister of Communications and Works	2013-03-01	2014-03-14	24	Efthimios Flourentzou	Marios Demetriades	Q15975166	41512
Marios Demetriades	Cyprus Minister of Communications and Works	2014-03-14	2015-04-09	25	Tasos Mitsopoulos		Q16208000
Leontios Ierodiakonou	Cyprus Minister of Communications and Works	1997-04-09	1999-08-24	15	Adamos Adamides	Averof Neofytou	Q65092033	11317
Haris Thrasou	Cyprus Minister of Communications and Works	2004-05-19	2007-07-16	19	Giorgos Lillikas	Maria Malactou Pampalli	Q65117030	4476
Efthimios Flourentzou	Cyprus Minister of Communications and Works	2011-08-05	2013-02-28	23	Erato Kozakou Marcoullis	Tasos Mitsopoulos	Q65493356
Titos Phanos	Cyprus Minister of Communications and Works	1966-04-21	1970-06-30	2	Andreas Papadopoulos	Nikos Rousos	Q65496340	10646
Maria Malactou Pampalli	Cyprus Minister of Communications and Works	2007-07-16	2008-02-29	20	Haris Thrasou	Nikos Nicolaides	Q65552599	11099
Rois Nicolaides	Cyprus Minister of Communications and Works	1985-08-01	1988-02-27	10	Christos Mavrellis	Nakos Protopapas	Q65807461	7900
Georgios Tombazos	Cyprus Minister of Communications and Works	1975-01-15	1978-03-08	6	Nikos Pattichis	Marios Eliades	Q65948658	10355
Adamos Adamides	Cyprus Minister of Communications and Works	1993-02-28	1997-04-08	14	Renos Stavrakis	Leontios Ierodiakonou	Q66042085	1621
Andreas Papadopoulos	Cyprus Minister of Communications and Works	1960-08-16	1966-04-20	1		Titos Phanos	Q66309261	8502
Nikos Rousos	Cyprus Minister of Communications and Works	1970-07-01	1972-06-15	3	Titos Phanos	Yiangos Zambarloukos	Q66309262	9383
Marios Eliades	Cyprus Minister of Communications and Works	1978-03-09	1980-09-09	7	Georgios Tombazos	Georgios Chadjicostas	Q66309275	4149
Yiangos Zambarloukos	Cyprus Minister of Communications and Works	1972-06-16	1974-07-15	4	Nikos Rousos	Nikos Pattichis	Q66664147	3987
Christos Mavrellis	Cyprus Minister of Communications and Works	1982-04-20	1985-07-31	9	Georgios Chadjicostas	Rois Nicolaides	Q66711879	7202
Nakos Protopapas	Cyprus Minister of Communications and Works	1988-02-28	1990-05-03	11	Rois Nicolaides	Pavlos Savvides	Q66711882	9121
Georgios Chadjicostas	Cyprus Minister of Communications and Works	1980-09-12	1982-04-19	8	Marios Eliades	Christos Mavrellis	Q66736014	11043
Pavlos Savvides	Cyprus Minister of Communications and Works	1990-05-04	1991-11-22	12	Nakos Protopapas	Renos Stavrakis	Q66736019	10106
Renos Stavrakis	Cyprus Minister of Communications and Works	1991-11-25	1993-02-28	13	Pavlos Savvides	Adamos Adamides	Q66736023	10178

End of automatically generated list.