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  ('2014-11-22' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-11-22' ) AND de.published =1  AND de.catid = 111
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Fiona Cartwright Cooks

Fiona Cartwright Cooks

07 October 2014 - 31 October 2015

Ennis

Morning & Afterwork Cookery Demonstrations at the Junction Community Centre, Cloughleigh, Ennis with Ballymaloe trained Fiona Cartwright. Class Times: Mondays 11am to 1pm & Wednesdays from 6.15pm to 8.15pm

Ballymorris Pottery Open Day

Ballymorris Pottery Open Day

30 November 2014
11:00 - 17:00

Ballymorris Pottery and Pottery School, Ballymorris, Cratloe, Co Clare

You are invited to attend a Open Day in Ballymorris Pottery, Cratloe, Co. Clare on Sunday 30th November from 11am to 5pm.

Clare Says Céad Míle Fáilte
Bealtaine Art & Craft Fair

Bealtaine Art & Craft Fair

03 May 2015
12:00 - 17:00

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

Join us for our Bealtaine Art & Craft Fair in the courtyard of the Vandeleur Walled Garden on Sunday, 3rd May 2015 from 12 pm to 5 pm. We also offer a discount of 20% on all plants. The head gardener will be on hand to provide information and answer any questions. Handcrafted garden accessories will also be available for sale and orders can be taken. Enjoy homemade food and a variety of cakes and sweet treats in the Coffee Shop. So come along and have a great day out!

Clare Says Céad Míle Fáilte