updated query in getChangeHistoryForAlert() to match recent schema changes.
eliminated unnecessary loop over result set.
removed column name alias from query.