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 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Ennis Farmers Market

Ennis Farmers Market

02 January 2015 - 18 December 2015

Ennis

At a Farmers’ Market, farmers, growers or producers (usually from a defined local area) are present in person to sell their own produce direct to the public. Farmers’ Markets give local producers the opportunity to sell their goods directly to consumers.

Kilfenora Céilí Band

Kilfenora Céilí Band

03 January 2015
10:17 - 20:00

glór, Causeway Link, Ennis, Co Clare

A brand new album is on the way from the Kilfenora. After an obvious musical gear-change arising from the appointment of Kevin Crawford as producer of Chapter 8, their eagerly-awaited ninth collection, is about to hit the shelves.

Clare Says Céad Míle Fáilte
Blow off the cobwebs on Mullaghmore

Blow off the cobwebs on Mullaghmore

04 January 2015
13:30 - 17:00

Ballyvaughan

Blow off the Christmas cobwebs at Mullaghmore at 1.30pm on Sunday, 4th January 2015. Meet at Mullaghmore base on Crag Road. Everyone welcome. Walk free to members and €10 minimum donation for non-members. Note early start time. There will be an option for children as well. More information contact communications@burrenbeo.com or 091 638096.

The Poetry Collective

The Poetry Collective

09 January 2015
18:30 - 19:30

glór, Causeway Link, Ennis, Co Clare

The Poetry Collective (previously The Three Legged Stool Poets) are a collective of poets living and performing in Ireland’s Midwest based in and around Ennis. They have been writing, publishing, recording, filming and performing poetry for 15 years and have produced impressive first collections of poetry such as’ Spirit Store’ by Arthur Watson, ‘Image and Likeness’ by Brian Mooney, ‘Voices of Clare’ by a selection of Clare Poets, ’Reality the Graveyard of Dreams’ by Brendan O Byrne, ‘Parting’ b...

Clare Says Céad Míle Fáilte
Conal Gallen: A Bit on the Side

Conal Gallen: A Bit on the Side

09 January 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

Due to popular demand, Conal returns to glór with his side-splitting 2 Act comedy farce! Written by Conal and his son Rory, the action takes place in the household of Bridie and Willie Murphy, a couple who have fought the war of marriage for over 30 years. It is a love story unlike any other - wandering eyes, wandering feet, wandering hands.....It's all here!

Clare Says Céad Míle Fáilte