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-27' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-27' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Doolin Heritage Weekend

Doolin Heritage Weekend

19 June 2015 - 21 June 2015

Doolin

A weekend of talks on the Archaelogy of the Burren, Built heritage and Conservation. Heritage walks and site visits, organised by Doolin Heritage.

Fleadh Cheoil an Chlair

Fleadh Cheoil an Chlair

19 June 2015 - 22 June 2015

Kilrush

Fleadh Cheoil an Chlair will take place in Clare from June 19th to 22nd. Competitions on Friday 19th for Set dancing. with the Music & singing competitions on Saturday 20th for U12s and U15s and on Sunday 21st for U18 and Adult.

Brendan Shine

Brendan Shine

24 June 2015
20:00 - 22:00

glór, Causeway Link, Ennis, Co Clare

Brendan Shine celebrates his 50th Anniversary with a summer tour of Ireland playing all of his favourite and best known songs.

Clare Says Céad Míle Fáilte
My Fair Ladies

My Fair Ladies

25 June 2015
20:00 - 22:30

glór, Causeway Link, Ennis, Co Clare

Following the phenomenal world-wide success of his show The Love-Hungry Farmer by John B. Keane, which he also adapted, Des has devised and will perform in a hugely entertaining new play about the many ladies in the extraordinary life of one of the greatest playwrights of all time.

Clare Says Céad Míle Fáilte
Santosa Yoga Festival

Santosa Yoga Festival

26 June 2015 - 28 June 2015

Carrigaholt

3-day festival of Yoga from dawn to dusk in the beautiful setting of Purecamping in the Loop Head Peninsula. Yoga from all traditions - Yoga for Children - Children's activities - The Yoga Cafe - Music and song and lots of laughs. Chill out and make some space for yourself, your friends and family at Santosa this year.