SELECT,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.attributes,is_recuring,is_all_day, as town_id,t.title as town_title,c.title as cat_title, as cat_id,,c.image,d.latlang,de.web
 FROM cl_directory_events AS de
 LEFT JOIN cl_directory AS d on de.did
 LEFT JOIN cl_directory AS t on d.tid
 INNER JOIN cl_categories AS c on de.catid
 WHERE  ('2014-07-28' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-07-28' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Lughnasa Festival @ Cragaunowen 2014

Lughnasa Festival @ Cragaunowen 2014

03 August 2014 - 04 August 2014
11:00 - 17:00

Craggaunowen- 'The Living Past Experience', Kilmurry, Near Sixmilebridge, Co Clare

Visitors to Craggaunowen visitor attraction near Quin, Co Clare during the August Bank Holiday weekend (Sunday 3rd and Monday 4th August) will be swept back in time to experience a special ‘Lughnasa’ celebration spanning the Iron Age through the Early Medieval, Viking Age, the Anglo-Normans to the 16th Century.

Clare Says Céad Míle Fáilte
Doonbeg Regatta

Doonbeg Regatta

04 August 2014


August Bank Holiday Monday at Doonbeg Pier. The Doonbeg Currach Regatta was revived in 2005 after an absence of almost 20 years. A great day of rowing is guaranteed with twelve races taking place. These consist of Traditional 3 Hand Mens & Ladies (Confined and Open), 4 Hand Naomhog and Mixed. For the winners there are Perpetual Cups, Trophies and Prize money.

Kilrush Traditional Music and Set Dancing Festival 2014

Kilrush Traditional Music and Set Dancing Festival 2014

06 August 2014 - 10 August 2014


Includes three open air ceilis in the town square with the Johnny Reidy Ceili Band, the Five Counties Band and the Star of Munster Band, set dancing classes, a singers club and numerous music sessions. There will also be a musical boat trip to Scattery Island. A Festival not to be missed.

Brian Ború Tri Challenge 2014

Brian Ború Tri Challenge 2014

09 August 2014


The Brian Boru Tri Challenge is a Triathlon Ireland sanctioned event organised by Boru Tri Club. Athletes can take part in the shorter sprint course or the standard course.

Kilmurry Harvest Festival and All Ireland Vintage Rally

Kilmurry Harvest Festival and All Ireland Vintage Rally

10 August 2014 - 16 August 2014


Kilmurry Harvest Festival is a week long fun-packed event with attractions for all the family. The event includes the all Ireland vintage rally, a field day, monster vintage show, show-jumping competition, carriage driving and sheep racing, to mention just a few.