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-26' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-04-26' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Burren Food Trail Mondays

Burren Food Trail Mondays

05 January 2015 - 28 September 2015
Every Monday

Ballyvaughan

Every Monday a themed food event will take place in locations around the Burren. Each individual event represents a unique opportunity to combine good food with real, authentic interaction with the people who produced or prepared it, or indeed with the surrounding landscape and heritage.

Winter Tea Talks in Teach Ceoil, Corofin

Winter Tea Talks in Teach Ceoil, Corofin

21 January 2015 - 16 December 2015
20:30 - 23:00

Corofin

Our winter tea talks are back for a new year, on the third Wednesday of every month at 8.30pm in Teach Ceoil, Corofin. We hope you can join us.

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 ...

Durty Nelly's Nightly Music Session

Durty Nelly's Nightly Music Session

01 March 2015 - 31 October 2015
21:30 - 23:30

Durty Nelly's, Bunratty, Co. Clare

Clare Says Céad Míle Fáilte
French for Fun For Kids

French for Fun For Kids

14 March 2015 - 02 May 2015
10:00 - 16:00 Every Saturday

glór, Causeway Link, Ennis, Co Clare

An opportunity for 4-12 year olds to learn French through games, songs, rhymes, stories, role-plays and fun!

Clare Says Céad Míle Fáilte