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-28' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-28' ) AND de.published =1  AND de.catid = 107
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Kincora Traditional Weekend

Kincora Traditional Weekend

17 April 2015 - 19 April 2015

Killaloe

Kincora Traditional Weekend will take place in the twin towns of Killaloe and Ballina on the banks of the river Shannon. Over the three days and nights we will offer a comprehensive program of concerts, workshops, traditional music and singing sessions in various venues in both towns. The weekend itself takes its name from the ‘Palace of Kincora’ which was formerly situated on the green in Killaloe and served as the home of High King of Ireland Brian Ború.

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
Choral and Instrumental Festival

Choral and Instrumental Festival

02 May 2015

Killaloe

This Choral event at St Flannan's Cathedral will be a most memorable one with children's choirs performing during the afternoon. Adult choirs will feature in the early evening and a Gala Concert will take place at 8.30pm

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...