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

Xterra World Series Off-Road Triathlon

Xterra World Series Off-Road Triathlon

19 July 2014 - 20 July 2014

Killaloe

This epic race involves a lake swim in Lough Derg, a cycle course overlooking Lough Derg passing by the Brian Boru oak tree and St Cronans 10th century church and a run on the steep slopes at Ballycuggeran.

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.