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-07-06' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-07-06' ) AND de.published =1  AND de.catid = 108
 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

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
‘Compostela-Field of Stars’ Mixed Media works by Marianne Slevin

‘Compostela-Field of Stars’ Mixed Media works by Marianne Slevin

23 June 2015 - 11 July 2015
18:00 - 17:00

Scarriff Public Library, Mountshannon Road, Scarriff, Co Clare

The work feature improvisations and explorations of chance in ink and oil paint on various surfaces. They are mainly 2 dimensional drawings and paintings, but some found and everyday objects are turned into art objects with her use of ink.

Clare Says Céad Míle Fáilte
Exhibition of paintings by Senan O'Brien

Exhibition of paintings by Senan O'Brien

29 June 2015 - 25 July 2015

Sweeney Memorial Public Library, Kilkee, O'Connell Street, Killkee, Co Clare

A series of oil paintings and prints depicting scenes from Scattery Island.

Clare Says Céad Míle Fáilte
Summer Open Submission Exhibition

Summer Open Submission Exhibition

01 July 2015 - 31 August 2015

glór, Causeway Link, Ennis, Co Clare

glór is delighted to invite submissions from artists, both established and emerging, who are resident in, or from, Co. Clare. The deadline for entries is Thursday 2 April 2015.

Clare Says Céad Míle Fáilte