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  ('2016-02-13' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2016-02-13' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Bealtaine Festival, County Clare

Bealtaine Festival, County Clare

01 May 2016 - 31 May 2016

Ennis

This year's Bealtaine Festival, which takes place throughout the month of May, sees a varied programme of events happening around the county. Celebrating creativity as we age - Bealtaine is now in it’s 20th year and provides an opportunity to showcase the talents and creativity of both first-time and professional older artists. From dance to cinema, painting to theatre, there is something for everyone to enjoy. Across the county, arts centres, libraries, care settings and community groups ...

17th Annual World Stone-Throwing Championship

17th Annual World Stone-Throwing Championship

01 May 2016

Corofin

17th Annual Series. Participants are challenged to break glass bottles placed on spikes. There is both a male and female cup and the competition is fierce. It attracts people from all over the globe as shown in the Hall of Fame. Cost of entry is €5 (for 5 stones). Over 18′s only. Legend has it that Fionn MacCumhail of the Fianna, who created the Giants Causeway is a past holder of the title. There are even suggestions that the Romans, having heard of the championship and terrified by t...

Ballyvaughan Farmer's Market

Ballyvaughan Farmer's Market

07 May 2016 - 29 October 2016
10:00 - 14:00 Every Saturday

Ballyvaughan

Having steadily grown over the seasons it is now recognised and enjoyed by locals and visitors as a premium food market offering a diverse range of quality foods. You are guaranteed a choice of seasonal, fresh, local food. These include salads, fruit & vegetables, cheese, fish, meat, honey, sweet & savoury preserves, juices, dairy produce, bread and cakes, seaweed products and local craft.

Burren Art and Craft Fair

Burren Art and Craft Fair

08 May 2016 - 30 October 2016
10:00 - 18:00 Every Sunday

Ballyvaughan

Burren Art & Craft is a collective of Craft workers, Photographers & Artists all based and working in the Burren region of North Clare, Ireland. Every Sunday from May – October a craft fair is held in Ballyvaughan Village Hall, Ballyvaughan, Co. Clare. This craft fair showcases the vibrant art and craft scene in the Burren region and features many different, unique, quality handcrafted products.

Féile Chnoc na Gaoithe

Féile Chnoc na Gaoithe

13 May 2016 - 15 May 2016

Tulla

A weekend of Traditional Irish music, song and dance with a particular emphasis on Fiddle music. The event includes workshops, competitions, a ceili each night and sessions in all the pubs.