Updated mysql view.