Young's Ram Brewery Tours

A living and working museum of English brewing on a site where real ale has been produced for over 400 years. Visitors can see Victorian brewing coppers alongside modern equipment, 19thC beam engines and fermenting vessels. There are also stables with Shire horses, heavy horses and a farrier's shed. Bottling and casking of beers can also be seen.

  • Currently: Medium-level cloud, 26° C
  • Sunday: Sunny intervals, 23° C
  • Monday: Medium-level cloud, 27° C

Failed to find events: SELECT DISTINCT e.st_date, e.tag, FROM_UNIXTIME( e.st_date, GET_FORMAT(DATETIME,'ISO')) AS dtstart, FROM_UNIXTIME( e.end_date, GET_FORMAT(DATETIME,'ISO')) AS dtend, DATE_FORMAT(FROM_UNIXTIME(e.st_date), '%D %M %Y') AS StartDate, DATE_FORMAT(FROM_UNIXTIME(e.st_date), '%k:%i') AS StartTime, DATE_FORMAT(FROM_UNIXTIME(e.end_date), '%D %M %Y') AS EndDate, DATE_FORMAT(FROM_UNIXTIME(e.end_date), '%k:%i') AS EndTime, e.eventname, e.locname, e.locpostcode, e.description, e.ticketurl, CASE WHEN e.town_id != t.id THEN '' WHEN e.town_id != tt.id THEN CASE WHEN l.id = 0 THEN CONCAT( s.Name, ', ', t.Name ) ELSE CASE WHEN s.id = 0 THEN l.Name ELSE CONCAT( s.Name, ', ', l.Name, ', ', t.Name ) END END ELSE CASE WHEN l.id = 0 THEN s.Name ELSE CASE WHEN s.id = 0 THEN l.Name ELSE CONCAT( s.Name, ', ', l.Name ) END END END AS Address, g.northing AS Latitude, g.easting AS Longitude, ( COALESCE( acos( g.xaxis * tg.xaxis + g.yaxis * tg.yaxis + g.zaxis * tg.zaxis), 0 ) * 6367.0 / 1.852 ) AS Distance, e.status FROM angle_events.events AS e LEFT JOIN paf.geocode g ON e.locpostcode = g.postcode LEFT JOIN paf.streets s ON g.street_id = s.id LEFT JOIN paf.localities l ON g.locality_id = l.id LEFT JOIN paf.towns t ON g.town_id = t.id INNER JOIN paf.towns tt ON tt.id = 863 INNER JOIN paf.geocode tg ON tt.mappoint = tg.postcode WHERE (e.town_id = 863 OR ( acos( g.xaxis * tg.xaxis + g.yaxis * tg.yaxis + g.zaxis * tg.zaxis ) * 6367.0 / 1.852 ) < 25) AND e.end_date > UNIX_TIMESTAMP() AND e.st_date < (UNIX_TIMESTAMP() + (182 * 86400) ) AND e.status > 0 AND e.tag LIKE '%youngsrambrew%' ORDER BY e.st_date ASC limit 100