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  ('2012-05-23' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2012-05-23' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
IPMS Ireland Nationals-Scale Modelling Event

IPMS Ireland Nationals-Scale Modelling Event

15 September 2012 - 16 September 2012

Atlantic Airventure, Link Road, Shannon, Co Clare

Scale Modelling Event. The event is being held every year in different part of Ireland, organized by different branches of the International Plastic Modeller's Society Ireland and this year Limerick/Shannon branch is hosting and organising this event.

Mountshannon Traditional Music Festival

Mountshannon Traditional Music Festival

28 September 2012 - 30 October 2012

Mountshannon

Enjoy a weekend filled with trad music and good craic in Mountshannon in September.

Burren Peaks Walking Festival

Burren Peaks Walking Festival

28 September 2012 - 30 September 2012

Ballyvaughan

The Ballyvaughan Fanore Walking Club would like to invite you to the Burren Peaks Walking Festival. The festival weekend promises you a real taste of the Burren and offers guided hill and lowland walks varying in distance and grade catering for all walkers.

Traditional Harvest Day at Bunratty Folk Park

Traditional Harvest Day at Bunratty Folk Park

30 September 2012
12:00 - 17:00

Bunratty Castle and Folk Park, Bunratty Village, Co Clare

Harvest traditions from over 100 years ago will be brought to life at Bunratty Folk Park, when a traditional 19th century Harvest Day will be held from 2.00 pm – 5.00 pm on Sunday September 30th 2012.

East Clare Walking Festival

East Clare Walking Festival

05 October 2012 - 07 October 2012

Scarriff

Sign up to do the East Clare Walking Festival to sample the rugged beauty of East Clare and the peaceful waters of Lough Derg.