General Elections
Cambridge Bay

Community: Cambridge Bay

Returning Officer:

 Awaiting appointment


Office Details:

 


Current MLA:

Keith Peterson


 
 
SELECT tblMapDir.ID, strTitle, tblMapLocations.strName as strName, fkLocation,dtYear,tblMapDir.strDescription,dtDate,strImage1,strImage2,strImage3,strImage4,strPDF1,strPDF2,strPDF3,strPDF4,tblMapDir.blnActive,tblI18nText.strName as strCategory FROM tblMapDir LEFT JOIN tblMapLocations ON tblMapDir.fkLocation = tblMapLocations.ID LEFT JOIN tblCategories on tblCategories.ID=tblMapDir.fkCategory LEFT JOIN tblI18nText on tblI18nText.fkForeign=tblCategories.ID and tblI18nText.fkLanguage=1 LEFT JOIN tblGroups on tblGroups.ID=tblCategories.fkGroup WHERE tblMapDir.blnActive = 1 AND tblMapDir.fkLanguage=1 AND tblMapLocations.strName='Cambridge Bay' ORDER BY tblCategories.ID,tblMapDir.fkLocation, tblMapDir.dtDate DESC