Swannay Brewery (Highland Brewing Co)

Swannay Brewery (Highland Brewing Co)

A-Babble

India Pale Ale 

4.1%

Swannay Brewery (Highland Brewing Co)

A9

Golden Ale 

5%

Swannay Brewery (Highland Brewing Co)

Abeam

Scottish Ale 

4.5%

Swannay Brewery (Highland Brewing Co)

Abune

English Pale Ale 

4.7%

Swannay Brewery (Highland Brewing Co)

Adrift

American Pale Ale 

3.2%

Swannay Brewery (Highland Brewing Co)

Banyan

American Pale Ale 

3.9%

Swannay Brewery (Highland Brewing Co)

Bitter Milk

Milk Stout 

4.1%

Swannay Brewery (Highland Brewing Co)

Bygg

Rye Ale 

5%

Swannay Brewery (Highland Brewing Co)

Cheeky Wee Stout

Stout 

4.5%

Swannay Brewery (Highland Brewing Co)

Gyle 2249

India Pale Ale 

3.7%

Swannay Brewery (Highland Brewing Co)

Gyle 2256

India Pale Ale 

4.5%

Swannay Brewery (Highland Brewing Co)

Imperial Stout - Seafaring Stout

Imperial Stout 

8%

Swannay Brewery (Highland Brewing Co)

Leonardo

American IPA 

5%

Swannay Brewery (Highland Brewing Co)

Light Ale

India Pale Ale 

%

Swannay Brewery (Highland Brewing Co)

Light Munro Citra

English Mild Ale 

3%

Swannay Brewery (Highland Brewing Co)

Magnus Blonde

Blonde Ale 

4.3%

Swannay Brewery (Highland Brewing Co)

Milne Cup 100

English Pale Ale 

4.3%

Swannay Brewery (Highland Brewing Co)

Muckle IPA

American IPA 

6.6%

Swannay Brewery (Highland Brewing Co)

Old Norway

Barleywine 

8 - 9%

Swannay Brewery (Highland Brewing Co)

Orkney Porter (Arran Bere Whisky Cask Edition)

Imperial Porter 

10.5%

Swannay Brewery (Highland Brewing Co)

Orkney Porter 2014 Vintage

Imperial Porter 

9%

Swannay Brewery (Highland Brewing Co)

Orkney Porter 2016 Vintage

Imperial Porter 

9%

Swannay Brewery (Highland Brewing Co)

Orkney Porter Vintage 2015

Imperial Porter 

9%

Swannay Brewery (Highland Brewing Co)

Orkney Session

Golden Ale 

3.8%

Swannay Brewery (Highland Brewing Co)

Pleep

English Pale Ale 

4.2%

Swannay Brewery (Highland Brewing Co)

Scapa 1919

Lager 

4.7%

Swannay Brewery (Highland Brewing Co)

Shortest Day

Scottish Ale 

4.9%

Swannay Brewery (Highland Brewing Co)

SWO Stout

Stout 

4.2%

Swannay Brewery (Highland Brewing Co)

Voar

American Pale Ale 

3.5%

Swannay Brewery (Highland Brewing Co)

Voe

Oatmeal Stout 

5%

Swannay Brewery (Highland Brewing Co)

Whisky Aged Imperial Stout

Imperial Stout 

12%

Swannay Brewery (Highland Brewing Co)

Zentner

English IPA 

5%

Swannay Brewery (Highland Brewing Co)

Running Beer

 

3.8%

Swannay Brewery (Highland Brewing Co)

Running Beer

 

3.8%

Swannay Brewery (Highland Brewing Co)

Christmas Light

 

3.8%

Swannay Brewery (Highland Brewing Co)

Jack Flag

 

3.8%

Swannay Brewery (Highland Brewing Co)

Orkney Best

 

3.6%

Swannay Brewery (Highland Brewing Co)

Orkney Best

 

3.6%

Swannay Brewery (Highland Brewing Co)

Orkney Blast

 

6%

Swannay Brewery (Highland Brewing Co)

Orkney Blast

 

6%

Swannay Brewery (Highland Brewing Co)

Orkney Gold

 

4.5%

Swannay Brewery (Highland Brewing Co)

Scapa Bere

 

4.2%

Swannay Brewery (Highland Brewing Co)

Staff Pint

 

4.2%

Swannay Brewery (Highland Brewing Co)

Summer Breeze

 

3.2%

Swannay Brewery (Highland Brewing Co)

Yardsook

 

5%

Swannay Brewery (Highland Brewing Co)

Standard

 

3%

Swannay Brewery (Highland Brewing Co)

Amarillo

 

4.5%

Swannay Brewery (Highland Brewing Co)

Imperial Stout 2010

 

8%

Swannay Brewery (Highland Brewing Co)

Oat Stout

 

5%

Swannay Brewery (Highland Brewing Co)

Orkney IPA

 

4.8%

Swannay Brewery (Highland Brewing Co)

Orkney IPA

 

4.8%

Swannay Brewery (Highland Brewing Co)

Orkney Porter

 

9%

Swannay Brewery (Highland Brewing Co)

Pale Ale

 

4.7%

Swannay Brewery (Highland Brewing Co)

Rockall Ryse

 

4.2%

Swannay Brewery (Highland Brewing Co)

Seafire

 

4%

Swannay Brewery (Highland Brewing Co)

Sneaky Wee Orkney Stout

 

4.2%

Swannay Brewery (Highland Brewing Co)

Sneaky Wee Orkney Stout

 

4.2%

Swannay Brewery (Highland Brewing Co)

St Magnus Ale

 

4.5 - 5.2%

Swannay Brewery (Highland Brewing Co)

Duke IPA

 

5.2%

Swannay Brewery (Highland Brewing Co)

Duke IPA

 

5.2%

Swannay Brewery (Highland Brewing Co)

Island Hopping

 

3.9%

Swannay Brewery (Highland Brewing Co)

Scapa Special

 

4.2%

Swannay Brewery (Highland Brewing Co)

Dark Munro

 

4%

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 = '{56CAF751-217C-4A3F-AE58-E56F6666E3F3}' 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