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  ('2015-07-07' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-07-07' ) AND de.published =1  AND t.id = 635
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Summer Workshops 2015 at Burren College of Art

Summer Workshops 2015 at Burren College of Art

10 August 2015 - 14 August 2015

Ballyvaughan

Our Summer 2015 Programme offers a varied selection of five-day courses in painting, drawing and photography. To our regular courses in Botanical, Abstract and Landscape Painting we have added a week of Oil Painting in Still Life and Portraiture, Life drawing and Painting with Nature.

Summer Workshops 2015 at Burren College of Art

Summer Workshops 2015 at Burren College of Art

17 August 2015 - 21 August 2015

Ballyvaughan

Our Summer 2015 Programme offers a varied selection of five-day courses in painting, drawing and photography. To our regular courses in Botanical, Abstract and Landscape Painting we have added a week of Oil Painting in Still Life and Portraiture, Life drawing and Painting with Nature.

Emerging Irish Artist Residency Award Exhibition

Emerging Irish Artist Residency Award Exhibition

01 September 2015 - 31 October 2015

Ballyvaughan

The exhibition will feature work of four Irish Artists selected for the Emerging Irish Artist Residency Award. The show is based on their time in the Burren and their shared experience during their residency at Burren College of Art.

Burren Peaks Walking Festival

Burren Peaks Walking Festival

11 September 2015 - 13 September 2015

Ballyvaughan

Burren Peaks Weekend of Walking Festival promises you a real taste of the Burren and offers guided hill and lowland walks varying in distance and grade catering for all walkers. Enjoy walking in this wonderfully rich unique limestone pavement with its Karst landscape, grykes, clints, paths, and green trail roads… the land of the fertile rock with its precious and delicate terrain.

Burren Winterage Weekend

Burren Winterage Weekend

23 October 2015 - 25 October 2015

Ballyvaughan

The Burren Winterage Weekend is carried out to celebrate the unique farming traditions of the Burren, but also to highlight, celebrate and support the broader significance of pastoral farming in shaping much of the Irish landscape