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  ('2015-04-02' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-04-02' ) AND de.published =1  AND de.catid = 109
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Burren in Bloom

Burren in Bloom

01 May 2015 - 31 May 2015

Ballyvaughan

The Burren in Bloom Festival returns this year with a series of illustrated talks and organised walks throughout the month of 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.

Ireland's Best Beard and Moustache Championship

Ireland's Best Beard and Moustache Championship

01 May 2015 - 04 May 2015

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.

Carrigaholt Oyster and Traditional Music Festival

Carrigaholt Oyster and Traditional Music Festival

01 May 2015 - 03 May 2015

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.

World Stone Throwing Championship

World Stone Throwing Championship

03 May 2015

Corofin

16th Annual Series. Participants are challenged to break glass bottles placed on spikes. There is both a male and female cup and the competition is fierce. It attracts people from all over the globe as shown in the Hall of Fame. Cost of entry is €5 (for 5 stones). Over 18′s only. Legend has it that Fionn MacCumhail of the Fianna, who created the Giants Causeway is a past holder of the title. There are even suggestions that the Romans, having heard of the championship and terrified by t...

Clare Wellness Festival

Clare Wellness Festival

11 May 2015 - 17 May 2015

Falls Hotel & Spa, Ennistymon, Co Clare

All roads lead to Clare from 11-17th May when the spectacular setting of The Falls Hotel, Ennistymon hosts the inaugural Clare Wellness Week.

Clare Says Céad Míle Fáilte