work on sep snapshot queries