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-06' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-06' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
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
Loophead Gathering Cross/Kilbaha

Loophead Gathering Cross/Kilbaha

10 July 2015 - 19 July 2015

Carrigaholt

Traditional Music Weekend with Family Events for all the family. Traditional Music and Dance each evening led by Emigrant Musicians from our area with a welcome for all musicians. Football Tournaments, Tug of War, Exhibition Hurling & Football Skills, Farming Tasks, Comedy events which vary each year from Sexiest Farmer Competition - Catch a Greasy Pig etc. Traditional music Mass.

Loophead Summer Hedge School

Loophead Summer Hedge School

13 July 2015 - 19 August 2015

Carrigaholt

The Loophead Summer Hedge School is a leisure learning Summer School offering modules in various aspects of Art & Nature. Modules include: Tea, Philosophy & Art (3 day module), Project Arts (3 day Module), Singular Art Days, Guided Hedgerow & Moorland Walks (3 hrs), Rocky Shore Explorations at low Spring Tide, & Herbal Workshops. An artist gallery and tea rooms are also situated at the facility. Contact Name: Carmel T. Madigan Phone Number: 086 8197726 or 065 6842884