Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT g.[Name],i.[Name] AS [Item Name],i.MinLevel,it.[Name] AS [Item Type]
- FROM Games AS g
- JOIN GameTypes AS gt ON g.GameTypeId = gt.Id
- JOIN GameTypeForbiddenItems AS gtfi ON gtfi.GameTypeId = gt.Id
- JOIN Items AS i ON i.Id = gtfi.ItemId
- JOIN ItemTypes AS it ON it.Id = i.ItemTypeId
- WHERE g.[Name] = 'Safflower'
- ORDER BY g.[Name]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement