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-18' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2013-05-18' ) AND de.published =1  AND d.id = 617
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Two photographers :Niall Kerrigan and Patrick McHugh in the Courthouse Gallery

Two photographers :Niall Kerrigan and Patrick McHugh in the Courthouse Gallery

04 May 2013 - 30 May 2013

Ennistymon 

Two photographers :Niall Kerrigan and Patrick McHugh in the Courthouse Gallery.

Clare Association Annual Dinner in the Falls Hotel, Ennistymon

Clare Association Annual Dinner in the Falls Hotel, Ennistymon

18 May 2013

Ennistymon 

Music by the Kilfenora Céilí Band at the Falls Hotel. We hope that for this special night you will have your own "Gathering" of family and friends from home and abroad so come and join us on this great occasion. For further details call Gerry O'Reilly 00353 86 8498192.