Find Duplicate RB Encounters

gistfile1.sql

Select e.EncounterNo, e.EncntrStartDate as old_encounter, e2.EncntrStartDate as new_encounter
From DocTypes as dt
  Inner Join documents as d on dt.DocType = d.DocType
  Inner Join DocsOwners as do on d.DocId = do.DocId
  Inner Join Encounters as e on do.OwnerId = e.EncntrOwnerId
  Inner Join Encounters as e2 on e.EncounterNo = e2.EncounterNo
Where DocTypeName in ( 'SNGRPT', 'SNGRPTR' ) 
  And e.EncntrOwnerId <> e2.EncntrOwnerId
  And e2.EncntrStartDate > '1/1/2005'
  And (Select Count(*) From Documents as d2 
         inner join DocsOwners as do2 on d2.DocId = do2.DocId 
         inner join DocTypes as dt2 on d2.DocType = dt2.DocType 
       Where do2.OwnerId = e.EncntrOwnerId And DocTypeName = 'AFACE') = 0
Order By e.EncounterNo