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  ('2014-04-24' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-04-24' ) AND de.published =1  AND de.catid = 107 AND t.id = 622
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
The Big Pink Gig

The Big Pink Gig

24 April 2014
14:00 - 18:00

Killaloe

A night of music by local choirs, Killaloe Ballina Gospel Choir, The Gunas, Killaloe Ballina Youth Choir as well as choirs from other areas. Proceeds to Killaloe Pink Ribbon/Cancer Ireland.

Choral Celebration & Gala Concert

Choral Celebration & Gala Concert

03 May 2014
18:00 - 22:30

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

Tipperary Fleadh Cheoil

Tipperary Fleadh Cheoil

11 May 2014 - 18 May 2014

Killaloe

This vibrant celebration of traditional music and dance is not to be missed.

Killaloe Music Festival

Killaloe Music Festival

13 June 2014 - 15 June 2014

Killaloe

International Classical and Jazz musicians perform in Killaloe Ballina. Some free events. Please check website for further details