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-13' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2016-02-13' ) AND de.published =1  AND de.catid = 109
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Celebration of Tulla Céilí Band 1946 - 2016

Celebration of Tulla Céilí Band 1946 - 2016

29 April 2016 - 01 May 2016
16:43 - 16:43

Feakle

A celebration of 70 years of the Tulla Céilí Band - a weekend of lectures, céilithe, concerts and sessions with special guests.

Carrigaholt Oyster and Traditional Music Festival

Carrigaholt Oyster and Traditional Music Festival

29 April 2016 - 01 May 2016

Carrigaholt

A lively festival on The Loop Head Peninsula, County Clare, the Carrigaholt Oyster and Trad Festival joins two Irish loves, Great Music and Great Food. A celebration of Irish Gigas Oysters that are grown locally , the festival offers to serve you up your fill of complimentary oysters and traditional music over the May Bank Holiday weekend.

Father Ted Festival

Father Ted Festival

30 April 2016 - 01 May 2016

Kilfenora

A festival of all things Father Ted, there will be location tours, a visit to the Parocial House, Lovely Girls contest, Golden Cleric awards and loads of craic and musical entertainment.

Ireland's Best Beard and Moustache Championship

Ireland's Best Beard and Moustache Championship

30 April 2016

Corofin

Hirsute competitors descend on Corofin during Festival of Finn to show off their prize-winning whiskers. This event is held in cooperation with the Irish Beard and Moustache Association, and attracts competitors from Ireland, Europe, and North America. Categories for Ireland Best Beard and Moustache competition will include Best Moustache, Best Partial Beard, Best Full Beard, Best Trend Beard, Best Six Week Beard, and Best Fake Beard.

Burren in Bloom

Burren in Bloom

01 May 2016 - 15 May 2016

Ballyvaughan

The Burren in Bloom Festival returns this year with a series of illustrated talks and organised walks from 1st to 15th May. The Festival, in association with the Burren College of Art and the Burrenbeo Trust, will give people an understanding and appreciation of the Burren and its formation, and how it continues to be a source of great botanical, archaeological, and cultural wealth with its unique wild flowers and ancient sites.