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-20' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-04-20' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Deesigner Balloons Twisting Workshop

Deesigner Balloons Twisting Workshop

22 April 2014
12:00 - 13:00

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

Balloon twisting workshops are a buzz of colour, fun and excitement and are a big hit with all ages. Deesigner balloon workshops give each child hands on experience in creative balloon twisting and self-expression and is also a great way for building confidence and dexterity.

Clare Says Céad Míle Fáilte
Bóroimhe Suite

Bóroimhe Suite

23 April 2014

Killaloe

Comhaltas Ceoltóirí Eireann has commissioned composer Michael Rooney to write a suite of music reflecting not just the death at Clontarf, but also the life of Brian Ború. The Bóroimhe Suite will be performed in Killaloe, Cashel, Clontarf and Armagh by the reformed National Folk Orchestra of Ireland.

The Big Pink Gig

The Big Pink Gig

24 April 2014
14:00 - 18:00

Killaloe

A night of music by local choirs, Killaloe Ballina Gospel Choir, The Gunas, Killaloe Ballina Youth Choir as well as choirs from other areas. Proceeds to Killaloe Pink Ribbon/Cancer Ireland.

Keith Barry - Brain Hacker

Keith Barry - Brain Hacker

24 April 2014
20:00 - 23:00

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

Keith Barry returns to glór with his new show, Brain Hacker.

Clare Says Céad Míle Fáilte
Fleadh Nua 40th Anniversary Concert

Fleadh Nua 40th Anniversary Concert

24 April 2014 - 24 May 2014
20:00 - 22:00

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

This concert will celebrate 40 years of Fleadh Nua in Ennis.

Clare Says Céad Míle Fáilte