2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003
 

select f.ID, f.fkDocumentGroup, c.blnPrivate, 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 LEFT JOIN tblI18nText eng on eng.fkForeign=f.fkCategoryID and eng.fkLanguage=1 WHERE c.blnActive = 1 AND f.blnActive=1 AND ((t.strName || '/.') LIKE N'Budgets/Budget Highlights/%' OR (eng.strName || '/.') LIKE N'Budgets/Budget Highlights/%') and YEAR(f.dtUploaded) = 2013 order by t.strName,strTitle,idLang

select f.ID, f.fkDocumentGroup, c.blnPrivate, 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 LEFT JOIN tblI18nText eng on eng.fkForeign=f.fkCategoryID and eng.fkLanguage=1 WHERE c.blnActive = 1 AND f.blnActive=1 AND ((t.strName || '/.') LIKE N'Budgets/Budget Address/%' OR (eng.strName || '/.') LIKE N'Budgets/Budget Address/%') and YEAR(f.dtUploaded) = 2013 order by t.strName,strTitle,idLang

select f.ID, f.fkDocumentGroup, c.blnPrivate, 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 LEFT JOIN tblI18nText eng on eng.fkForeign=f.fkCategoryID and eng.fkLanguage=1 WHERE c.blnActive = 1 AND f.blnActive=1 AND ((t.strName || '/.') LIKE N'Budgets/Budget Supplementary Information/%' OR (eng.strName || '/.') LIKE N'Budgets/Budget Supplementary Information/%') and YEAR(f.dtUploaded) = 2013 order by t.strName,strTitle,idLang

select f.ID, f.fkDocumentGroup, c.blnPrivate, 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 LEFT JOIN tblI18nText eng on eng.fkForeign=f.fkCategoryID and eng.fkLanguage=1 WHERE c.blnActive = 1 AND f.blnActive=1 AND ((t.strName || '/.') LIKE N'Budgets/Main Estimates/%' OR (eng.strName || '/.') LIKE N'Budgets/Main Estimates/%') and YEAR(f.dtUploaded) = 2013 order by t.strName,strTitle,idLang

select f.ID, f.fkDocumentGroup, c.blnPrivate, 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 LEFT JOIN tblI18nText eng on eng.fkForeign=f.fkCategoryID and eng.fkLanguage=1 WHERE c.blnActive = 1 AND f.blnActive=1 AND ((t.strName || '/.') LIKE N'Budgets/Capital Estimates/%' OR (eng.strName || '/.') LIKE N'Budgets/Capital Estimates/%') and YEAR(f.dtUploaded) = 2013 order by t.strName,strTitle,idLang

select f.ID, f.fkDocumentGroup, c.blnPrivate, 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 LEFT JOIN tblI18nText eng on eng.fkForeign=f.fkCategoryID and eng.fkLanguage=1 WHERE c.blnActive = 1 AND f.blnActive=1 AND ((t.strName || '/.') LIKE N'Budgets/Supplementary Appropriations/%' OR (eng.strName || '/.') LIKE N'Budgets/Supplementary Appropriations/%') and YEAR(f.dtUploaded) = 2013 order by t.strName,strTitle,idLang

select f.ID, f.fkDocumentGroup, c.blnPrivate, 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 LEFT JOIN tblI18nText eng on eng.fkForeign=f.fkCategoryID and eng.fkLanguage=1 WHERE c.blnActive = 1 AND f.blnActive=1 AND ((t.strName || '/.') LIKE N'Business Plans/%' OR (eng.strName || '/.') LIKE N'Business Plans/%') and YEAR(f.dtUploaded) = 2013 order by t.strName,strTitle,idLang