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-04' between date_format(date_start,'%Y-%m-%d') and date_format(date_end,'%Y-%m-%d') ||  de.date_end >='2015-07-04' ) AND de.published =1  AND de.catid = 109
 ORDER BY DATE_FORMAT(date_start, '%Y-%m-%d'), DATE_FORMAT(date_start, '%r')
Map View
Feile Brian Boru-Killaloe

Feile Brian Boru-Killaloe

01 July 2015 - 05 July 2015

Killaloe

Féile Brian Ború is an annual festival held in the picturesque twin town of Killaloe & Ballina. As it is the birthplace of Brain Ború, we like to commemorate Ireland’s Greatest High King in style! Experience a variety of excellent events including, Historical Guided Tours on lake and land; Street theatre; Live Music & Entertainment; A stunning Fireworks display over the River Shannon; Traditional Crafts; Street Party; Children’s Art; Art Exhibitions & Displays; Table Quiz; Farmer’s M...

Ennis Street Festival

Ennis Street Festival

03 July 2015 - 05 July 2015

Ennis

The Ennis Street Festival represents the Art and Culture of Ennis and Co. Clare, and offers our whole community and visitors a family-friendly safe opportunity to enjoy something different during the first week of July in Ennis Town. More than 200 people, between local artists, the local community groups and the festival team are working hard to make sure everyone has the opportunity to take part and enjoy this fantastic week.

4th July American Celebrations

4th July American Celebrations

03 July 2015 - 05 July 2015

Durty Nelly's, Bunratty, Co. Clare

International acclaimed Artists playing live in the Loft Bar, Durty Nelly's to celebrate the 4th of July.

Clare Says Céad Míle Fáilte
Festival of Music & Dancing during Willie Clancy Week at the Armada Hotel

Festival of Music & Dancing during Willie Clancy Week at the Armada Hotel

03 July 2015 - 12 July 2015

Armada Hotel, Spanish Point, Co Clare

The Armada in Spanish Point has announced details of its annual Festival of Music & Dancing during Willie Clancy Week from 3rd-12th July, 2015. The 10-day programme of set dancing sessions and country music dancing coincides with Willie Clancy Week in nearby Miltown Malbay, the hometown of the late Piper Willie Clancy. Michael English, The Abbey Ceili Band and Philomena Begley are among the acts lined up to take part in the 32nd annual event.

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.