Pastie Support Pastie or read my Pastie << self blog

Language: ActionScript C/C++ CSS Diff HTML (ERB / Rails) HTML / XML Java Javascript Objective C/C++ Pascal Perl PHP Plain text Python Ruby Ruby (on Rails) Shell Script (Bash) SQL YAML  

## mark a section (Learn more)

This paste will be private.

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])