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-04-23' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-04-23' ) 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.

Life of Brian

Life of Brian

31 May 2014

Tuamgraney

A one day symposium on the life and times of Brian Boru. Speakers include Dr Lorna Moloney, Dr Paul McCotter, Terri Shoosmith and Ruth Minogue. Later that evening East Clare Heritage will be launching a special journal celebrating Brian Boru. All welcome, places limited.

Mid Summer Garden Party/Community Feast

Mid Summer Garden Party/Community Feast

21 June 2014
15:00 - 22:00

Scarriff

Celebrate the longest day of the year with your family, puppet show, food from the Garden, poetry, music, artisan food and craft market and more in Scariff’s favourite Garden. 3-10pm Free Event

Brian Boru Inauguration Re-Enactment

Brian Boru Inauguration Re-Enactment

21 June 2014

Tulla

On mid summer's day 2014 an open air re-enactment of the inauguration ceremony of Brian Boru on Magh Adhair in 1002 will follow a walk from wells associated with St Mochulla of Tulla.