gistfile1.sql

select joy_journeys.id from joy_journeys, memberships, profiles, circles
    INNER JOIN memberships on memberships.circle_id = circles.id 
    INNER JOIN profiles on memberships.profile_id = profiles.id
    INNER JOIN joy_journeys on joy_journeys.profile_id = profiles.id
    WHERE circles.id = #{self.id}