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  ('2016-02-13' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2016-02-13' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Boruman Sprint Triathlon

Boruman Sprint Triathlon

11 June 2016

Killaloe

BORUMAN Sprint Triathlon is set in Killaloe town, right in the heart of the home of the original BORUMAN, The High King of Ireland, Brian Boru. 750m canal swim through the town, transitioning into a 23km fast, flat sprint cycle and finally a 5km run in Killaloe itself with an epic finish taking in the true heritage of the historic home of the last great High King. A great sprint event for the competitor preparing for Hell of The West and the many other events this summer. Ideal for those new to ...

Kilbaha Currach Racing

Kilbaha Currach Racing

12 June 2016

Carrigaholt

Currach racing and entertainment at the pier in Kilbaha

Ruan Gymkhana

Ruan Gymkhana

12 June 2016

Corofin

SJI registered show, 3 arenas, all grades of ponies and horses welcome. Show jumping, lead rein competition plus family fun for everyone. Activities planned for this year: cake sale, "guess the weight of the bull", face & nail painting, wellie throwing, children's fancy dress competition & much more. Entries open at 9.00am. Starting 9.30 sharp, all arenas.

Hell of the West-Kilkee Triathlon

Hell of the West-Kilkee Triathlon

18 June 2016

Kilkee

This event is an Olympic Distance Triathlon. Not for the feint hearted, come and see men and women challenge their endurance ability in one of the toughest events on the peninsula. Plenty to see and do on Loop Head.

Doolin Heritage Weekend

Doolin Heritage Weekend

18 June 2016 - 19 June 2016

Doolin

A weekend of talks on the Archaelogy of the Burren, Built heritage and Conservation. Heritage walks and site visits, organised by Doolin Heritage.