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

ANNUAL CLUB FUNDRAISER CLASSIC

ANNUAL CLUB FUNDRAISER CLASSIC

29 May 2015 - 01 June 2015

East Clare Golf Club, Bodyke, Co Clare

East Clare Golf Club are running the Annual Club Golf Classic. It will be held at East Clare Golf Club from the 29th May - June 1.

Ianís Trust To the Moon & Back Cycle, Run, Walk

Ianís Trust To the Moon & Back Cycle, Run, Walk

31 May 2015
08:30 - 15:00

Kilkee

The 3rd annual Moon & Back Charity Cycle/Run/Walk starting from the bandstand in Kilkee the route takes participants on a spectacular journey along the Wild Atlantic Way coastline.

Boruman Sprint Triathlon

Boruman Sprint Triathlon

13 June 2015
09:00 - 17:00

Killaloe

BORUMAN Sprint Triathlon is set in Killaloe town, right in the heart of the home of the original BORUMAN, The High King of Ireland, Brian Boru. 750m canal swim through the town, transitioning into a 23km fast, flat sprint cycle and finally a 5km run in Killaloe itself with an epic finish taking in the true heritage of the historic home of the last great High King. A great sprint event for the competitor preparing for Hell of The West and the many other events this summer. Ideal for those new to ...

Bank of Ireland Runway Night Run

Bank of Ireland Runway Night Run

19 June 2015 - 20 June 2015
00:00 - 03:00

Shannon

One of Irelandís most unique mass participation sports events of the year, the Bank of Ireland Runway Night Run at Shannon Airport, has got lift-off again, with this yearís event set for Saturday, June 19th at midnight.