Front Row Brewing

Front Row Brewing

Loose Head

 

5%

Front Row Brewing

Arise Sir Kevin

 

4.3%

Front Row Brewing

Blindside

English IPA 

4.7%

Front Row Brewing

Blood Bin

 

4.5%

Front Row Brewing

Converted

English Porter 

5.4%

Front Row Brewing

Crafty Flanker

 

6%

Front Row Brewing

Day of the Jackler

 

4.5%

Front Row Brewing

Eddies Ninjas

 

4.4%

Front Row Brewing

Elderflower Pale

English Pale Ale 

4.2%

Front Row Brewing

England's Pride

 

4.6%

Front Row Brewing

Half-Time

Stout 

4.5%

Front Row Brewing

Hartley's Heroes

Amber/Red Ale 

3.9%

Front Row Brewing

Hooker

Milk Stout 

4.5%

Front Row Brewing

Land Of Hops And Glory

English Pale Ale 

3.8%

Front Row Brewing

Lions Roar

 

4%

Front Row Brewing

Lockdown IPA

American IPA 

6%

Front Row Brewing

Lomu

Porter 

5.4%

Front Row Brewing

Mauled

English/Scottish Strong Ale 

6.8%

Front Row Brewing

Name Me IPA

English IPA 

4.7%

Front Row Brewing

Naughty Hooker

Milk Stout 

4.5%

Front Row Brewing

Not Straight

Stout 

4.5%

Front Row Brewing

Obolensky

Imperial Porter 

7.3%

Front Row Brewing

Oh What A Punt

English Pale Ale 

3.8%

Front Row Brewing

Oh Wot A Punt

 

3.8%

Front Row Brewing

Old School

 

4.2%

Front Row Brewing

Pride of the Lions

 

4.6%

Front Row Brewing

Red Roses

Stout 

4.5%

Front Row Brewing

Respect Your Elders

English Pale Ale 

4.2%

Front Row Brewing

Rucked

Amber/Red Ale 

5.2%

Front Row Brewing

Santa Pause

Stout 

4.5%

Front Row Brewing

Seen Red

 

4%

Front Row Brewing

Seen Red Strawberry IPA

English IPA 

4.6%

Front Row Brewing

Set

English Pale Ale 

3.9%

Front Row Brewing

Split

Oatmeal Stout 

5%

Front Row Brewing

Tackle School

 

4.2%

Front Row Brewing

Take A Walk

 

4.2%

Front Row Brewing

The Beast

English IPA 

6.66%

Front Row Brewing

The Prince

Imperial Porter 

7.3%

Front Row Brewing

Tight Head

 

4.2%

Front Row Brewing

Trialist

English Pale Ale 

5%

Front Row Brewing

Try

 

4.2%

Front Row Brewing

Tryanuary

 

3.9%

Front Row Brewing

Tryanuary Stout

Stout 

4.5%

Front Row Brewing

Wiggo

English Pale Ale 

%

Front Row Brewing

Wot It's Caramel

Oatmeal Stout 

5%

Front Row Brewing

Wot It's Cherry

Oatmeal Stout 

5%

Front Row Brewing

Wot No Cheyz

Oatmeal Stout 

5%

Front Row Brewing

Wow Its Cherry

Oatmeal Stout 

5%

Front Row Brewing

99

 

4.4%

Front Row Brewing

Respect

 

4.1 - 4.2%

Front Row Brewing

Collapsed

 

5.6%

Front Row Brewing

Crouch

 

3.8%

Front Row Brewing

Number 8

 

3.7%

Front Row Brewing

Pause

 

4.5%

Front Row Brewing

Pride

 

4.6%

Front Row Brewing

Sin Bin

 

4.2%

Front Row Brewing

Touch

 

4%

Front Row Brewing

Engage

 

4.8%

SELECT user_venue_id, old_user_id, bagged, username, gender_id, CASE WHEN V.venue_uuid IS NULL THEN FD.festival_date_name ELSE venue_name END AS venue_name, CASE WHEN V.venue_uuid IS NULL THEN F.town ELSE V.town END AS town, CASE WHEN V.venue_uuid IS NULL THEN F.city ELSE V.city END AS city, CASE WHEN V.venue_uuid IS NULL THEN F.county ELSE V.county END AS county, CASE WHEN V.venue_uuid IS NULL THEN 'festival' ELSE venue_establishment_type END AS venue_establishment_type, CASE WHEN V.venue_uuid IS NULL THEN '/beer-festival/' || F.festival_url ELSE '/pub/' || VN.venue_url END AS venue_url, 0 AS distance, B.beer_name, '/real-ale-brewery/' || BW.url || '/' || B.url || COALESCE(BCT.url, '') AS beer_url, brewery_name, '/real-ale-brewery/' || BW.url AS brewery_url, COALESCE('/images/users/' || IU.image_url,'https://graph.facebook.com/' || faceBook || '/picture?width=361') AS user_image, COALESCE('/images/pubs/' || IV.image_url,'/images/pubs/' || IF.image_url) AS venue_image, '/images/beers/' || IB.image_url AS beer_image, '/images/breweries/' || IBW.image_url AS brewery_image FROM (SELECT * FROM user_venue ORDER BY bagged DESC) UV INNER JOIN user_account UA ON UA.user_account_uuid = UV.user_account_uuid LEFT JOIN venue_name VN ON VN.venue_name_id = UV.venue_name_id LEFT JOIN venue V ON V.venue_uuid = VN.venue_uuid LEFT JOIN venue_establishment_type VET ON VET.venue_establishment_type_id = V.venue_establishment_type_id LEFT JOIN festival_date FD ON FD.festival_date_id = UV.festival_date_id LEFT JOIN festival F ON F.festival_uuid = FD.festival_uuid LEFT JOIN beer_container BC ON BC.beer_container_id = UV.beer_container_id LEFT JOIN beer B ON B.beer_uuid = BC.beer_uuid LEFT JOIN beer_container_type BCT ON BCT.beer_container_type_id = BC.beer_container_type_id LEFT JOIN beer_brewery BB ON BB.beer_uuid = B.beer_uuid LEFT JOIN brewery BW ON BW.brewery_uuid = BB.brewery_uuid AND brewery_uuid = '{013A27E9-9BC0-4CF3-ADBE-9667008D901A}' LEFT JOIN image IU ON IU.user_account_uuid = UV.user_account_uuid AND IU.image_sequence = 1 LEFT JOIN image IV ON IV.venue_name_id = UV.venue_name_id AND IV.image_sequence = 1 LEFT JOIN image IF ON IF.festival_date_id = UV.festival_date_id AND IF.image_sequence = 1 LEFT JOIN image IB ON IB.beer_container_id = UV.beer_container_id AND IB.image_sequence = 1 LEFT JOIN image IBW ON IBW.brewery_uuid = BW.brewery_uuid AND IBW.image_sequence = 1 ORDER BY bagged DESC LIMIT 12