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-08' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2016-02-08' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Summer Workshops at the Burren College of Art

Summer Workshops at the Burren College of Art

08 August 2016 - 12 August 2016

The Burren College of Art, Newtown Castle, Ballyvaughan, Co Clare

A combination of new and traditional five day workshops in painting, drawing, photography and more.

Fleadh Cheoil na hÉireann 2016

Fleadh Cheoil na hÉireann 2016

14 August 2016 - 21 August 2016

Ennis

Ennis Town has been announced as the host venue for the Fleadh Cheoil na hÉireann in 2016. More details will follow.

Summer Workshops at the Burren College of Art

Summer Workshops at the Burren College of Art

15 August 2016 - 19 August 2016

The Burren College of Art, Newtown Castle, Ballyvaughan, Co Clare

A combination of new and traditional five day workshops in painting, drawing, photography and more.

Carrigaholt Family Festival

Carrigaholt Family Festival

19 August 2016 - 21 August 2016
11:10 - 11:10

Carrigaholt

Traditional village festival with music, dancing, sports and fancy dress. Events such as Sheaf Throwing, Tug a War and nail driving competition make for great viewing and family events such as the Car Treasure Hunt, the Water Fun Run and Sand Castle building competition mean there is something for the whole family.

Burren Executive Leadership Retreat

Burren Executive Leadership Retreat

21 August 2016 - 24 August 2016

The Burren College of Art, Newtown Castle, Ballyvaughan, Co Clare

The Burren Executive Leadership Retreat brings together accomplished and emerging leaders from all sectors around the world with renowned artists.