Ektron Content Folder Names

SELECT c.[content_id]
	,c.[content_title]
	,c.[content_html]
	,c.[content_status]
	,CASE
		WHEN c.[content_status] = 'A'
			THEN 'Approved'
		WHEN c.[content_status] = 'O'
			THEN 'Checked Out'
		WHEN c.[content_status] = 'I'
			THEN 'Checked In'
		WHEN c.[content_status] = 'S'
			THEN 'Submitted for Approval'
		WHEN c.[content_status] = 'M'
			THEN 'Marked for Deletion'
		WHEN c.[content_status] = 'P'
			THEN 'Pending Go Live Date'
		WHEN c.[content_status] = 'T'
			THEN 'Awaiting Completion of Associated Tasks'
		WHEN c.[content_status] = 'D'
			THEN 'Pending Deletion'
		END AS ContentStatus
	,c.[date_created]
	,c.[content_type]
	,c.[approval_method]
	,c.[searchable]
	,c.[alias_id]
	,c.folder_id
	,cft.[folder_name]
	,cft.FolderPath
	,cft.FolderIdPath
FROM [content] c
INNER JOIN [content_folder_tbl] cft ON c.folder_id = cft.folder_id
ORDER BY content_status

Related Queries: Ektron Alias With Folder Name