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  ('2016-02-11' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2016-02-11' ) AND de.published =1  AND de.catid = 113
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Valentines “Love Your Garden Week”

Valentines “Love Your Garden Week”

09 February 2016 - 13 February 2016
12:00 - 14:00

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

Come visit our Gardens & Orchards, enjoy a walk with all the family. Then afterwards warm up in our shop with a tea or coffee, while you choose your seeds for the new planting season.

The Holy Wells of Clare - An Illustrated Talk - X-PO Killinaboy

The Holy Wells of Clare - An Illustrated Talk - X-PO Killinaboy

25 February 2016
20:30 - 22:00

X-PO Kilnaboy, Kilnaboy, Co Clare

X-PO Killinaboy will host an illustrated talk by Michael Houlihan on Thursday the 25th of February at 8.30 pm. The talk is entitled "The Holy Wells of Clare”.

Seed Swop & Share

Seed Swop & Share

06 March 2016
10:30 - 16:00

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

Bring your saved seeds to swop or just come for a chat and a cup of tea and cake!

Doolin Heritage Weekend

Doolin Heritage Weekend

18 June 2016 - 19 June 2016

Doolin

A weekend of talks on the Archaelogy of the Burren, Built heritage and Conservation. Heritage walks and site visits, organised by Doolin Heritage.

North Clare Show

North Clare Show

23 July 2016

Corofin

The 67th North Clare Agricultural Show takes place on Saturday 23rd July 2016 in Corofin, Co Clare. Fun day out for all the family. Classes in horses, ponies, cattle, sheep, donkeys & poultry. Gun dog classes and dog show, home baking, flower arranging, hanging baskets & potted plants, fruit & vegetables, homemade jam, domestic arts & crafts including painting, carpentry, knitting, embroidery & crochet, photography, turf & tons of kid's classes. Cups & awards fro...