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-04-24' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-04-24' ) AND de.published =1  AND de.catid = 107 AND t.id = 616
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
A Millennium Celebration of Brian Ború

A Millennium Celebration of Brian Ború

23 May 2014
08:00 - 10:00

glór Irish Music Centre, Causeway Link, Ennis, Co Clare

Comhaltas Ceoltóirí Éireann has commissioned composer Michael Rooney to write a suite of music reflecting the life of Brian Ború.

Clare Says Céad Míle Fáilte
Kilfenora Ceili Band in Concert

Kilfenora Ceili Band in Concert

25 May 2014
20:00 - 22:00

glór Irish Music Centre, Causeway Link, Ennis, Co Clare

102 years in the business, the Kilfenora has gone from strength to strength since their centenary! From village parties in the early 1900s right down to their current international profile in the new millennium, each new generation slots seamlessly into the groove of their forebears.

Clare Says Céad Míle Fáilte
Declan O’Rourke

Declan O’Rourke

06 June 2014
20:00 - 23:00

glór Irish Music Centre, Causeway Link, Ennis, Co Clare

2014 will see Declan return to the studio for the recording of his highly-anticipated side project of original songs on the Irish Great Famine and he comes to glór or one night only.

Clare Says Céad Míle Fáilte
Love: Live Music Day

Love: Live Music Day

21 June 2014

Clare County Library, Mill Road, Ennis, Co Clare

Free music events, concerts and performances taking place throughout the county to celebrate International Music Day.

Harlem Gospel Choir

Harlem Gospel Choir

12 November 2014
20:00 - 23:00

glór Irish Music Centre, Causeway Link, Ennis, Co Clare

Having performed for Nelson Mandela at the Yankee Stadium, for the Pope in Central Park, with the Chieftains on their US tour and on U2's “Rattle and Hum” album, film and tour, the Harlem Gospel Choir will, once again, return to Ireland for an extensive tour.

Clare Says Céad Míle Fáilte