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-06' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-05-06' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Ennis Street Festival

Ennis Street Festival

03 July 2015 - 05 July 2015

Ennis

The Ennis Street Festival represents the Art and Culture of Ennis and Co. Clare, and offers our whole community and visitors a family-friendly safe opportunity to enjoy something different during the first week of July in Ennis Town. More than 200 people, between local artists, the local community groups and the festival team are working hard to make sure everyone has the opportunity to take part and enjoy this fantastic week.

Willie Clancy Summer School, Miltown Malbay

Willie Clancy Summer School, Miltown Malbay

04 July 2015 - 12 July 2015

Miltown Malbay

Learn of the traditional culture, arts, language and literature that County Clare is renowned for during this weeklong exposition. The festival is held in memory of the famous local piper Willie Clancy.

Carrigaholt Currach Racing

Carrigaholt Currach Racing

05 July 2015

Carrigaholt

Enjoy the competition of local currach crews battling out to become Carrigaholt champions. Take in local pubs and award winning restaurants. Relax in one of the local bed and breakfasts.

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
Nicola Henley Specialist Studio 5 Day Course

Nicola Henley Specialist Studio 5 Day Course

08 July 2015 - 12 July 2015

Scarriff

Courses take place in Nicola's studio, part of a converted 18th century farmhouse, set in the idyllic rural landscape of County Clare, Ireland. A couple of hours drive from Dublin, and not far from Shannon airport, this is an area of great natural beauty, surrounded by mountains and lakes and just an hour from the Atlantic Coast and the unique Burren landscape. It is an area renowned for it's fishing, hill walking, inland water cruising and traditional music, offering a wide range of e...