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-05-30' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-05-30' ) AND de.published =1  AND de.catid = 109
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
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.

Doolin Folk Festival

Doolin Folk Festival

12 June 2015 - 14 June 2015

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

14 June 2015

Carrigaholt

Currach racing and entertainment at the pier in Kilbaha

National Flower Festival

National Flower Festival

19 June 2015 - 21 June 2015

Ennis

The Association of Irish Floral Artists brings the 'National Flower Festival' - "In Praise and Thanksgiving" to the Cathedral of Saints Peter and Paul and the St. Columba's Church of Ireland, Ennis on the 19th to 21st June 2015. Festival admission is 10euro.

Fleadh Cheoil an Chlair

Fleadh Cheoil an Chlair

19 June 2015 - 22 June 2015

Kilrush

Fleadh Cheoil an Chlair will take place in Clare from June 19th to 22nd. Competitions on Friday 19th for Set dancing. with the Music & singing competitions on Saturday 20th for U12s and U15s and on Sunday 21st for U18 and Adult.