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  ('2014-12-22' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-12-22' ) AND de.published =1  AND de.catid = 109 AND t.id = 612
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Corofin Traditional Festival

Corofin Traditional Festival

25 February 2015 - 01 March 2015

Corofin

Intimate festival of music and song, featuring Ireland's top traditional artists. Concerts, sessions, workshops and much much more.

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.

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

Ruan Gymkhana

Ruan Gymkhana

07 June 2015

Corofin

SJI registered show, 3 arenas, all grades of ponies and horses welcome. Show jumping, lead rein competition plus family fun for everyone. Activities planned for this year: cake sale, "guess the weight of the bull", face & nail painting, wellie throwing, children's fancy dress competition & much more. Entries open at 9.00am. Starting 9.30 sharp, all arenas.