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-02-04' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2012-02-04' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
The Clare County Bridal Exhibition 2012

The Clare County Bridal Exhibition 2012

12 February 2012
13:00 - 17:30

Armada Hotel, Spanish Point, Co Clare

The Armada Hotel will host the Clare County Bridal Exhibition on Sunday 12th February 2012 from 1pm to 5.30pm in the Atlantic Banqueting Suite.

BELLBRIDGE HOUSE HOTEL WEDDING SHOWCASE

BELLBRIDGE HOUSE HOTEL WEDDING SHOWCASE

12 February 2012

Bellbridge House Hotel, Spanish Point, Co Clare

A Special Event dedicated to Your Special Day!

Crusheen Singers' Session

Crusheen Singers' Session

15 February 2012
21:30 - 23:00

Ennis

Singers' sessions (also known as singers' clubs or singers' circles) are slow variants of the Irish traditional music session; however the dominant mode is not instrumental music so much as the human voice in song. Each session is unique, with its own rules and dynamics. Some charge a fee, others are free of charge. Some do not allow musical instruments at all. Others do, provided they do not overpower the songs. Some sessions insist only Irish traditional songs be sung. Others ar...

Singers Club - Special once-off event

Singers Club - Special once-off event

17 February 2012
21:00 - 23:59

Cois na Habhna (Comhaltas Ceoltoiri Eireann), Galway Road, Ennis, Co Clare

Friday 17th February @ 9pm, Paddy Quinns Bar, Market Street, Ennis. No cover charge but bucket collection at break. Proceeds to Pat "China" Barry Mayor of Clarecastle GAA Election Fund. All storytellers / singers welcome. MC. Kevin Keane.

Russell Memorial Weekend

Russell Memorial Weekend

24 February 2012 - 27 February 2012

Doolin

The Russell Memorial Weekend is a traditional festival held in Doolin on the the last full weekend in February each year. The festival began in 1995 as a remembrance ceremony to Micho Russell, the world-famous traditional musician, who died in 1994.