Your Rating (0)
Average Rating (3.5)
Stats
| Bagged | 11 |
| Unique | 3 |
| Past Year | 0 |
| Past Month | 0 |
| Past Week | 0 |
| By You | 0 |
Problem?
Report error / duplicate
- Availability
- Description
- Activity
- Similar Beers
- Images
- Tasting Notes
- Ingredients
- Reviews
- Top Drinkers
approx 0 mi
07/12/2022 at 17:48
John was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at The Red Lion in Norwich, Norfolk
approx 0 mi
14/06/2021 at 13:38
John was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at The Sir Garnet in Norwich, Norfolk
approx 0 mi
14/06/2021 at 13:37
Babsydob was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at The Sir Garnet in Norwich, Norfolk
approx 0 mi
12/04/2021 at 15:06
Babsydob was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at Coach & Horses in Norwich, Norfolk
approx 0 mi
14/07/2020 at 14:49
John was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at Coach & Horses in Norwich, Norfolk
approx 0 mi
14/07/2020 at 14:49
Babsydob was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at Coach & Horses in Norwich, Norfolk
approx 0 mi
10/08/2019 at 12:48
DC was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at The Lord Rosebery in Norwich, Norfolk
approx 0 mi
20/11/2018 at 14:00
John was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at The Alexandra Tavern in Norwich, Norfolk
approx 0 mi
08/12/2017 at 20:37
DC was drinking an Evolution by Mr Winter's (Winter's Brewing Co) at The Vine Thai Cuisine in Norwich, Norfolk
Moon Gazer (The Norfolk Brewhouse)
American Pale Ale
American Pale Ale
4.2%
Cornish Crown
Easy PZ Pale Ale
American Pale Ale
4.8%
St Ives Brewery
Hella Pale Ale
American Pale Ale
4.2%
Three Blind Mice Brewery
Lonely Snake
American Pale Ale
3.5%
Nethergate Brewery
Mosaic Christmas
American Pale Ale
3.5%
Bullards
No.1 East Coast Pale Ale
American Pale Ale
4.2%
Firebrand Brewing Company
Patchwork Rocket
American Pale Ale
4%
Moon Gazer (The Norfolk Brewhouse)
Pond Hopper
American Pale Ale
4.5%
Wolf Brewery
Sly Wolf
American Pale Ale
4.4%
Fine Tuned Brewery
Sunshine Reggae
American Pale Ale
4.2%
Electric Bear Brewing Co
Two Halves One Glass
American Pale Ale
3.8%
Redwell Brewing
West Coast Pale Ale
American Pale Ale
5.6%
Bagging Beer - Evolution
You must be logged in to bag a venue
Login Now
Cancel
Bagging Beer - Evolution
SELECT tblBeer.iBeerID, sBeer, iContainerID, IFNULL(sBeerImage,sBreweryImage) AS sImage, IFNULL(sColour,'#F0ED68') AS sColour, CASE iContainerID WHEN 1 THEN 'keg' WHEN 2 THEN 'bottle' WHEN 3 THEN 'can' ELSE 'pump' END AS sContainer, fABV, sBrewery, sBreweryColab FROM ( SELECT tblpubbeer.iBeerID, iBreweryID, sBeer, fABV, iContainerID, sColour FROM (SELECT * FROM tblPubBeer WHERE iPubID = 36092 AND tblPubBeer.iActive = 1 AND tblPubBeer.iDelete = 0) AS tblPubBeer INNER JOIN (SELECT iBeerID, iBreweryID, sBeer, fABV, iContainerID, iBeerTypeID FROM tblBeer WHERE iDelete = 0 AND iActive = 1) AS tblBeer ON tblBeer.iBeerID = tblPubBeer.iBeerID LEFT JOIN tblBeerType ON tblBeer.iBeerTypeID = tblBeerType.iBeerTypeID) AS tblBeer INNER JOIN (SELECT iBreweryID, sBrewery FROM tblBrewery WHERE iDelete = 0 AND iActive = 1) AS tblBrewery ON tblBrewery.iBreweryID = tblBeer.iBreweryID LEFT JOIN (SELECT iBeerID, GROUP_CONCAT(sBrewery SEPARATOR '/') AS sBreweryColab FROM tblbeercolab INNER JOIN tblbrewery ON tblbeercolab.iBreweryID = tblbrewery.iBreweryID GROUP BY iBeerID) AS tblColab ON tblColab.iBeerID = tblBeer.iBeerID LEFT JOIN (SELECT iBeerImageID, iBeerID, concat('/images/beers/',iBeerID,'/',sImage) AS sBeerImage FROM tblBeerImage WHERE iMain = 1) AS tblBeerImage ON tblBeerImage.iBeerID = tblBeer.iBeerID LEFT JOIN (SELECT iBreweryID, concat('/images/breweries/',iBreweryID,'/',sImage) AS sBreweryImage FROM tblBreweryImage WHERE iMain = 1) AS tblBreweryImage ON tblBreweryImage.iBreweryID = tblBeer.iBreweryID LEFT JOIN (SELECT iBeerID, MAX(dBagged) AS dBagged FROM tblUserPub WHERE iPubID = 36092 GROUP BY iBeerID) AS tblUserPub ON tblUserPub.iBeerID = tblBeer.iBeerID ORDER BY dBagged DESC