Storylines: Navigating throughlines in Geoff Ebbs projects

select p.id, p.wp_id, p.name as pName, p.end, (select max(control) from sl_projectyear y where p.id=y.pid) as control from sl_project p order by end desc

RESULT: !!!