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-08-03' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-08-03' ) AND de.published =1  AND de.catid = 107
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Sunday Session in Gallagher’s, Kilkishen

Sunday Session in Gallagher’s, Kilkishen

04 January 2015 - 27 December 2015
19:00 - 22:00 Every Sunday

Sixmilebridge

Every Sunday at 7.00pm in Gallagher’s Bar, Kilkishen (bank holiday Mondays at 7.00 in lieu of Sunday)a Trad/Folk Session will take place. Traditional music session for all ages and levels.

Durty Nelly's Nightly Music Session

Durty Nelly's Nightly Music Session

01 March 2015 - 31 October 2015
21:30 - 23:30

Durty Nelly's, Bunratty, Co. Clare

Clare Says Céad Míle Fáilte
Riches Of Clare – Community Hall, Feakle

Riches Of Clare – Community Hall, Feakle

10 August 2015
13:00 - 14:00

Feakle

Riches Of Clare – Community Hall, Feakle (as part of Feakle Festival). A free lunchtime concert of traditional music with musicians Eileen O’Brien, Geraldine Cotter, Andrew McNamara and Mary McNamara will take place on Monday 10th August 1 – 2pm.

Crusheen Singers Club August

Crusheen Singers Club August

12 August 2015
22:00 - 23:00

The Highway Bar, Crusheen, Clare

Crusheen Singers Club takes place every second Wednesday of the Month. Everyone welcome. A great night of singing and story telling guaranteed.

Kate Purcell / Thrillogy at Kilshanny House

Kate Purcell / Thrillogy at Kilshanny House

14 August 2015
20:00 - 22:30

Kilshanny House, Kilshanny, Co Clare

Kilshanny House presents......An evening with Thrillogy: Kate Purcell, Yuki Nishioka & Denise Glass blend perfectly together to form a unique and exciting sound. During the evening your senses will be further indulged in our Burren Béilíní - perfect bite-size tastes of the Wild Atlantic Way!This will be a lovely event and is sure to sell out fast!