update data prune query to use 'where not exists' instead of 'not in'

update data prune query to use 'where not exists' instead of 'not in' #778