How To Convert LEFT JOIN SQL Statement into CakePHP coding

What does your index function look like? If the table associations are all set up correctly, it should be a simple matter of containing the Members association, and then your template will have something like $appearance->member->name instead of $appearance->member_id.