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…