Modified query to display the most recent legal status begin date