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-06' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2016-02-06' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Burren Cycling Club - An Post Tour De Burren

Burren Cycling Club - An Post Tour De Burren

18 June 2016

Ballyvaughan

The An Post Tour de Burren is a fantastic road cycling event which starts in Ballyvaughan and takes in many of the beautiful scenic locations around North Clare. There are four routes to choose from so you are gauranteed to find a route to suit you.

Beginners Bee keeping at Irish Seed Savers

Beginners Bee keeping at Irish Seed Savers

18 June 2016
10:00 - 16:30

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

New bee-keepers are essential in order to keep our bee population healthy. Topics covered will include how to get started, sourcing bees, the equipment needed and an overview of the bee keeping year. You will also learn about our native black bees, and their colony and what goes on inside it. We will discuss the importance of flowers and plants for the bees and there will be an Apiary practical session with the hives of bees.

Creating an Orchard at Irish Seed Savers

Creating an Orchard at Irish Seed Savers

18 June 2016
10:00 - 16:30

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

There is a renewed interest in the revival of the traditional Irish Orchard and most people have fond memories of orchards from their childhood. This course will cover choice of site, layout of orchard, choosing rootstocks, soil preparation, drainage, maintenance, health and disease, and choosing varieties. Soil health and improvement and pruning techniques will also be covered. Whether you are a farmer, a small-holder, or an apple enthusiast, this workshop will provide you with a perfect ground...

Wild Food Foraging at Irish Seed Savers

Wild Food Foraging at Irish Seed Savers

18 June 2016
10:00 - 16:30

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

People love these foraging courses. Join us for a day of exploring the hedgerows and discussing and identifying the edible and medicinal uses of the local wild plants and trees we find, along with some historical and folklore snippets. The day will include how to identify, harvest and process our finds into food, drink and remedies. Please bring notepad and pen, a clean empty jam jar, raingear and boots. Material cost: €7.

Medicinal Remedies at Irish Seed Savers

Medicinal Remedies at Irish Seed Savers

19 June 2016
10:00 - 16:30

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

A practical course in making medicinal remedies from common garden plants, for use in the home. Learn how to make creams, tinctures, teas, compresses and oils. This course includes a Herb-identifying and gathering walk as well as practical demonstrations of making herbal remedies. Materials cost: €10.00.