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  ('2013-05-23' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2013-05-23' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Iniscealtra Festival of Arts - Mountshannon

Iniscealtra Festival of Arts - Mountshannon

26 May 2013 - 03 June 2013

Mountshannon

Multi-disciplinary Arts Festival in the lakeshore village of Mountshannon; music, film, dance and visual arts and green fair, with education programme and participatory event.

The Martin Fennell Memorial Tractor Run, Kilbaha

The Martin Fennell Memorial Tractor Run, Kilbaha

26 May 2013

Carrigaholt

A day for all the family to enjoy. All money raised for the Kilkee Marine Rescue.

Tuamgraney 2013

Tuamgraney 2013

30 May 2013 - 03 June 2013

Tuamgraney

A community weekend of welcomes for all ex pats and visitors. Events include a céilí, handball, sports, concert, music and craic. For further information contact Margaret O'Meara on 00353 87 2937479

Gathering at Doolin Cave

Gathering at Doolin Cave

30 May 2013
19:30 - 22:30

Doolin Cave, Roadford, Doolin, Co Clare

Local Doolin performers Gerry Howard and Kate Daly will take to the stage at Doolin Cave to celebrate the Gathering Ireland 2013 in “A Sense of Ireland through Song and Story”.

Clare Says Céad Míle Fáilte
Drumdigus National School Reunion, Kilmurry McMahon

Drumdigus National School Reunion, Kilmurry McMahon

31 May 2013

Kilrush

Past pupils of the two National Schools will meet to reminisce about their school days. All are welcome. Contact David Neylon 00353 86 1613355.