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-11-29' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-11-29' ) AND de.published =1  AND de.catid = 114 AND t.id = 635
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Ballyvaughan Farmer's Market Christmas Fayre

Ballyvaughan Farmer's Market Christmas Fayre

13 December 2014 - 14 December 2014
10:00 - 16:00

Ballyvaughan

Ballyvaughan Farmer's Market presents: Christmas Fayre 2014 on Saturday 13th & Sunday 14th of December, 10am – 4pm. The perfect time and place to pick up your locally grown Christmas vegetables & luxury, seasonal condiments! We also have locally produced honey & cheese, jams, fish, meats & treats and a host of local handmade crafts to finish off your gift shopping.

Ballyvaughan Farmer's Market Christmas Fayre

Ballyvaughan Farmer's Market Christmas Fayre

20 December 2014
10:00 - 16:00

Ballyvaughan

Ballyvaughan Farmers Market presents Christmas Fayre 2014 on Saturday 13th / 14th and Saturday 20th of December, 10am – 4pm. The perfect time and place to pick up your locally grown Christmas vegetables & luxury, seasonal cakes and preserves. We also have locally produced honey & cheese, jams, fish, meats & treats and a host of local handmade crafts to finish off your gift shopping. St John’s Hall, Ballyvaughan Village.

Ballyvaughan Farmer's Market

Ballyvaughan Farmer's Market

02 May 2015 - 31 October 2015
10:00 - 14:00 Every Saturday

Ballyvaughan

Established in 2004. 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.