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-19' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-04-19' ) AND de.published =1  AND de.catid = 108
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Clare Seascapes

Clare Seascapes

31 March 2015 - 25 April 2015
20:00 - 23:30

Sweeney Memorial Public Library, Kilkee, O'Connell Street, Killkee, Co Clare

An exhibition of paintings of Clare seascapes by West Clare artist Cathal Butler.

Clare Says Céad Míle Fáilte
Clare Seascapes

Clare Seascapes

01 April 2015 - 25 April 2015

Clare Museum, Arthur's Row, Ennis, Co Clare

An exhibtion of paintings of Clare seascapes by West Clare artist Cathal Butler at County Museum.

Clare Says Céad Míle Fáilte
Exhibition by Michelle Kennedy

Exhibition by Michelle Kennedy

06 April 2015 - 02 May 2015

Sweeney Memorial Public Library, Kilkee, O'Connell Street, Killkee, Co Clare

Exhibition of work by Michelle Kennedy at Cultúrlann Sweeney Gallery, Kilkee.

Clare Says Céad Míle Fáilte
Skyscapes – Portraits of the Westerns Skies

Skyscapes – Portraits of the Westerns Skies

06 April 2015 - 01 May 2015

Sweeney Memorial Public Library, Kilkee, O'Connell Street, Killkee, Co Clare

Michelle Whelan will be exhibiting in Kilkee from the 6th April to the 1st May. Her paintings will be on view in the foyer of the library during normal working hours.

Clare Says Céad Míle Fáilte
MFA Exhibition

MFA Exhibition

18 April 2015 - 01 May 2015

Ballyvaughan

The exhibtion features work of the 2015 MFa graduates of the Burren College of Art.