Your Rating (0)
Average Rating (4)
Stats
| Bagged | 15 |
| Unique | 4 |
| 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
Keg
Bottle
Can
approx 0 mi
London, Greater London
The Harp
approx 0 mi
Cheltenham, Gloucestershire
Bank House
approx 0 mi
Brentford, Greater London
Express Tavern
Load More…
approx 0 mi
18/06/2022 at 17:13
Babsydob was drinking a Jaipur by Thornbridge Brewery at The Huntsman in Bath, Bath and North East Somerset
approx 0 mi
18/06/2022 at 17:10
DC was drinking a Jaipur by Thornbridge Brewery at The Huntsman in Bath, Bath and North East Somerset
approx 0 mi
26/08/2017 at 14:24
Babsydob was drinking a Jaipur by Thornbridge Brewery at Ales by Rails - Beer festival & Steam Weekend 2017 in Dereham, Norfolk
approx 0 mi
26/08/2017 at 13:48
Broadsman was drinking a Jaipur by Thornbridge Brewery at Ales by Rails - Beer festival & Steam Weekend 2017 in Dereham, Norfolk
Raw Brewing Co
Baby Ghost IPA
3.9%
Sunny Republic Brewing Company
Hop Dog
5.5%
Bristol Beer Factory
Independence
4.6%
The Indian Brewery Company
IPA
4.9%
The Little Beer Corporation
Little Kahuna
4.2%
Ilkley Brewery Co
Lotus IPA
5.6%
Greene King Brewery
Mighty Moose IPA
5.6%
Northern Monk Brew Co
New World IPA
6.2%
Sadler's Ales Brewery
Peaky Blinder
4.6%
Peerless Brewing Co Ltd
Shabash IPA
5.4%
London Fields Brewery
Shoreditch Triangle
6%
Rooster's Brewing Co
Wild Mule
3.9%
Bagging Beer - Jaipur
You must be logged in to bag a venue
Login Now
Cancel
Bagging Beer - Jaipur
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 = 4458 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 = 4458 GROUP BY iBeerID) AS tblUserPub ON tblUserPub.iBeerID = tblBeer.iBeerID ORDER BY dBagged DESC