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

Che do Bheata Festival

23 September 2016 - 25 September 2016

Kilkee

Celebrate Chez Gavara weekend with salsa and South American food and drink. Kilkee converts to the southern hemisphere for a weekend of fun and swing.

The Outing: LGTB Music & Matchmaking Festival

The Outing: LGTB Music & Matchmaking Festival

07 October 2016 - 09 October 2016

Lisdoonvarna

The Outing Lisdoonvarna LGBT Matchmaking & Music Festival will come to life with more entertainment, more clubs, more DJ’s, some comedy and more craic to be had by all! This LGBT music festival will take over the historic village of Lisdoonvarna.

'The Outing' World Record

'The Outing' World Record

08 October 2016

Lisdoonvarna

'The Outing' will gather the most lesbian, gay, bi and transgender GINGERS in the one place in an attempt to set a new world record. Special guests will be in attendance to help out!

Traditional Horse Fair Kilrush

Traditional Horse Fair Kilrush

10 October 2016
09:00 - 18:00

Kilrush

The strong tradition of Trading and the reputation of Kilrush as being a key Market Town along the Shannon Estuary are still very much alive today with 4 Traditional Horse Fairs taking place in the town each year. Horse/ Pony traders position themselves about the Market Square while traders selling all kinds of goods from household items to plants line Frances Street.

Bunratty Bluegrass Festival

Bunratty Bluegrass Festival

21 October 2016 - 23 October 2016

Bunratty

Bunratty Bluegrass Festival is a festival of Bluegrass music and more in 7 venues around Bunratty Village and Bunratty Folk Park showcasing artists from Ireland and abroad.