SELECT 
	cedar_action.id as "ID", o.organizationsName as "Organization Name", p.productName as "Product Name", a.applicationTypeName as "Application Name", l.name as "Lifecycle Name", m.name as "Measure Name",
    cedar_action.Description,
    cedar_action.Value as "Value"
FROM 
	gocodegreen.CedarMiscellaneousData cedar_action
INNER JOIN gocodegreen.Organizations o ON cedar_action.OrganizationId = o.id
INNER JOIN gocodegreen.Products p ON cedar_action.ProductId = p.id
INNER JOIN gocodegreen.ApplicationTypes a ON cedar_action.ApplicationId = a.id
INNER JOIN gocodegreen.ProductLifecycleStages l ON cedar_action.LifecycleId = l.id
INNER JOIN gocodegreen.ProductReportMeasures m ON cedar_action.MeasureId = m.id
order by cedar_action.id ASC