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-03-28' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-28' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Run Clare 2015 Eamon Moloney 10K

Run Clare 2015 Eamon Moloney 10K

28 March 2015

Ennis

County Clare's newest race series, 4 races, 4 months, 1 goal. Be sure to be a part of this exciting experience where you will progress from 5km to 5 miles to 10km to 10 miles.

Sharp Shooters Airsoft Indoor League

Sharp Shooters Airsoft Indoor League

29 March 2015
14:00 - 18:30

Lisdoonvarna

Sharp Shooters Airsoft Indoor League at The Pavilion, Lisdoonvarna on Sunday March 29th.

Duathlon National Championships

Duathlon National Championships

29 March 2015
08:30 - 17:00

Ennis

The National Duathlon Championship is coming to Ennis this Sunday 29th March 2015. The race is being organised by the Ennis Triathlon Club with the much appreciated support of Clare County Council. The race will be based at Lees Road Sports facility and commences at 10.30am.

Easter Activities Camp @ Shannon Leisure Centre

Easter Activities Camp @ Shannon Leisure Centre

30 March 2015 - 03 April 2015
09:30 - 14:30 Every Monday

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

Fun and Games camp for kids aged 5-12yrs

Clare Says Céad Míle Fáilte
Nevsail Watersports Easter Watersports Camps

Nevsail Watersports Easter Watersports Camps

30 March 2015 - 10 April 2015

Nevsail Watersports, The Promenade, Kilkee, Co Clare

Kilkee Watersports Camps at Kilkee beach are a must for all kids aged 6 - 16 years.