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-18' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-04-18' ) AND de.published =1  AND de.catid = 112
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Easter Eggstravaganza

Easter Eggstravaganza

18 April 2014 - 20 April 2014

Moher Hill Open Farm, Cliffs of Moher Road, Liscannor, Co Clare

Easter at Moher Hill Farm is when the bunnies take centre stage. Take part in the Easter Egg Hunt and fun and games for all the family.

Clare Says Céad Míle Fáilte
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
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
Easter Celebrations at Bunratty Castle and Folk Park

Easter Celebrations at Bunratty Castle and Folk Park

21 April 2014

Bunratty Castle and Folk Park, Bunratty Castle and Folk Park, Co Clare

Easter Monday is an enjoyable day for all the family at Bunratty Castle & Folk Park. With activities such as bouncy castles, face painters, balloon making,jugglers, a stilt walker,a fire eater,unicycle, and a puppeteer, all on hand to create a magical atmosphere that families will enjoy.Meet some of your favourite cartoon characters. Enjoy face painting, balloon making, and see stilt walkers, jugglers, magic shows and much more.! And Normal Admission Rates Apply!

Clare Says Céad Míle Fáilte