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-08-03' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-08-03' ) AND de.published =1  AND de.catid = 108 AND d.id = 699
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
‘Segullah - Treasured Possession’ - New mixed media work, pondering notions of belonging by Ann Vaug

‘Segullah - Treasured Possession’ - New mixed media work, pondering notions of belonging by Ann Vaug

17 July 2015 - 06 August 2015

Ennistymon Courthouse Gallery, Parliament Street, Ennistymon, Co Clare

‘Segullah - Treasured Possession’ -New mixed media work, pondering notions of belonging by Ann Vaughan From July 17 – August 6. Ann Vaughan is a native of Liscannor, County Clare, and a graduate of CCAM Galway. She works from her Open Studio by the shore in Clahane, Liscannor.

'Don't rely on the starry skies' a multi-disciplinary exhibition by Audrey O'Brien & Willie Redmond,

'Don't rely on the starry skies' a multi-disciplinary exhibition by Audrey O'Brien & Willie Redmond,

18 July 2015 - 06 August 2015

Ennistymon Courthouse Gallery, Parliament Street, Ennistymon, Co Clare

‘So don't rely on the starry skies’ - A multi-disciplinary exhibition by Audrey O’Brien and Willie Redmond From July 18 - August 6. Visit website for opening hours.