ScotLUG at the Troon Beer Festival
I went to the Troon Real Ale festival on 5th October with some other ScotLUG members. Although it's much smaller than the Paisley Beer Festival, it still had a good variety of ales. Here's what I tried while I was there:
- Broughton "Clipper IPA"
- Glenfinnan "Standard Ale"
- Traditional Scottish Ales "Ginger Explosion"
- Tryst "Brockville Dark"
- Windie Goat "Peden's Cove"
- Dent "T'Owd Tup"
- Wyre Piddle "Piddle in the Cold"
- Newton Court Perry
The Newton Court Perry tasted exactly like one that Kevin, Scott and I had at the 2005 Paisley Beer Festival, which was the best perry I've ever tasted.
While I was in Troon, I had a discussion with Andrew about T-shirts for the next ScotLUG beer festival trip. He suggested T-shirts with a list of previous beer festivals the group has attended, and something like a SQL statement to go along with this "table".
After a bit of playing around, I managed to create a couple of tables in MySQL and a query that mentions both ScotLUG and Beer Festival which produces the correct output. The query looks a bit weird since the inner join is completely unnecessary, but it's the only way I could think of to get both phrases in.
FROM ScotLUG
INNER JOIN BeerFestival;
+------------+----------+
| Date | Location |
+------------+----------+
| 2004-04-02 | Paisley |
| 2005-04-16 | Paisley |
| 2006-04-21 | Paisley |
| 2007-04-27 | Paisley |
| 2007-10-05 | Troon |
+------------+----------+
Now I'll have to look around on the web to find what the dates of the previous beer festival trips were.
