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-22' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-12-22' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
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
Shannonside Winter Music Weekend

Shannonside Winter Music Weekend

15 January 2015 - 19 January 2015

Sixmilebridge

You’re in for a treat of great music, a warm welcome and an exceptional atmosphere at our unique festival, celebrating musical diversity with acts from the US, UK and all over the island of Ireland. Concerts and gigs at budget prices showcase the best of Bluegrass, blues, folk of all hues, classical and lots more, including the concert trail in Bunratty Folk Park. There are FREE “fleadh” style sessions along with poetry, singers' sessions, and pub gigs all weekend in Sixmilebridge. The sel...

Neil Delamere,  The Fresh Prince of Delamere

Neil Delamere, The Fresh Prince of Delamere

17 January 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

The Fresh Prince of Delamere Described by The Scotsman as “a master”, Delamere is renowned for his on-stage banter and quick-witted, well-observed yarns and previous tours and international appearances – including the Melbourne International Comedy Festival, Edinburgh Fringe Festival and the Montreal Just For Laughs Festival – have been a sell-out. Expect The Fresh Prince of Delamere to deliver the same powerhouse performance from the star of RTÉ’s The Panel, 2nd Republic, BBC’s The Blame Game...

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