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-05-26' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-05-26' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Doolin Heritage Weekend

Doolin Heritage Weekend

19 June 2015 - 21 June 2015

Doolin

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

National Flower Festival

National Flower Festival

19 June 2015 - 21 June 2015

Ennis

The Association of Irish Floral Artists brings the 'National Flower Festival' - "In Praise and Thanksgiving" to the Cathedral of Saints Peter and Paul and the St. Columba's Church of Ireland, Ennis on the 19th to 21st June 2015. Festival admission is 10euro.

Bank of Ireland Runway Night Run

Bank of Ireland Runway Night Run

19 June 2015 - 20 June 2015
00:00 - 03:00

Shannon

One of Ireland’s most unique mass participation sports events of the year, the Bank of Ireland Runway Night Run at Shannon Airport, has got lift-off again, with this year’s event set for Saturday, June 19th at midnight.

Fleadh Cheoil an Chlair

Fleadh Cheoil an Chlair

19 June 2015 - 22 June 2015

Kilrush

Fleadh Cheoil an Chlair will take place in Clare from June 19th to 22nd. Competitions on Friday 19th for Set dancing. with the Music & singing competitions on Saturday 20th for U12s and U15s and on Sunday 21st for U18 and Adult.

Burren Cycling Club - An Post Tour De Burren

Burren Cycling Club - An Post Tour De Burren

20 June 2015

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.