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

Diving Competition

02 August 2014

Kilkee

Diving Competition Time will be weather dependent. Contact Deirdre Martin on 087 6811828 for further details.

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.

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.

Adult Swimming Lessons

Adult Swimming Lessons

02 September 2014 - 30 September 2014
19:00 - 19:45 Every Tuesday

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

Adult Swimming Lessons for all abilities

Clare Says Céad Míle Fáilte
Declan Hayes Memorial: Half Marathon & 10k Run/Walk

Declan Hayes Memorial: Half Marathon & 10k Run/Walk

06 September 2014

Doonbeg

This September run/walk event is in memory of local man Declan Hayes who died on the 26th Oct 2010 aged 43 yrs ,as a result of a motor bike accident.Declan was a great sportsman & athlete.He also took part in Doonbeg Drama festival. 2014 will be our 4th annual event.Our 10k walk/run takes in a very scenic looped route overlooking the white strand beach & Doughmore sandhills. The half marathon route is made up the 10k loop & a second loop which goes in around the famous Doonbeg golf ...