SELECT si.DomainItemPath,
       si.SystemItemId,
       si.ItemName,
       si.ItemTypeId, -- 4 = System Item, 5 = Enumeration
       COUNT(*) as MappingsUsed
FROM [dbo].[SystemItemMapAssociation] sima
JOIN [dbo].[SystemItemMap] sim
  on sima.SystemItemMapId = sim.SystemItemMapId
JOIN [dbo].[SystemItem] si
  on sima.SystemItemId = si.SystemItemId
JOIN [dbo].[MappingProject] mp
  on mp.MappingProjectId = sim.MappingProjectId
WHERE si.MappedSystemId in ('8B49C930-3BB1-E811-80D9-005056B36109','13053D0F-46B8-E911-80DE-005056B36109','098AF02E-9FB7-E911-80DE-005056B36109','5E15FC76-A6D0-E911-80DF-005056B36109','B485214C-01D3-E911-80DF-005056B36109')  -- Add Data Standard Id
 -- AND sim.MappingProjectId in ('') -- Add in Mapping Projects
GROUP BY si.SystemItemId,
	     si.ItemName,
	     si.DomainItemPath,
	     si.ItemTypeId