SELECT si.DomainItemPath as SourcePath,
       si.SystemItemId as SourceSystemItemId,
       si.ItemName as SourceItemName,
       si.ItemTypeId as SourceItemTypeId, -- 4 = System Item, 5 = Enumeration
	   tsi.DomainItemPath as TargetPath,
       tsi.SystemItemId as TargetSystemItemId,
       tsi.ItemName as TargetItemName,
       tsi.ItemTypeId as TargetItemTypeId, -- 4 = System Item, 5 = Enumeration
	   mp.MappingProjectId,
	   mp.ProjectName,
	   sim.BusinessLogic,
	   mmt.MappingMethodTypeName as MappingMethod,
	   mst.MappingStatusTypeName as MappingStatus
FROM [dbo].[SystemItemMapAssociation] sima
JOIN [dbo].[SystemItemMap] sim
  on sima.SystemItemMapId = sim.SystemItemMapId
JOIN [dbo].[SystemItem] tsi
  on sima.SystemItemId = tsi.SystemItemId
JOIN [dbo].[MappingProject] mp
  on mp.MappingProjectId = sim.MappingProjectId
JOIN [dbo].[SystemItem] si
  on sim.SourceSystemItemId = si.SystemItemId
LEFT JOIN [dbo].[MappingStatusType] mst
  on sim.MappingStatusTypeId = mst.MappingStatusTypeId
JOIN [dbo].[MappingMethodType] mmt
  on sim.MappingMethodTypeId = mmt.MappingMethodTypeId
WHERE tsi.MappedSystemId = '' -- Add Data Standard Id
  AND sim.MappingProjectId in ('') -- Add in Mapping Projects
