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 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
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.

Lahinch Brittany Autumn Festival

Lahinch Brittany Autumn Festival

24 July 2015

Lahinch

Autumn 2015, will be a launch of the inaugural Lahinch Brittany Autumn Festival. The main objective of this project will be to promote Breton music and more generally Breton culture throughout Ireland. The festival will turn around biggest names in Breton music such as Malo Carvou, Sylvain Barou or Ronan Blejan to name a few. There will be Fest-deiz and Fest-noz (Breton céilis) every day of the weekend, conferences on musical ideology and instrument of Breton music, Breton music sessions, dan...

North Clare Show

North Clare Show

25 July 2015

Corofin

The 66th North Clare Agricultural Show takes place on Sat 25th July 2015 in Corofin, Co Clare. Fun day out for all the family. Classes in horses, ponies, cattle, sheep, donkeys & poultry. Gun dog classes and dog show, home baking, flower arranging, hanging baskets & potted plants, fruit & vegetables, homemade jam, domestic arts & crafts including painting, carpentry, knitting, embroidery & crochet, photography, turf & tons of kid's classes. Cups & awards from Odl...

South East Clare Agricultural Show in Bridgetown

South East Clare Agricultural Show in Bridgetown

26 July 2015

Killaloe

The South East Clare Show at Bridgetown offers en enjoyable day out for families, children and patrons both in the leisure and competitive capacity. The Show will have something for everyone, including a comprehensive programme of children’s entertainment including bouncy castles, mobile pet farm, archery, ceramic making and many dog showing classes.

Local Art Exbhibition

Local Art Exbhibition

27 July 2015 - 22 August 2015

Sweeney Memorial Public Library, Kilkee, O'Connell Street, Killkee, Co Clare

An exhibition of work by adults and young people attending an art group, with Kilkee based Maureen Glynn

Clare Says Céad Míle Fáilte