Table:
text: Coleraine Borough Council
Mayor of Coleraine
Mayor of Coleraine
Year_ Name_ Political_affiliation Deputy Deputy_s_affiliation
1992–93 William King Ulster Unionist James McClure Democratic Unionist
1993–1995 David McClarty Ulster Unionist William Matthews Alliance
1995–97 Pauline Armitage Ulster Unionist John Dallat SDLP
1997–99 James McClure Democratic Unionist William Matthews Alliance
1997–99 James McClure Democratic Unionist Elizabeth Johnston Ulster Unionist
1999–2000 Norman Hillis Ulster Unionist Olive Church Ulster Unionist
2000–01 Elizabeth Johnston Ulster Unionist Barbara Dempsey Alliance
2001–02 John Dallat SDLP Desmond Stewart Democratic Unionist
2002–03 Olive Church Ulster Unionist Gerry McLaughlin SDLP
2003–04 Desmond Stewart Democratic Unionist Eamon Mullan SDLP
2004–2005 Robert McPhearson Ulster Unionist James McClure Democratic Unionist
2005–06 Timothy Deans Democratic Unionist Maura Hickey SDLP
2006–07 William King Ulster Unionist Ellen Fielding Democratic Unionist

Question: What is the name of Coleraine Borough Council 1997–99?

Question: What is MP John Dallat's political affiliation with Coleraine Borough Council?

Question: What is the name of the Coleraine Borough Council deputy in 1992–93?

Question: What is the MP's affiliation with Coleraine Borough Council in 1992-93?