SELECT de.id,de.title,case when date_format(date_start,'%d %M %Y') = date_format(date_end,'%d %M %Y') then date_format(date_start,'%d %M %Y') else CONCAT(date_format(date_start,'%d %M %Y'),' - ',date_format(date_end,'%d %M %Y')) end event_date,case when is_all_day = 1 then '' else CONCAT(date_format(date_start,'%H:%i'),' - ',date_format(date_end,'%H:%i')) end event_time,case when is_recuring =1 then  CONCAT(' Every ',date_format(date_start,'%W'))  else '' end event_day ,d.address,d.title as dir_name, d.address1,d.address2,de.introtext,d.tid,d.country,d.attributes,is_recuring,is_all_day,
 t.id as town_id,t.title as town_title,c.title as cat_title,c.id as cat_id,c.name,c.image,d.latlang,de.web
 FROM cl_directory_events AS de
 LEFT JOIN cl_directory AS d on de.did =d.id
 LEFT JOIN cl_directory AS t on d.tid =t.id
 INNER JOIN cl_categories AS c on de.catid =c.id
 WHERE  ('2015-04-18' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-04-18' ) AND de.published =1  AND de.catid = 110
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Guided Walks in the ancient Raheen Oakwoods of Tuamgraney

Guided Walks in the ancient Raheen Oakwoods of Tuamgraney

01 March 2015 - 23 August 2015

Tuamgraney

Andrew St Ledger, the well known Clare based native woodland specialist will take people on a journey through the ancient Raheen oakwood, an extremely rare remnant of the ancient wildwood authentic landscape of Ireland. Andrew will explain how the Past, Present and Future are linked by our native trees, learn about the value and importance of the flora and fauna associated with such habitats for biodiversity, flood relief, climate change, etc. Find out how the ancestors valued their forests via ...

Turas na mBan

Turas na mBan

25 April 2015
09:00 - 17:00

Ennis

Turas na mBan is a female only cycle sportive run by Clare Ladies Cycling Club. The concept of the event is to bring female cyclists together to Improve fitness form friendships and most of all have fun.

Cathal and Rheas Mount Callan Challenge

Cathal and Rheas Mount Callan Challenge

26 April 2015
11:30 - 15:00

Miltown Malbay

Cathal and Rhea's Mount Callan Challenge will take place on Sunday 26th April.Registration from 11.30am.

Special All Day Burren in Bloom Walk

Special All Day Burren in Bloom Walk

16 May 2015
10:00 - 16:00

Ballyvaughan

A very special, all day addition to Burren in Bloom’s programme for 2015, ‘Summer Blooms - a day's walk over the finest Burren pastures’ takes place on May 16th. Led by local land owners, Burrenbeo Trust and heritage experts, you will spend the day walking in beautiful surroundings and along the way hear the stories of the past, present and future of the Burren and its heritage.

Seol Sionna Traditional Boating Festival

Seol Sionna Traditional Boating Festival

17 May 2015

Kilkee

Currach racing and boating at Querrin Pier. For further information contact Trea Heapes on 00353 86 3819216.