Skip to content

Instantly share code, notes, and snippets.

@oleander

oleander/gist:907953

Created April 7, 2011 15:07
Show Gist options
  • Save oleander/907953 to your computer and use it in GitHub Desktop.
Save oleander/907953 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT channels.*
FROM channels
INNER JOIN gigs ON gigs.channel_id = channels.id
INNER JOIN songs ON songs.id = gigs.song_id
INNER JOIN songs_urls ON songs_urls.song_id = songs.id
INNER JOIN urls ON urls.id = songs_urls.url_id
INNER JOIN services ON services.id = urls.service_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment