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-21' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-12-21' ) AND de.published =1  AND t.id = 612
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Christmas Experience at the Farmyard

Christmas Experience at the Farmyard

06 December 2014 - 22 December 2014

The Farmyard Activity Farm, Dabrian, Corofin, Co Clare

Create magical childhood memories at The Farmyard, Corofin, Christmas Experience on the 6th, 7th, 13th, 14th, 19th, 20th, 21st and 22nd of December Described in Trip advisor as by far the best Santa experience on the market, The Farmyard in Corofin is a magical place to meet Santa. Situated in the idyllic Burren region, the Farmyard in Corofin, Co Clare is only a 20 minute drive from Ennis and it is well worth a trip.

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