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-01-31' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-01-31' ) AND de.published =1  AND de.catid = 110
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
12 O'Clock Hills Dawn Walk

12 O'Clock Hills Dawn Walk

31 January 2015
07:00 - 12:00

12 O' Clock Hills, Belvoir, Kilkishen, Co Clare

Join us for a Dawn Walk on the 12 O'Clock Hills and view the Sun Rising over the distant Comeragh Mountains. Following the walk is a Breakfast at Wiggy's.

Guided Walks in the ancient Raheen Oakwoods of Tuamgraney

Guided Walks in the ancient Raheen Oakwoods of Tuamgraney

01 March 2015 - 23 August 2015

Tuamgraney

Andrew St Ledger, the well known Clare based native woodland specialist will take people on a journey through the ancient Raheen oakwood, an extremely rare remnant of the ancient wildwood authentic landscape of Ireland. Andrew will explain how the Past, Present and Future are linked by our native trees, learn about the value and importance of the flora and fauna associated with such habitats for biodiversity, flood relief, climate change, etc. Find out how the ancestors valued their forests via ...

Traditional Horse Fair Kilrush

Traditional Horse Fair Kilrush

25 March 2015

Kilrush

The strong tradition of Trading and the reputation of Kilrush as being a key Market Town along the Shannon Estuary are still very much alive today with 4 Traditional Horse Fairs taking place in the town each year. Horse/ Pony traders position themselves about the Market Square while traders selling all kinds of goods from household items to plants line Frances Street.

Stephen Roche Atlantic Challenge

Stephen Roche Atlantic Challenge

28 March 2015
10:00 - 17:00

Lahinch

Stephen Roche Atlantic Challenge is an 80km Leisure cycle with the former World Champion and Tour de France winner, Stephen Roche. Nominated as one of the best cycles in Ireland, this event is for all cyclists. Starting on the beach promenade in Lahinch, the cycle takes in the Cliffs of Moher, the Burren and Corkscrew Hill.

Run Clare 2015 Eamon Moloney 10K

Run Clare 2015 Eamon Moloney 10K

28 March 2015

Ennis

County Clare's newest race series, 4 races, 4 months, 1 goal. Be sure to be a part of this exciting experience where you will progress from 5km to 5 miles to 10km to 10 miles.