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-12-22' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-12-22' ) AND de.published =1  AND de.catid = 109 AND t.id = 614
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Russell Memorial Weekend

Russell Memorial Weekend

26 February 2015 - 02 March 2015

Doolin

The Russell Memorial Weekend is a traditional festival held in Doolin on the the last full weekend in February each year. The festival began in 1995 as a remembrance ceremony to Micho Russell, the world-famous traditional musician, who died in 1994.

Doolin Folk Festival

Doolin Folk Festival

12 June 2015 - 14 June 2015

Doolin

Taking inspiration from the great festivals of the 70s and 80s – like Lisdoonvarna down the road, and from the deep musical roots of the County, Doolin 2015 will again present powerful music in an intimate setting and ensure that audiences and musicians can feel at one and just enjoy the communal spirit of such festivals. The Doolin Folk Festival has seen international acts such as Solas and Damien Dempsey play alongside mainstays of the Clare scene such as Siobhán Peoples, Murty Ryan & Pat ...

Doolin Craft Beer Festival

Doolin Craft Beer Festival

21 August 2015 - 23 August 2015
10:30 - 15:30

Doolin

The Doolin Irish Craft Beer Festival returns to Hotel Doolin for the 4th consecutive year on the 21st – 23rd August 2015. It features Irelands best craft beers from micro-breweries around the country, great Irish artisan food, and cracking live bands. This year however, we’ll have more beers, more food and more music. The event will showcase the best of Irish Craft Beers, featuring over 30 different beers from the best micro-breweries in Ireland including The Carlow Brewing Company, 8 Degrees ...