SELECT,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.attributes,is_recuring,is_all_day, as town_id,t.title as town_title,c.title as cat_title, as cat_id,,c.image,d.latlang,de.web
 FROM cl_directory_events AS de
 LEFT JOIN cl_directory AS d on de.did
 LEFT JOIN cl_directory AS t on d.tid
 INNER JOIN cl_categories AS c on de.catid
 WHERE  ('2014-10-31' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-10-31' ) AND de.published =1  AND de.catid = 113
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Wild Atlantic Way burren 4 Ticket

Wild Atlantic Way burren 4 Ticket

01 January 2014 - 31 December 2014

Cliffs of Moher (Atlantic Edge Exhibition), Liscannor, Co Clare

Burren 4 ticket on the Wild Atlantic Way, Co Clare, Ireland. 1 ticket for 4 world class attractions.

Clare Says Céad Míle Fáilte
Martha Cashman

Martha Cashman

11 March 2014 - 05 April 2015
09:30 - 05:30

Gallery at the County Museum, Museum Foyer, Town Plaza, Ennis, Co Clare

Martha is a graduate of Crawford College of Art and Design in Cork and has exhibited extensively throughout Ireland. Her work explores the domestic and gardening utensil and its effect on the user; works are made from a mixed media of paper porcelain, woven wire, carved wood and painted drift wood.

Christmas at the Vandeleur Walled Garden, Kilrush

Christmas at the Vandeleur Walled Garden, Kilrush

13 December 2014 - 14 December 2014
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.

Clare Says Céad Míle Fáilte