second snapshot query