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  ('2015-07-04' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-07-04' ) AND de.published =1  AND = 617
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Exhibition by Mike O'Connor and Mary Fahy

Exhibition by Mike O'Connor and Mary Fahy

12 June 2015 - 09 July 2015
14:26 - 14:27

Ennistymon Courthouse Gallery, Parliament Street, Ennistymon, Co Clare

‘The Middle of Nowhere / The Centre of the Universe’ An exhibition of new colour lino-cuts by Mike O’Connor [with some photographs and collages], in The Courthouse Gallery, Ennistymon. Official opening on 12th June at 8 pm. Exhibition runs from June 12th – July 9th

Feile Latino

Feile Latino

18 July 2015


Now in its fourth year, a weekend of events mixing Irish and South American Culture culminating in a showcase concert on Saturday night. In previous years we have had singers, dancers and musicians from Argentia, Spain and all over the world.