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-03-27' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-27' ) AND de.published =1  AND de.catid = 109 AND t.id = 616
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Polska Eire Festival 2015

Polska Eire Festival 2015

25 March 2015 - 28 March 2015

Ennis

Polska Eire Ennis is an integration festival taking place in Ennis from the 25th to 28th March. On Wednesday 25th March there will be a Culture Exchange in Cruises Bar, Abbey Street from 7pm- 9pm.

Clare Garden Festival

Clare Garden Festival

26 April 2015
11:00 - 17:00

Ennis

Clare Garden Festival will be held again on the last Sunday in April - 26th April 2015. The festival provides a day out for all the family with great food and entertainment available and is a treat for all gardeners. Clare Garden Festival will be led by celebrity speakers from the gardening world bringing exciting talks for ornamental and vegetable gardeners and it will feature a vast Garden & Food Fair of over 60 quality stalls from all over Ireland. The venue Ennis showgrounds featuring a...

Fleadh Nua Festival Ennis

Fleadh Nua Festival Ennis

17 May 2015 - 25 May 2015

Ennis

Fleadh Nua is a festival which celebrates Irish Traditional Music, Singing and Dancing at the end of May each year.

Pipers Union in concert, with Caitlín Nic Gabhann & Ciarán Ó Maonaigh

Pipers Union in concert, with Caitlín Nic Gabhann & Ciarán Ó Maonaigh

22 May 2015
20:00 - 22:00

glór, Causeway Link, Ennis, Co Clare

Pipers Union, comprising David Power, Ciarán Somers and their old friend Dónal Clancy, is a tight-knit trio, incorporating traditional and contemporary styles to deliver rousing ballads, soft love songs, lively dance tunes and haunting airs.

Clare Says Céad Míle Fáilte
Seán Ó Sé and the Turloughmore Céilí Band

Seán Ó Sé and the Turloughmore Céilí Band

23 May 2015
20:00 - 22:00

glór, Causeway Link, Ennis, Co Clare

Fleadh Nua will honour the legendary singer Seán Ó Sé on this special night. Seán, a native of Bantry, Co. Cork has an instantly recognisable voice and his performance of 'An Poc ar Buille' in the early 1960's established his reputation as a well known singer.

Clare Says Céad Míle Fáilte