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-22' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-05-22' ) AND de.published =1  AND t.id = 623
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Fleadh Cheoil an Chlair

Fleadh Cheoil an Chlair

19 June 2015 - 22 June 2015

Kilrush

Fleadh Cheoil an Chlair will take place in Clare from June 19th to 22nd. Competitions on Friday 19th for Set dancing. with the Music & singing competitions on Saturday 20th for U12s and U15s and on Sunday 21st for U18 and Adult.

Summer Craft Fair & Plant Sale

Summer Craft Fair & Plant Sale

05 July 2015
12:00 - 17:00

Vandeleur Walled Garden and Centre, Killimer Road, Kilrush, Co Clare

Celebrate Summer with us and join us for our Summer Art and Craft Fair and Plant sale at the Vandeleur Walled Garden. We offer 10% discount on all plants and the head gardener will be on hand to provide information and answer any questions.

Clare Says Céad Míle Fáilte
Kilrush Traditional Music and Set Dancing Festival

Kilrush Traditional Music and Set Dancing Festival

23 July 2015 - 26 July 2015

Kilrush

5 day festival of Music & set dancing. Open Air Ceili's in Kilrush Square on Friday, Saturday & Sunday. Music Sessions, Sean Nos & Set Dancing Workshops.Musical Boat trip to Scattery Island. Concertina Competition and Sean Nos Dancing competitions.

Kilmihil Festival of Fun

Kilmihil Festival of Fun

31 July 2015 - 03 August 2015

Kilrush

Ireland's only festival that is completely based on Fun and making people Smile. Four action packed days of events for fun loving people of all ages, the highlight being the National Pig Racing Finals. Put simply, it's all about the smiles!!!!

Rose of Clare Festival, Cooraclare

Rose of Clare Festival, Cooraclare

01 August 2015 - 07 August 2015

Kilrush

The Rose of Clare festival is now in existence since 1979. The Festival is designed to cater for all age groups and is a “Fun” week. While there are many social and sporting events through the week, the Highlight of the Festival is the selection of the “ Rose of Clare”. This is now a very prestigious event with contestants from within and outside the County. Sixteen contestants were interviewed on stage over two nights by Colm O Connor of the Cork Examiner. There is also a panel of judges who in...