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-08-29' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-08-29' ) AND de.published =1  AND d.id = 618
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Carrigaholt Harvest Festival

Carrigaholt Harvest Festival

06 September 2015

Carrigaholt

Vintage and agricultural show celebrating al that is produced out west. All the fun of the fair, stalls, artisan market, competitions, livestock shows. Come and enjoy a day out with the people of Carrigaholt as they celebrate a year of rural life.

Seafood in September

Seafood in September

18 September 2015 - 20 September 2015

Carrigaholt

Special Guest: Paul Callaghan Tv Chef & author of Calso Cooks Get your taste buds excited for this fabulous food festival on the Wild Atlantic Way. Join a guided food trail or join in the messy fun at our Shellfish & Craft Beer Party but whatever you do definitely come hungry! This year TV Chef & Author Paul Callaghan is the special guest at the 2015 Seafood in September. Paul will be judging the annual cooking competition and doing a cooking demonstration on the Sunday of the fes...

Halloween Celebrations

Halloween Celebrations

31 October 2015

Carrigaholt

Bring your children to the biggest trick or treat in West Clare. Come and watch the spooky and haunting through drama and dance. Follow the Pucka through the streets of Carrigaholt as he searches to find the clues to solve riddle. Each of the local businesses have treats for the children. The evening finishes with the annual beating of the pinata to reveal its contents. Finally, put the chill of the night behind you in one of the local pubs where you are guaranteed a warm welcome.

Carrigaholt Christmas Market

Carrigaholt Christmas Market

06 December 2015

Carrigaholt

Come and join in the Christmas festivities at the village Christmas market. Upwards of 30 stallholders tempt you with artisan food and craft fayre. Take in local pubs and award winning restaurants. Relax in one of the local bed and breakfasts.