Guest User

Untitled

a guest
Jul 12th, 2015
334
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1.  
  2. SELECT i.Name as 'Item Name'
  3. FROM UserGameItems ugi
  4. JOIN UsersGames ug
  5. ON ugi.UserGameId = ug.Id
  6. JOIN Items i
  7. ON ugi.ItemId = i.Id
  8. WHERE GameId =
  9. (
  10. SELECT id
  11. FROM Games
  12. WHERE Name = 'Safflower'
  13. )
  14. UNION
  15. SELECT i.Name
  16. FROM Items i
  17. WHERE i.MinLevel IN(11,12)
  18. ORDER BY i.Name
Advertisement
Add Comment
Please, Sign In to add comment