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  ('2016-02-12' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2016-02-12' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Bunratty Chess Festival

Bunratty Chess Festival

19 February 2016 - 21 February 2016

Bunratty

This tournament is open to chess players of all strengths and ages. It takes place in Bunratty Castle Hotel. All are welcome.

Conal Gallen - A Laugh and a Half

Conal Gallen - A Laugh and a Half

19 February 2016
20:00 - 22:00

glór, Causeway Link, Ennis, Co Clare

Ireland's ambassador of comedy, Conal Gallen is back on stage with his hilarious new one man stand up show.

Clare Says Céad Míle Fáilte
Eddi Reader

Eddi Reader

20 February 2016
20:00 - 22:15

glór, Causeway Link, Ennis, Co Clare

glór is delighted to welcome internationally acclaimed Scottish songstress Eddi Reader back to Clare. With a career spanning over 3 decades, Eddi Reader has effortlessly developed into one of popular music’s most thrilling and affecting performers.

Clare Says Céad Míle Fáilte
Winter Pruning in the Orchard at Irish Seed Savers

Winter Pruning in the Orchard at Irish Seed Savers

20 February 2016
10:00 - 17:00

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

The workshop gives a detailed and practical introduction to formative, maintenance, restorative and disease pruning through theory, orchard observations and pruning demonstrations. By the end of the day you will have the skills to make informed pruning decisions on a wide range of trees.

The Loves of Cass Maguire by Brian Friel

The Loves of Cass Maguire by Brian Friel

23 February 2016 - 27 February 2016
20:00 - 22:00 Every Tuesday

glór, Causeway Link, Ennis, Co Clare

Clare Says Céad Míle Fáilte