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

Burren Sonas Kindergarten Quiz

Burren Sonas Kindergarten Quiz

22 November 2014
21:00 - 23:00

Kilfenora

The Kindergarten is hosting a fund raising pub quiz in Vaughan’s in Kilfenora on Saturday 22nd November at 9.00 p.m. Teams of four persons and five euros cost per person. Prizes for first and second teams as well as great raffle prizes and craic on the night. For more information 087 713 15 90.

Burrenbeo Trust Walk Fanore

Burrenbeo Trust Walk Fanore

23 November 2014

Ballyvaughan

Ballyvaughan Fanore walking club are walking Ballyryan Loop commencing at 11am. Meet at O'Donoghues, Fanore. Contact Kevin McCormack 086 3272472.

Burrenbeo Trust Walk Ballyvaughan

Burrenbeo Trust Walk Ballyvaughan

30 November 2014

Ballyvaughan

Ballyvaughan Fanore walking club was walking Poulnabrone - Ballyvaughan. Meet at The Burrenway map, The Pier, Ballyvaughan. Contact Mary Droney 087 6817925 - Bus required, contact Mary before November 27th to book.