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-04-01' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-04-01' ) AND de.published =1  AND d.id = 616
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Ennis Singers Club

Ennis Singers Club

17 October 2014 - 10 April 2015
21:00 - 23:00

Ennis

Ennis Singers Club holds its monthly session in the Grove Bar & Restaurant, Roslevan, Ennis commencing on 17th October at 9pm.

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.

Easter Egg Hunt in Ennis Cathedral

Easter Egg Hunt in Ennis Cathedral

06 April 2015
11:30 - 13:00

Ennis

There will be an Easter Egg Hunt on Easter Monday from 11.30am - 1pm in the grounds of the Cathedral Ennis. All are welcome to come and join in the fun and the Easter bunny may even make an appearance.

Consairtin, the National Concertina Convention

Consairtin, the National Concertina Convention

10 April 2015 - 12 April 2015

Ennis

Consairtín, the National Concertina Convention will take place in Ennis at various venues from the 10th, 11th and 12th April 2015. Consairtín 2015 is a celebration of the concertina in traditional Irish music.

Turas na mBan

Turas na mBan

25 April 2015
09:00 - 17:00

Ennis

Turas na mBan is a female only cycle sportive run by Clare Ladies Cycling Club. The concept of the event is to bring female cyclists together to Improve fitness form friendships and most of all have fun.