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-03-31' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-31' ) AND de.published =1  AND de.catid = 107 AND t.id = 616
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Ennis Singers Club

Ennis Singers Club

17 October 2014 - 10 April 2015
21:00 - 23:00

Ennis

Ennis Singers Club holds its monthly session in the Grove Bar & Restaurant, Roslevan, Ennis commencing on 17th October at 9pm.

Consairtin, the National Concertina Convention

Consairtin, the National Concertina Convention

10 April 2015 - 12 April 2015

Ennis

Consairtín, the National Concertina Convention will take place in Ennis at various venues from the 10th, 11th and 12th April 2015. Consairtín 2015 is a celebration of the concertina in traditional Irish music.

A night with Frankie Lane and Paul Kelly

A night with Frankie Lane and Paul Kelly

18 April 2015
21:30 - 23:00

The Highway Bar, Crusheen, Clare

A night with Frankie Lane & Paul Kelly is a night of fun and wild entertainment. They are one of the best-known duos touring in Ireland at the moment. What sets Frankie and Paul apart from other duos is the sheer scope of their material. You’ll hear Irish Traditional tunes and songs, American Folk, Western Swing, Jazz, Classical, Bluegrass, and even a Gypsy number or two!

Join Me In The Pines

Join Me In The Pines

24 April 2015
20:00 - 22:30

glór, Causeway Link, Ennis, Co Clare

David Geraghty of Bell X1 It’s been an incredible first year for Join Me In The Pines who unleashed four beautiful videos for tracks ‘Joy Is A Lion, ‘Golden Guilt’, ‘Should Not Roam’ and lastly ‘At First Light’ from their debut album ‘INHERIT’ available to buy as a digital download, on CD and Vinyl. JMITP toured the length and breath of Ireland and are now delighted to announce a Theatre Tour which will kick off in February, 2015.

Clare Says Céad Míle Fáilte
Gospel Rising Music Festival

Gospel Rising Music Festival

08 May 2015 - 10 May 2015

Ennis

Energetic and inclusive event which calls on all music lovers who are interested in this growing genre of music in Ireland. There are gospel choirs popping up all around us, and this festival is the chance to get that inside look and feel on what happens when you are 'in the choir'. The festival consists of a series of workshops with big and small groups, these cover choir harmony singing in gospel styles, different solo singing styles and levels, choreography and big group singing. Th...