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-17' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-04-17' ) AND de.published =1  AND d.id = 129
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Pictiúr

Pictiúr

21 March 2014 - 30 April 2014
10:00 - 17:00

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

Children’s illustration offers a unique opportunity for literature and visual art to intersect. Showcasing twenty-one artists, Pictiúr demonstrates the range, scope and skill of Irish illustrators.

Clare Says Céad Míle Fáilte
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
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
Lumiere

Lumiere

25 April 2014
20:00 - 23:00

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

With Lumiere, the song and its delivery are the primary focus, technical concerns gives way to feeling as song and singer effortlessly merge.

Clare Says Céad Míle Fáilte