select p.id as id, p.name as name, t.content as content from person as p left outer join task as t on p.id = t.person_id order by p.id