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  ('2013-05-21' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2013-05-21' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Fit Whit

Fit Whit

31 May 2013 - 03 June 2013

Sixmilebridge

A fun-filled multi discipline family/group oriented weekend long event. Laid back activities for all the couch potatoes to the more serious contests for advanced athletes.

Sixmilebridge 10k and 5k fun run/walk

Sixmilebridge 10k and 5k fun run/walk

31 May 2013
18:00 - 22:00

Sixmilebridge

Sixmilebridge 10k and 5 k ffun run/walk will take place on 31st May at 6pm. The run will be followed by a BBQ. All proceeds are in aid of the Bridge complex. All are welcome.

Doonbeg International Jazz Festival

Doonbeg International Jazz Festival

31 May 2013 - 03 June 2013

Doonbeg

This Festival of Swing, Dixie and Jazz is a hugely popular annual event, attracting many visitors to the Doonbeg/West Clare area to enjoy a weekend packed with music.

Feile an tSamhraidh (Burren Summer Festival)

Feile an tSamhraidh (Burren Summer Festival)

31 May 2013 - 03 June 2013

Ballyvaughan

Féile an tSamhraidh is a family oriented activity weekend of water sport, cycling, walking and Céili events featuring some of Irelands most popular music acts in a gala concert on Sat 1st June.

Kilmurry McMahon Marquee Festival

Kilmurry McMahon Marquee Festival

01 June 2013 - 03 June 2013

Kilrush

The Kilkennys will provide the music on Saturday night, while Crystal Swing will perform on Sunday. A Kiddies disco will round off the weekend on Monday afternoon.