Skip to content

Instantly share code, notes, and snippets.

@mrichman

mrichman/gist:164162

Created August 7, 2009 20:40
Show Gist options
  • Save mrichman/164162 to your computer and use it in GitHub Desktop.
Save mrichman/164162 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT c.competition_id, c.Name, c.country_id, c.type, c.seq,
cl.competition_local_id, cl.localized_name, @SiteId AS SiteId
FROM competition c
LEFT JOIN competition_local cl
ON c.competition_id = cl.competition_id
AND cl.site_id = '69C38CB1-AC3C-4F9A-BCA0-27AE315E8A76'
ORDER BY seq
LIMIT 0,10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment