Using nolock; simplifying COUNT query; consider cell assignments and deleted status as of snapshot time.