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

Doonbeg Regatta

04 August 2014

Doonbeg

August Bank Holiday Monday at Doonbeg Pier. The Doonbeg Currach Regatta was revived in 2005 after an absence of almost 20 years. A great day of rowing is guaranteed with twelve races taking place. These consist of Traditional 3 Hand Mens & Ladies (Confined and Open), 4 Hand Naomhog and Mixed. For the winners there are Perpetual Cups, Trophies and Prize money.

Kilrush Traditional Music and Set Dancing Festival 2014

Kilrush Traditional Music and Set Dancing Festival 2014

06 August 2014 - 10 August 2014

Kilrush

Includes three open air ceilis in the town square with the Johnny Reidy Ceili Band, the Five Counties Band and the Star of Munster Band, set dancing classes, a singers club and numerous music sessions. There will also be a musical boat trip to Scattery Island. A Festival not to be missed.

Brian Ború Tri Challenge 2014

Brian Ború Tri Challenge 2014

09 August 2014

Killaloe

The Brian Boru Tri Challenge is a Triathlon Ireland sanctioned event organised by Boru Tri Club. Athletes can take part in the shorter sprint course or the standard course.

Kilmurry Harvest Festival and All Ireland Vintage Rally

Kilmurry Harvest Festival and All Ireland Vintage Rally

10 August 2014 - 16 August 2014

Sixmilebridge

Kilmurry Harvest Festival is a week long fun-packed event with attractions for all the family. The event includes the all Ireland vintage rally, a field day, monster vintage show, show-jumping competition, carriage driving and sheep racing, to mention just a few.

Intensive Swimming Lessons @ Shannon Leisure Centre

Intensive Swimming Lessons @ Shannon Leisure Centre

11 August 2014 - 22 August 2014
15:30 - 16:15

Shannon Swimming & Leisure Centre, Bothar Linne, Tullyglass, Shannon, Co Clare

2 weeks of intensive swimming lessons for kids ages 5 - 13yrs

Clare Says Céad Míle Fáilte