Aaron, this is because in the above query you have HIDE DUPLICATES on and 119384 is marked as a duplicate.
Aaron, this is because in the above query you have HIDE DUPLICATES on and 119384 is marked as a duplicate.