select `id`,`name`,`age`,`address_id`,(select `street` from `address` where `person`.`address_id` = `address`.`id` ) `address` from `person` order by `person`.`age` desc, `person`.`name` []