Duplicate Address Level data in the org(which has separate hosting) database causing confusion

[ashusvnath]

SELECT al.id,al.title, i.id as individual_id, i.is_voided as individual_is_voided ,i.first_name, i.last_name 
FROM address_level al JOIN individual i on al.id = i.address_id where title IN 
      ( SELECT title FROM address_level WHERe is_voided = false GROUP BY title HAVING count(*) > 1) 
ORDER BY title ASC;

This show a list of voided and non-voided individuals associated with different address hierarchies.

   id   |                      title                      | individual_id | individual_is_voided 
     80 | ADDAPUSEELA GOWRI SANKARA RAO School            |            38 | t
   4079 | ADDAPUSEELA GOWRI SANKARA RAO School            |         23312 | f
   4079 | ADDAPUSEELA GOWRI SANKARA RAO School            |         23314 | f
   4079 | ADDAPUSEELA GOWRI SANKARA RAO School            |         23301 | f
   4079 | ADDAPUSEELA GOWRI SANKARA RAO School            |         23147 | f
   4079 | ADDAPUSEELA GOWRI SANKARA RAO School            |         23328 | f
   4147 | A HARIBABU School                               |         23350 | f
    148 | A HARIBABU School                               |           106 | t
    148 | A HARIBABU School                               |           203 | t
   4147 | A HARIBABU School                               |         23346 | f
   4147 | A HARIBABU School                               |         23345 | f