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 de.catid = 109
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Doolin Folk Festival

Doolin Folk Festival

10 June 2016 - 12 June 2016

Doolin

Taking inspiration from the great festivals of the 70s and 80s – like Lisdoonvarna down the road, and from the deep musical roots of the County, Doolin 2016 will again present powerful music in an intimate setting and ensure that audiences and musicians can feel at one and just enjoy the communal spirit of such festivals.

Kilbaha Currach Racing

Kilbaha Currach Racing

12 June 2016

Carrigaholt

Currach racing and entertainment at the pier in Kilbaha

Ruan Gymkhana

Ruan Gymkhana

12 June 2016

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.

Spancil Hill Fair

Spancil Hill Fair

23 June 2016

Tulla

Free fun and entertainment for all the family. All are welcome.

Fleadh Cheoil an Chlair

Fleadh Cheoil an Chlair

24 June 2016 - 26 June 2016

Kilrush

Fleadh Cheoil an Chlair will take place in Clare from 24th - 26th June. Competitions will take place on Friday for set dancing and the music & singing competitions will take place on Saturday for U12s and U15s and on Sunday for U18 and Adult.