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 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Delights of Lough Derg- Mini Bus Tour of Hidden Gems

Delights of Lough Derg- Mini Bus Tour of Hidden Gems

22 May 2015 - 25 September 2015
10:00 - 17:30 Every Friday

Killaloe

A personalised mini-bus tour of the hidden gems of Lough Derg which departs Flanagans every Friday at 10am for a tour of the Clare side of the Lough.

Riches of Clare 2015

Riches of Clare 2015

27 May 2015 - 29 July 2015
13:00 - 14:00 Every Wednesday

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

Flutes and fiddles everywhere, if it’s music you want you should go to Riches of Clare! The 2015 ‘Riches of Clare’ free lunchtime concert series featuring traditional music from Co. Clare and beyond takes place in the County Museum, Ennis.

Clare Says Céad Míle Fáilte
School Tours at Imecofarm

School Tours at Imecofarm

01 June 2015 - 30 June 2015

Imecofarm, Islandmcgrath, Clarecastle, Co Clare

The fun school tours at imecofarm are a huge hit with schools. We explore the farm and feed the friendly farm animals. We include a short pony ride for each child also the fun kids dune buggy spin through the forest. Plus indoor areas, zip wire and pedal carts for lots of fun.

Chapel Lane Market in the Heart of Ennis

Chapel Lane Market in the Heart of Ennis

06 June 2015 - 29 August 2015
10:00 - 17:00 Every Saturday

Ennis

An indoor market located in the community centre on Chapel Lane, just steps from Market Street. There are 20-25 stalls of high quality handmade arts&crafts, baked goods and more on display from all over the County.

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