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-11-29' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-11-29' ) AND de.published =1  AND d.id = 612
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
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...

The Cora-Ween Revamp

The Cora-Ween Revamp

17 November 2015 - 23 November 2015

Corofin

A week-long Halloween event starting October 17 with an upcycling costume workshop for adults and children at the GAA Hall, run by Rainbow Upcycling. Witches Walk on Bank Holiday Monday, October 26. Events continue with Halloween festivities at An Cupan Tae Cafe, which will include story-telling, face-painting, traditional Irish games, and lots more fun for the entire family. Spooktacular Kiddie Disco with date and time to be determined.