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-05-29' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-05-29' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Feile an tSamhraidh (Burren Summer Festival)

Feile an tSamhraidh (Burren Summer Festival)

29 May 2015 - 01 June 2015

Ballyvaughan

Féile an tSamhraidh is a family oriented activity weekend of water sport, cycling, walking and Céili events featuring some of Irelands most popular music acts in a gala concert on Sat 30th May.

Burren Chocolate Festival

Burren Chocolate Festival

30 May 2015 - 01 June 2015

Hazel Mountain Chocolates, Oughtmama, Bellharbour, Co Clare

First of its kind a bean to bar chocolate festival in the heart of the Burren mountains. Set in the magical surrounds of Hazel Mountain Chocolate. Come meet chefs, chocolate makers, chocolatiers, coffee roasters, share food ideas and join the Bean to Bar chocolate revolution.

'Charolais'

'Charolais'

30 May 2015
20:00 - 22:30

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

A surreal comedy of love, longing and one woman's rivalry with a Charolais heifer.

Clare Says Céad Míle Fáilte
Chapel Lane Market in the Heart of Ennis

Chapel Lane Market in the Heart of Ennis

30 May 2015
10:00 - 17:00

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.

Ian’s Trust To the Moon & Back Cycle, Run, Walk

Ian’s Trust To the Moon & Back Cycle, Run, Walk

31 May 2015
08:30 - 15:00

Kilkee

The 3rd annual Moon & Back Charity Cycle/Run/Walk starting from the bandstand in Kilkee the route takes participants on a spectacular journey along the Wild Atlantic Way coastline.