Skip to content

Instantly share code, notes, and snippets.

@hone
Created October 19, 2009 00:07
Show Gist options
  • Select an option

  • Save hone/212962 to your computer and use it in GitHub Desktop.

Select an option

Save hone/212962 to your computer and use it in GitHub Desktop.
SELECT *
FROM suites
INNER JOIN events
ON suites.venue_id = events.eventable_id
INNER JOIN suite_ownerships
ON suites.id = suite_ownerships.suite_id
WHERE events.eventable_type = "Venue"
AND suite_ownerships.user_id = #{suite_owner.id}
AND event.id = #{event.id}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment