changed whereclause, removed variable declaration, added default values to index
changed whereclause, removed variable declarations, added default values to index