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-03-31' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-31' ) 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 ...

Nevsail Watersports Easter Watersports Camps

Nevsail Watersports Easter Watersports Camps

30 March 2015 - 10 April 2015

Nevsail Watersports, The Promenade, Kilkee, Co Clare

Kilkee Watersports Camps at Kilkee beach are a must for all kids aged 6 - 16 years.

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.

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.

Clare Burren Marathon Challenge

Clare Burren Marathon Challenge

23 May 2015

Ballyvaughan

This is a road, green road and trail challenge across the Beautiful Scenic Burren. Enjoy some of Europe's most unique landscapes, see the Riches of the Burren in Bloom while walking or running along The Wild Atlantic Way. Each participant has a choice of Full, Half or 10k Mini marathon on the day.