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-06-30' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-06-30' ) AND de.published =1  AND de.catid = 108 AND d.id = 540
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Art Exhibition by Mary Found O'Halloran called Endurance

Art Exhibition by Mary Found O'Halloran called Endurance

22 June 2015 - 18 July 2015

Clare Museum, Arthur's Row, Ennis, Co Clare

Mary Foudy O’Halloran (b.1952) is an Irish artist born in Clare and based in South Galway. She has exhibited nationally with solo shows such as Weighed, Ballina Arts Centre, Co. Mayo (2014). Group shows include Glor Ennis 2006; Iontas, Sligo 2007; Claremorris 2007; Ennistymon and Ballina, 2009. Foudy O’Halloran received the Student of the Year award upon graduation from the Cluain Mhuire Art School as part of GMIT in 2006. She is a member of Visual Arts Ireland and KAVA.

Clare Says Céad Míle Fáilte