FetchPageFromID_StoredProcedure.sql

/**
Fetch a page based on its ID:

Fields required:
	- Title
	- Description
	- Thumbnail
	- Section/category

TODO: On the where clause, specify page ID
**/
SELECT
	[Page].[Title]
	,[Page].[MetaDescription] as Description
	,[Page].[Image1]
	,[Page].[Image2]
	,[Page].[Image3]
	,[Page].[Image4]
FROM [CMS_SAL_DEV].[CMS].[Page] [Page]
LEFT JOIN [CMS_SAL_DEV].[CMS].[PageType] PageType
ON [Page].[PageTypeID] = [PageType].[PageTypeID]
WHERE [Page].[PageID] = 1
ORDER BY [Page].[Created] DESC