It appears that your company does soft deletes by setting the field "Deleted" to 1 when it should no longer be returned in queries.

Your screen shot doesn't include this column. Add it to your quest so we can see what value it holds for all records.

Mark