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 d.tid = 612
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
The Holy Wells of Clare - An Illustrated Talk - X-PO Killinaboy

The Holy Wells of Clare - An Illustrated Talk - X-PO Killinaboy

25 February 2016
20:30 - 22:00

X-PO Kilnaboy, Kilnaboy, Co Clare

X-PO Killinaboy will host an illustrated talk by Michael Houlihan on Thursday the 25th of February at 8.30 pm. The talk is entitled "The Holy Wells of Clare”.

Corofin Traditional Festival

Corofin Traditional Festival

29 February 2016 - 07 March 2016

Corofin

Corofin Traditional Festival is an intimate festival of traditional music and song, featuring Ireland's top traditional artists. Concerts, sessions, workshops and much much more.

Festival of Finn Corofin

Festival of Finn Corofin

28 April 2016 - 02 May 2016

Corofin

The weekend kicks off on Thursday night with an assemblage of the funniest, most entertaining story-tellers in Clare. It comes to a rollicking end on Monday with the Festival Fancy Dress Parade and Lark at the Lake. From the opening recitations on Thursday til the sun sets Monday evening, there's a large Programme of Events from which to choose. Coupled with Corofin’s unique setting of lakes, historical venues, mystical stone landscape, and great expanse of sky, you have every reason to j...

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.

17th Annual World Stone-Throwing Championship

17th Annual World Stone-Throwing Championship

01 May 2016

Corofin

17th 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...