finally got the friend functions working! left outer join for the win