SELECT [TopicId]
      ,[Description]
      ,[CDM.MdName.ACCUMULATION_TYPE]
      ,[CDM.MdName.QUANTITY]
      ,[CDM.MdName.MEASURED_PROPERTY]
      ,[CDM.MdName.STATISTICAL]
      ,[CDM.MdName.TIME_AGGREGATION]
      ,[CDM.MdName.GROUP_NAME]
      ,[CDM.MdName.OCCURRENCE]
      ,[CDM.MdName.UTILITY]
      ,[CDM.MdName.APPLICATION]
  FROM [ApplicationModules].[CommonDataModel].[TopicMetadataView]
WHERE 
     [CDM.MdName.QUANTITY] IN ('CDM.MdValue.ENERGY', 'CDM.MdValue.POWER', 'CDM.MdValue.VOLUME', 'CDM.MdValue.MASS' )
     AND 
     [CDM.MdName.MEASURED_PROPERTY] IN ('CDM.MdValue.AMOUNT', 'CDM.MdValue.FLOW_RATE')
     AND 
     [CDM.MdName.TIME_AGGREGATION] NOT IN ('CDM.MdValue.N/A')