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 = 117 AND d.id = 129
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
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
Neil Delamere,  The Fresh Prince of Delamere

Neil Delamere, The Fresh Prince of Delamere

17 January 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

The Fresh Prince of Delamere Described by The Scotsman as “a master”, Delamere is renowned for his on-stage banter and quick-witted, well-observed yarns and previous tours and international appearances – including the Melbourne International Comedy Festival, Edinburgh Fringe Festival and the Montreal Just For Laughs Festival – have been a sell-out. Expect The Fresh Prince of Delamere to deliver the same powerhouse performance from the star of RTÉ’s The Panel, 2nd Republic, BBC’s The Blame Game...

Clare Says Céad Míle Fáilte
PJ Gallagher

PJ Gallagher

13 February 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

With his new show 'Concussion' Star of Next Week’s News, Meet your Neighbours and Naked Camera, PJ Gallagher makes his highly anticipated return with a brand new show ‘Concussion’.

Clare Says Céad Míle Fáilte
Pat Shortt: Selfie

Pat Shortt: Selfie

16 May 2015
20:00 - 20:01

glór, Causeway Link, Ennis, Co Clare

The irrepressible Pat Shortt is back on a nationwide tour with stories and gimmicks that only Pat Shortt could come up with. His new show, Selfie, tells the tales of a singing undertaker Mossey Burke along with a host of new characters as he recounts his favourite funeral. A funeral that was nearly the death of him and changed his life forever!

Clare Says Céad Míle Fáilte