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  ('2014-12-21' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-12-21' ) AND de.published =1  AND de.catid = 107 AND d.id = 129
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Kilfenora Céilí Band

Kilfenora Céilí Band

03 January 2015
10:17 - 20:00

glór, Causeway Link, Ennis, Co Clare

A brand new album is on the way from the Kilfenora. After an obvious musical gear-change arising from the appointment of Kevin Crawford as producer of Chapter 8, their eagerly-awaited ninth collection, is about to hit the shelves.

Clare Says Céad Míle Fáilte
Sea Road Sessions

Sea Road Sessions

10 January 2015 - 28 January 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

Bringing Together 6 Critically Acclaimed Traditional/Folk Musicians from Ireland, Scotland & Sweden The ‘Sea Road’ designates the maritime route historically linking Sweden, Scotland and Ireland, the home countries of a brand new six-piece line-up comprising singer/guitarist Kris Drever, accordionist Alan Kelly, guitarist Ian Carr, banjo ace Éamonn Coyne, flautist/singer Steph Geremia and bassist Staffan Lindors

Clare Says Céad Míle Fáilte
Reeling In The Showband Years

Reeling In The Showband Years

15 January 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

The show’s exciting finale is an ALL Cast Salute to the Showband Era - all of the stars join in for a medley of songs from the unique Showband Years! Bringing you back in time to this magical musical period.

Clare Says Céad Míle Fáilte
Maura O’ Connell, Karan Casey, Martin Tourish & Ed Boyd

Maura O’ Connell, Karan Casey, Martin Tourish & Ed Boyd

18 January 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

Presented by Music Network Witness the first collaboration of legendary singers Maura O’Connell and Karan Casey as they are joined by accordionist Martin Tourish and guitarist Ed Boyd this Spring. With a Grammy nomination, TG4 Musician of the Year title, BBC Folk Award and over one million album sales between them, this promises to be an incredible evening with some of the biggest talents in Irish music.

Clare Says Céad Míle Fáilte
Tommy Fleming

Tommy Fleming

24 January 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

The West’s Awake A Tommy Fleming concert is a unique and emotional musical experience suitable for all ages. His performance is always delivered with electric emotion and surrounded by his world class band. Tommy’s concert is the one concert this year you should not miss.

Clare Says Céad Míle Fáilte