Sandfield CMS Stored procedures

FetchArticleFromID_StoredProcedure.sql

/**
Fetch an article based on its ID:

Fields required:
	- Type
	- Title
	- Description
	- Thumbnail
	- Published time
	- Modified time
	- Section/category

TODO: On the where clause, specify article ID
**/
SELECT
	[ArticleType].[Name] as ArticleType
	,[Article].[Title]
	,[Article].[Description]
	,[Article].[ThumbnailImage]
    ,[Article].[Created]
    ,[Article].[LastModified]
	,[ArticleCategory].Name as CategoryName
FROM [CMS_SAL_DEV].[CMS].[Article] Article
LEFT JOIN [CMS_SAL_DEV].[CMS].[ArticleType] ArticleType
ON [Article].[ArticleTypeID] = [ArticleType].[ArticleTypeID]
LEFT JOIN [CMS_SAL_DEV].[CMS].[ArticleCategory] ArticleCategory
ON [ArticleType].[ArticleTypeID] = [ArticleCategory].[ArticleCategoryID]
WHERE [Article].[ArticleID] = 1
ORDER BY [Article].[Created] DESC