Pastie Support Pastie or read my Pastie << self blog

       sql =  "SELECT DISTINCT * " +
        "FROM `memories` AS Memory " +
        "JOIN `anchors_memories` AS AnchorLink ON ( Memory.user_id " +
        "IN ( " +
        " " +
        "SELECT friend_id " +
        "FROM friendships " + 
        "WHERE user_id = ? " +
        ") " +
        "AND AnchorLink.memory_id = Memory.id ) " +
        "JOIN `anchors_groups` AS GroupLink ON ( GroupLink.anchor_id = AnchorLink.anchor_id ) " +
        "JOIN `groups_users` AS UserLink ON ( UserLink.group_id = GroupLink.group_id " +
        "AND UserLink.friend_id = ? ) ";
          
    @viewableMemories = Memory.find_by_sql([sql, self.id, self.id])