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-07' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2016-02-07' ) AND de.published =1  AND de.catid = 111
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
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.

Hedgerow Wine Making at Irish Seed Savers

Hedgerow Wine Making at Irish Seed Savers

19 June 2016
10:00 - 16:30

Irish Seed Savers Association, Capparoe, Scarriff, Co Clare

This is a hugely practical course for you to take full advantage of your hedgerows. The process of producing simple homemade wines is followed through from the picking of the ingredients to the bottling of the finished product. The course will include a walk in the gardens of Irish Seed savers to forage for fresh ingredients and discuss what flowers, fruits and vegetables are suitable for winemaking in their season. For this reason it is recommended to bring along boots and waterproofs.