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-07-06' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-07-06' ) AND de.published =1 
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Willie Clancy Summer School, Miltown Malbay

Willie Clancy Summer School, Miltown Malbay

04 July 2015 - 12 July 2015

Miltown Malbay

Learn of the traditional culture, arts, language and literature that County Clare is renowned for during this weeklong exposition. The festival is held in memory of the famous local piper Willie Clancy.

Nicola Henley Specialist Studio 5 Day Course

Nicola Henley Specialist Studio 5 Day Course

08 July 2015 - 12 July 2015

Scarriff

Courses take place in Nicola's studio, part of a converted 18th century farmhouse, set in the idyllic rural landscape of County Clare, Ireland. A couple of hours drive from Dublin, and not far from Shannon airport, this is an area of great natural beauty, surrounded by mountains and lakes and just an hour from the Atlantic Coast and the unique Burren landscape. It is an area renowned for it's fishing, hill walking, inland water cruising and traditional music, offering a wide range of e...

Crusheen Singers Club July

Crusheen Singers Club July

08 July 2015
22:00 - 23:00

The Highway Bar, Crusheen, Clare

Crusheen Singers Club takes place every second Wednesday of the Month. Everyone welcome. A great night of singing and story telling guaranteed.

Loop Head Gathering

Loop Head Gathering

10 July 2015 - 19 July 2015

Kilbaha

Traditional Music Weekend with Family Events for all the family. Traditional Music and Dance each evening led by Emigrant Musicians from our area with a welcome for all musicians. Football Tournaments, Tug of War, Exhibition Hurling & Football Skills, Farming Tasks, Comedy events which vary each year from Sexiest Farmer Competition - Catch a Greasy Pig etc. Traditional music Mass.

Luan Parle plays Cultúrlann Sweeney Kilkee July 10th

Luan Parle plays Cultúrlann Sweeney Kilkee July 10th

10 July 2015
20:00 - 23:00

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

November 2014 saw Luan release ‘Day Is Done’ written with Tupelo’s James Cramer . The song topped the iTunes chart for a number of weeks and received rave reviews. The song is taken from her forthcoming EP ‘Roll The Dice’ produced by Gavin Glass, mixed by Ingmar Kiang. In 2013 ‘My Hero’ a song written with Luan during one of her songwriting workshops with a group of Transition Year School Girls was released. The song went on to top the itunes charts and reached no 7 in the Official Irish Charts...

Clare Says Céad Míle Fáilte