Page History

select distinct 'all' value, conceptId itemId, conceptName itemName
from map_records a, map_entries me,
(select a.terminologyId self, b.terminologyId sib
from tree_positions a, tree_positions b
where a.terminology = ':DESTINATION_TERMINOLOGY:'
   and a.terminologyVersion = ':DESTINATION_TERMINOLOGY_VERSION:'
   and b.terminology = a.terminology
   and b.terminologyVersion = a.terminologyVersion 
   and a.ancestorPath = b.ancestorPath
   and a.terminologyId != b.terminologyId) b
where a.mapProjectId = :MAP_PROJECT_ID:
and a.id = me.mapRecord_id
and me.targetId=b.self and NOT EXISTS
(select *
from tree_positions c, tree_positions d
where c.terminology = ':DESTINATION_TERMINOLOGY:'
   and c.terminologyVersion = ':PREVIOUS_DESTINATION_TERMINOLOGY_VERSION:'
   and d.terminology = c.terminology
   and d.terminologyVersion = c.terminologyVersion 
   and c.ancestorPath = d.ancestorPath
   and c.terminologyId != d.terminologyId
   and b.self = c.terminologyId and b.sib = d.terminologyId);