SELECT,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.attributes,is_recuring,is_all_day, as town_id,t.title as town_title,c.title as cat_title, as cat_id,,c.image,d.latlang,de.web
 FROM cl_directory_events AS de
 LEFT JOIN cl_directory AS d on de.did
 LEFT JOIN cl_directory AS t on d.tid
 INNER JOIN cl_categories AS c on de.catid
 WHERE  ('2015-10-09' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-10-09' ) AND de.published =1  AND de.catid = 111
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Yoga Weekend Retreat at Burren Yoga Centre

Yoga Weekend Retreat at Burren Yoga Centre

04 April 2014 - 31 December 2015
Every Friday

Burren Yoga Retreats, Cappaghmore, The Burren, Co Clare

Award winning yoga weekends and week-long yoga holidays suitable for complete beginners to regular yoga practitioners. 90% of our visitors come on their own. Suitable for all ages and all levels of fitness. Winner of Tripadvisor Award of Excellence for 2012, 2013 and also 2014

Love Yourself- Heal Yourself Workshop

Love Yourself- Heal Yourself Workshop

10 October 2015 - 11 October 2015
09:30 - 17:00


Are you happy/unhappy or do you know how you are feeling? Why do you do what you do? Think & believe what you think & believe? Feel what you feel or maybe not feel at all? Why not treat yourself to 2 full days getting to know the true you in a safe, fun & loving space surrounded by like minded people. Find out what works well in your life & what you wish to change. Through guided meditation, song, group discussion & simple ex...

Philip Gray 1 Day Art Course

Philip Gray 1 Day Art Course

17 October 2015
10:00 - 16:00

Lahinch Art Gallery, at Kenny's Woollen Mill, Main Street, Lahinch, Co Clare

Philip Gray will be giving a one day Art Course in Lahinch Art Gallery on Saturday 17th October.