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-10-30' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2014-10-30' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Kids Midweek Swimming Lessons

Kids Midweek Swimming Lessons

09 September 2014 - 11 November 2014
16:00 - 16:45

Shannon Swimming & Leisure Centre, Bothar Linne, Tullyglass, Shannon, Co Clare

Midweek swimming lessons for kids

Clare Says Céad Míle Fáilte
Different Strokes Swimming Lessons

Different Strokes Swimming Lessons

09 September 2014 - 16 December 2014
17:00 - 17:45

Shannon Swimming & Leisure Centre, Bothar Linne, Tullyglass, Shannon, Co Clare

Different Strokes Lane Swimming for Kids

Clare Says Céad Míle Fáilte
Fiona Cartwright Cooks

Fiona Cartwright Cooks

07 October 2014 - 31 October 2015

Ennis

Morning & Afterwork Cookery Demonstrations at the Junction Community Centre, Cloughleigh, Ennis with Ballymaloe trained Fiona Cartwright. Class Times: Mondays 11am to 1pm & Wednesdays from 6.15pm to 8.15pm

Parent & Toddler Swimming Lessons

Parent & Toddler Swimming Lessons

08 October 2014 - 12 November 2014
10:15 - 10:45 Every Wednesday

Shannon Swimming & Leisure Centre, Bothar Linne, Tullyglass, Shannon, Co Clare

Water based quality fun time for parent and toddler

Clare Says Céad Míle Fáilte
X-PO Singers' Club

X-PO Singers' Club

13 October 2014 - 15 December 2014
20:30 - 23:30

X-PO Kilnaboy, Kilnaboy, Co Clare

Monday evenings 8.30pm will see the return of the X-PO Singers' Club: Folk, Poetry, Ballads, Stories Musicals, Pop all feature in a typical evening. Some bring guitars, some bring songbooks, some just bring themselves. All are welcome and anyone can join in or just sit and listen.