Comment 1 for bug 794896

To the person, you will need to join the most recent person_position and the previous person_position.

For the most recent you can do max_parent of the person_position+start_date with offset 0
For the previous you can do max_parent of the person_position+start_date with offset 1

Note, this is not how we do the current staff report. In the current staff report we do the person_position with end_date NULL. But here, we are interested in the previous two positions whether or not they are still working. So here, we do NOT want to limit so that the end_date is null.