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", t.name as "Theme Name", ct.name as "Category Name", cedar_action.Value as "tCO2e"
FROM 
	gocodegreen.CedarICTAlignments 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.ProductReportThemes t ON cedar_action.ThemeId = t.id
INNER JOIN gocodegreen.ProductReportCategories ct ON cedar_action.CategoryId = ct.id
order by cedar_action.id ASC