mysql view for latest node statuses, to match the one postgres side