SELECT
	TBL_CONTENT.CONTENT_ID AS ContentID,
	TBL_CONTENT.CONTENT_NAME AS Name,
	TBL_CONTENT.CONTENT_FEATURED_IMAGE AS FeaturedImage,
	TBL_CONTENT.CONTENT_DESC AS Excerpt,
	TBL_CONTENT.CONTENT_LONG_DESC AS Description,
	TBL_CONTENT.CONTENT_URL_PATH AS URL,
	TBL_CONTENT.CONTENT_META_TITLE AS MetaTitle,
	TBL_CONTENT.CONTENT_META_DESC AS MetaDesc,
	TBL_CONTENT.CONTENT_META_KEYWORD AS MetaKeyword,
	TBL_CONTENT.CONTENT_INSERTED_DATETIME AS InsertedDatetime,
	TBL_CONTENT.CONTENT_UPDATED_DATETIME AS UpdatedDatetime,
	TBL_CONTENT.CONTENT_CATEGORY_NAME AS CategoryName
FROM dbo.TBL_CONTENT
	LEFT JOIN TBL_CONTENT_IN_CONTENT_CATEGORY ON TBL_CONTENT.CONTENT_ID = TBL_CONTENT_IN_CONTENT_CATEGORY.CONTENT_ID
	LEFT JOIN TBL_CONTENT_CATEGORY ON TBL_CONTENT_IN_CONTENT_CATEGORY.CONTENT_CATEGORY_ID = TBL_CONTENT_CATEGORY.CONTENT_CATEGORY_ID
WHERE CONTENT_TYPE = 'BLOG'
AND	CONTENT_ACTIVE = 1