Wildfowl and Wetland Trust - The Wetland Centre

An urban oasis for wildlife and people, just 10 minutes from Hammersmith. Stroll among the lakes, ponds and gardens. The café is perfect for relaxing, and kids will love the play areas.

  • Currently: Medium-level cloud, 28° C
  • Sunday: Sunny intervals, 24° 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 '%wwtlondon%' ORDER BY e.st_date ASC limit 100