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-04' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-08-04' ) AND de.published =1  AND de.catid = 113
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Berry Picking Walk with Tony Kinnane

Berry Picking Walk with Tony Kinnane

08 August 2015

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

Berry Picking Walk with Tony Kinnane will take place at the 12 O' Clock Hills on Saturday 8th August.

Heritage Garden Day at Irish Seed Savers

Heritage Garden Day at Irish Seed Savers

23 August 2015
12:00 - 16:00

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

Heritage Garden Day on Sunday August 23rd from 12pm to 4pm Irish Seed Savers, Scariff. Join us for a relaxed day celebrating all that is good about Irelands Natural Food Heritage.

Tulla Annual Vintage Day

Tulla Annual Vintage Day

06 September 2015

Tulla

The Pat O Halloran Memorial Vintage Display will take place in Tulla on Sunday the 6th of September 2015. The venue will be O Halloran's field beside Tulla Secondary School. Anybody with vintage display is invited to come.

Culture Night iin Clare

Culture Night iin Clare

18 September 2015

Ennis

Friday, September 18th sees the annual Culture Night throughout Ireland and once again County Clare is to the forefront with over 25 free events happening throughout the county. The organisers of Culture Night, the Department of Arts, have kept last year's theme Explore – Experience – Enjoy due to it's phenomenal success. Music is very much to the fore this year and once again Ennis sees the largest array of Culture Night activities. The phenomenally successful Riches of Clare con...

Santa's Grotto and Christmas Craft Fair

Santa's Grotto and Christmas Craft Fair

05 December 2015 - 06 December 2015
11:00 - 16:00

Vandeleur Walled Garden and Centre, Killimer Road, Kilrush, Co Clare

Celebrate the festive season with us at the Vandeleur Walled Garden. Santa will be visiting on Saturday 5th and Sunday 6th December. Booking is required to meet with Santa. Our annual Christmas Craft Fair will provide the ideal opportunity to find handcrafted Christmas gifts. The coffee shop will sell home baked treats, which can also be ordered. Handcrafted logs, wreaths, centerpieces and garden accessories will also be available.

Clare Says Céad Míle Fáilte