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-19' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-04-19' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
New season of exhibitions at Russell Gallery

New season of exhibitions at Russell Gallery

19 April 2014
18:00 - 21:00

The Russell Gallery, New Quay, Co Clare

The Aillwee 3,000 Cadbury Creme Egg Hunt

The Aillwee 3,000 Cadbury Creme Egg Hunt

20 April 2014
13:00 - 18:00

Aillwee Cave, The Burren, Ballyvaughan, Co Clare

This year sees the revival of our great event "The Easter Egg Hunt". Lots of fun and games promised for all the family on the day. 3,000 Cadbury's creme eggs hidden with care around the grounds. Find the hidden Golden Egg.

Clare Says Céad Míle Fáilte
Our native woodlands as know by Brian Ború

Our native woodlands as know by Brian Ború

20 April 2014

Tuamgraney

A guided walk in woodlands near Tuamgraney, home to the magnificent "Brian Ború Oak" thought to have been a sapling when Brian Ború and his army camped in this area. Registration by text or email is essential.

Easter Fun & Games at Craggaunowen

Easter Fun & Games at Craggaunowen

20 April 2014

Craggaunowen- 'The Living Past Experience', Kilmurry, Near Sixmilebridge, Co Clare

Easter Sunday at Craggaunowen is great fun for the whole family. Our special guest, the Easter Bunny, always makes an appearance – delighting all the boys and girls with Easter eggs. Superb family day out! Meet Easter Bunny and enjoy puppet shows, magic shows, bouncy castle and delicious Easter eggs.

Clare Says Céad Míle Fáilte
Easter Egg Hunt with Art & Craft Fair and Plant Sale

Easter Egg Hunt with Art & Craft Fair and Plant Sale

20 April 2014
12:00 - 17:00

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

Join us for our Easter Egg Hunt this Easter Sunday. Treat yourself to our Art & Craft Fair and support local artists and craft workers in a relaxed atmosphere of our courtyard. Delicious treats are available in the Coffee Shop. Avail of 10% discount on all plants for sale

Clare Says Céad Míle Fáilte