Current Consolidated Statutes and Regulations
Important Notice:
Not all the legislation of Nunavut is available as an up-to-date consolidation.
See Help for instruction on how to find the documents you need.
select f.ID, f.fkDocumentGroup, t.strName as strCategory, f.strFileName, ff.strFileName as strAltFileName, ff.fkLanguageID as idLang, l.strLanguage, f.strThumbnail, f.dtUploaded, f.strTitle, f.strAnnotation, f.strDescription, UPPER(t.strName || '/' || f.strDspOrder || f.strTitle) as strKey from tblCategories c LEFT JOIN tblUploadFile f ON c.ID = f.fkCategoryID and f.fkLanguageID = 1 LEFT JOIN tblI18nText t on t.fkForeign=f.fkCategoryID and t.fkLanguage=1 LEFT JOIN tblUploadFile ff on f.fkDocumentGroup = ff.fkDocumentGroup LEFT JOIN tblLanguages l on l.ID=ff.fkLanguageID WHERE c.blnActive = 1 AND f.blnActive=1 AND t.strName || '/.' LIKE 'Consolidated Law/Current/%' and t.strName || '/' || f.strTitle LIKE 'Consolidated Law/Current/M%' order by strKey COLLATE utf8_unicode_ci,ID,idLang
MEDICAL PROFESSION ACT, Consolidation of
Note: This consolidation is not up-to-date. See S.Nu. 2008,c.18,s.59.
Français
MENTAL HEALTH ACT, Consolidation of
Note: This consolidation is not up-to-date. See S.Nu. 2008,c.17,s.47.
Français
MINE HEALTH AND SAFETY ACT, Consolidation of
Note: This consolidation is not up-to-date. See S.Nu. 2007,c.15,s.177(Sch.,s.10).
Français
