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-06' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-03-06' ) AND de.published =1  AND de.catid = 109
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
10 Books You Should Read with Joseph O’Connor and Evelyn O’Rourke

10 Books You Should Read with Joseph O’Connor and Evelyn O’Rourke

07 March 2015
11:30 - 13:00

glór, Causeway Link, Ennis, Co Clare

Come and listen to bestselling author Joseph O'Connor and journalist Evelyn O'Rourke give an insightful talk on the books you shouldn't miss out on!

Clare Says Céad Míle Fáilte
Literary Lunch: The Daughterhood

Literary Lunch: The Daughterhood

08 March 2015
13:15 - 15:00

glór, Causeway Link, Ennis, Co Clare

Natasha Fennell and Róisín Ingle share the funny, poignant and occasionally heart-breaking story of The Daughterhood.

Clare Says Céad Míle Fáilte
Sunday Symposium: Politics and Pathology – life inside the political tent

Sunday Symposium: Politics and Pathology – life inside the political tent

08 March 2015
10:00 - 12:00

glór, Causeway Link, Ennis, Co Clare

With former government minister and PD leader Des O'Malley, DCU’s Dr Gary Murphy, RTE's Katie Hannon and The Examiner's Mick Clifford. Chaired by Caimin Jones.

Clare Says Céad Míle Fáilte
St. Patrick's Day Parade Doonbeg

St. Patrick's Day Parade Doonbeg

15 March 2015
14:30 - 17:00

Doonbeg

The Doonbeg St. Patrick's Day Parade will take place on Sunday,the 15th of March in Doonbeg Village.

Killaloe/Ballina St. Patrick's Weekend

Killaloe/Ballina St. Patrick's Weekend

16 March 2015 - 17 March 2015

Killaloe

National and International visitors will join with the people of Killaloe Ballina in celebrating one of Ireland's greatest historical town lands, on this internationally recognised day of the Irish!