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-03-27' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-27' ) AND de.published =1  AND d.tid = 612
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Winter Tea Talks in Teach Ceoil, Corofin

Winter Tea Talks in Teach Ceoil, Corofin

21 January 2015 - 16 December 2015
20:30 - 23:00

Corofin

Our winter tea talks are back for a new year, on the third Wednesday of every month at 8.30pm in Teach Ceoil, Corofin. We hope you can join us.

National Pilgrim Paths Day

National Pilgrim Paths Day

04 April 2015
13:30 - 16:00

Corofin

Rath/Dysert Pilgrim Path Walk, Dysert O'Dea, Corofin, Co Clare. Registration by email before 31st March to piusm@eircom.net Starting Time: 1.30pm Distance: 8km Duration: 2.5 hours approx. Further information on www.facebook.com/CoisceimAnama or ring 087 9828173

‘Winter Leaves, Spring Shows’- April Walk

‘Winter Leaves, Spring Shows’- April Walk

05 April 2015
14:00 - 18:00

Corofin

‘Winter Leaves, Spring Shows’with Sharon Parr on 5th April, 2015 at 2pm at Creevagh/Cloncoose Green Road, Kilnaboy (51R 273 955).

Festival of Finn Corofin

Festival of Finn Corofin

30 April 2015 - 04 May 2015

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 joi...

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.