deprecation query added for comparing/extracting old and revised values