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-04-17' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-04-17' ) AND de.published =1  AND de.catid = 110
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Boru Triclub Sprint Triathlon

Boru Triclub Sprint Triathlon

14 June 2014

Killaloe

A new Triathlon challenge created by the Boru Tri Club in celebration of the Brian Boru millennium year.

Burren Cycling Club - An Post Tour De Burren

Burren Cycling Club - An Post Tour De Burren

21 June 2014

Ballyvaughan

The An Post Tour de Burren is a fantastic road cycling event which starts in Ballyvaughan and takes in many of the beautiful scenic locations around North Clare. There are four routes to choose from so you are gauranteed to find a route to suit you.

Hell of the West-Kilkee Triathlon

Hell of the West-Kilkee Triathlon

28 June 2014

Kilkee

This event is an Olympic Distance Triathlon and 2014 will mark the 30th year of the event. During the cycle portion of the race, a kids Splash and Dash takes place on the beach.

Junior Tour of Ireland

Junior Tour of Ireland

15 July 2014 - 20 July 2014

Ennis

This is a 6 day International Cycling Race for 16-18 year olds. These stars of the future will race over 600 kilometres on courses that will take in some of the most challenging, yet scenic rods County Clare has to offer. Cyclists will participate from all over Ireland against foreign opposition from countries such as America, England Isle of Man, Holland, South Africa, Belgium.

Brian Ború Tri Challenge 2014

Brian Ború Tri Challenge 2014

08 August 2014

Killaloe

Entering is 6th year The Brian Ború Triathlon Challenge Sprint and Olympic Distance races, invites you to take up the gauntlet on the most scenic and unique triathlon course based on the shores of Lough Derg at Twomilegate, Killaloe Co.Clare. This epic race involves a lake swim in Lough Derg.