SELECT SQL_CALC_FOUND_ROWS SQL_NO_CACHE `mediatypes`.`mtID` AS `mediaTypeID`,IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) AS `name`,`media`.`mediaTitle` AS `title`,`users`.`userDisplayName` AS `displayname`,`mediatypes`.`mtCode` AS `media`,IF(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " "), "&", "&"), "\"", """), "\'", "'"), "<", "<"), ">", ">")="", "", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " "), "&", "&"), "\"", """), "\'", "'"), "<", "<"), ">", ">")) AS `text`,IF(`media`.`mediaFile`!="" AND `mediatypes`.`mtImage`+`mediatypes`.`mtVideo`!=0, CONCAT("media/", `networkAlias`, "/", `mediatypes`.`mtCode`, "/", IF(`mediatypes`.`mtVideo`=1, SUBSTRING(`media`.`mediaFile`, 1, LOCATE(".", `media`.`mediaFile`)-1), `media`.`mediaFile`)), (SELECT IF(`avatar`.`mediaFile`!="", CONCAT("media/", `networkAlias`, "/", `avatarmt`.`mtCode`, "/", `avatar`.`mediaFile`), "") FROM `media` AS `avatar`, `mediatypes` AS `avatarmt` WHERE `avatar`.`mediaUser`=`media`.`mediaUser` AND `avatar`.`mediaType`=`avatarmt`.`mtID` AND `avatarmt`.`mtCode`="profiles" LIMIT 1)) AS `image`,CONCAT("/", `users`.`userSeoName`, "/") AS `pubHref`,CONCAT("/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/")), "?disc%5B%5D=14") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=9 AND `users`.`userElevation`>=99 THEN "special" WHEN `mediatypes`.`mtCode` IS NULL OR `mediatypes`.`mtCode`="profiles" THEN `users`.`userType` ELSE `mediatypes`.`mtCode` END AS `class`,IF(`mediatypes`.`mtDate`=1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`=`media`.`mediaDate`, DATE_FORMAT(`media`.`mediaDate`, "%a %d %b %Y"), CONCAT(DATE_FORMAT(`media`.`mediaDate`, CASE WHEN DATE_FORMAT(`media`.`mediaDate`, "%Y%m")=DATE_FORMAT(`media`.`mediaDateEnd`, "%Y%m") THEN "%a %d" WHEN DATE_FORMAT(`media`.`mediaDate`, "%Y")=DATE_FORMAT(`media`.`mediaDateEnd`, "%Y") THEN "%a %d %b" ELSE "%a %d %b %Y" END), " to ", DATE_FORMAT(`media`.`mediaDateEnd`, "%a %d %b %Y"), " (", CASE WHEN DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1<7 THEN CONCAT(DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1, " days") WHEN DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1<=28 THEN CONCAT(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/7), IF(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/7)=1, " week", " weeks")) WHEN DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1<365 THEN CONCAT(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/30.417), IF(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/30.417)=1, " month", " months")) ELSE CONCAT(ROUND((DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1)/365), IF(DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`)+1<730, " year", " years")) END, ")")), "") AS `date`,`media`.`mediaDate` AS `rssdate`,DATE_FORMAT(`media`.`mediaDate`, "%Y-%m-%dT%TZ") AS `isodate`,IF(`mediatypes`.`mtCode`="profiles", CONCAT(UPPER(SUBSTRING(`userType`, 1, 1)), SUBSTRING(`userType`, 2)), `mediatypes`.`mtName`) AS `type`,((IF(`weightingCreated`>0 AND `media`.`mediaCreated`!="0000-00-00" AND `media`.`mediaCreated` BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-19", DATEDIFF(`media`.`mediaCreated`, "2019-08-19"), DATEDIFF("2019-08-19", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-19", DATEDIFF(`media`.`mediaUpdated`, "2019-08-19"), DATEDIFF("2019-08-19", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-19", DATEDIFF(`userLastUpdate`, "2019-08-19"), DATEDIFF("2019-08-19", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-19", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-19"), DATEDIFF("2019-08-19", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))))))))*`weightingDate`, 0))+(IF(`weightingDuration`>0 AND `mediatypes`.`mtDate`=1 AND `mediatypes`.`mtDateEnd`=1 AND IF(`mtFuture`=1, DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`), DATEDIFF(`media`.`mediaDate`, `media`.`mediaDateEnd`)) BETWEEN 0 AND 365, (100-((100/365)*IF(`mtFuture`=1, DATEDIFF(`media`.`mediaDateEnd`, `media`.`mediaDate`), DATEDIFF(`media`.`mediaDate`, `media`.`mediaDateEnd`))))*`weightingDuration`, 0))+(IF(`weightingProximity`>0 AND (3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=9 AND `userElevation`>0, (`userElevation`)*`weightingSpecial`, 0))+(IF(`weightingTotalitems`>0 AND `userTotalItems`>0, ((100/11)*IF(`userTotalItems`>11, 11, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/25351)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/2605)*`userProfileViews`)*`weightingProfileviews`, 0)))/(`weightingCreated`+`weightingUpdated`+`weightingProfileupdated`+`weightingDate`+`weightingDuration`+`weightingProximity`+`weightingSpecial`+`weightingTotalitems`+`weightingMediaviews`+`weightingProfileviews`) AS `relevance` FROM `media`, `users`, `mediatypes`, `networks`, `weightings`, `mediarefinements` WHERE `media`.`mediaActive`=1 AND `media`.`mediaEncoding`=0 AND `media`.`mediaApproved`=1 AND `userID`=`media`.`mediaUser` AND `networkID`=`userNetwork` AND `userPublish`=1 AND `userActive`=1 AND `mediatypes`.`mtID`=`media`.`mediaType` AND `weightingNetwork`=9 AND `weightingType`=`media`.`mediaType` AND `mediatypes`.`mtID`=2 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-19", "2018-08-19") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-18", "2019-08-19")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (14) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
News from Creative Kirklees / News / Performing Arts / 1 to 15 of 23

News

The latest arts and creative news from members of the Creative Kirklees directory.

News posted on the site is regularly featured in the newsletter and our social media, which reach thousands of local individuals and businesses.

To share your news, register and log into MyAccount.

News / Performing Arts / 1 to 15 of 23

Show All / Today / Aug / Jul / Jun / May / Apr / Mar / Feb / Jan / Dec / Nov / Oct / Sep / Archive

&Piano 2019 Event Dates Announced

Wed 14 Aug 2019

&Piano 2019 Event Dates Announced

After it's first successful year in 2018, &Piano returns for another season of fantastic music performed by fantastic musicians. &Piano begins again with a relaxed afternoon of Musical Theatre on Sunday September 8th .....Read more

Men's Talk 2 - Workshop dates

Wed 14 Aug 2019

Men's Talk 2 - Workshop dates

The Men's Talk 2 Workshop Programme begins next week with sessions at Lawrence Batley Theatre 1300-1600 on Tuesday 20th August and at Brigantia, Empire House, Dewsbury on Thursday 22nd August from 1300-1600. Men's Tal.....Read more

Men's Talk2

Mon 29 Jul 2019

Men's Talk2

Following a successful bid to Kirklees Council’s Community Plus “Do Something Now” fund, CLEAR is pleased to announce the launch of a new performance project for men who have experienced mental health issues: Men’s Talk .....Read more

We are Finalists and need your help !!

Wed 24 Jul 2019

We are Finalists and need your help !!

HD9 Community Music is on the shortlist to win a share of Persimmon Homes’ Building Futures £1million pot supporting under-18s nationwide but first they need online votes to win. Mrs Sarah Baker representing HD9 Commu.....Read more

Get Read for The HIDDEN VICTORIAN MUSLIMS

Thu 27 Jun 2019

Get Read for The HIDDEN VICTORIAN MUSLIMS

What's All This ... About These Victorian Muslims? My two new books are nearly ready! A historical biography PLUS a work of creative fiction about the Life and Times of my great x 3 grandfather - working class nort.....Read more

Ebb tide- a collection of three duets for clarinet and bassoon

Wed 19 Sep 2018

Ebb tide- a collection of three duets for clarinet and bassoon

Ebbtide is a collection of three duets for clarinet and bassoon which explores the symbolism of an ever-changing coastline as a metaphor for half-forgotten memories that are revealed only to recede again into the fathoml.....Read more

Performance and Micro Commission Opportunity

Thu 25 Oct 2018

Performance and Micro Commission Opportunity

Performance Opportunity Dance in Devon is delighted to invite Devon dance artists to apply to take part in our seventh edition of Watch This Space. Each year we are proud to showcase some of the best ‘home grown’ dance .....Read more

U.Dance SW Regional Platform

Thu 25 Oct 2018

U.Dance SW Regional Platform

Dance in Devon is excited to announce that we will be hosting the U.Dance 2019 Regional Platform for the South West at Dartington on Sunday 14th April 2019. Each year the U.Dance National Festival showcases a selectio.....Read more

Centre of excellence initiative to pilot in Yorkshire

Thu 04 Oct 2018

Centre of excellence initiative to pilot in Yorkshire

A ground-breaking initiative to establish a network of centres of excellence for film and television in the nations and regions will be piloted in Yorkshire. Creative Skillset, the skills body for the UK screen indust.....Read more

Cleckheaton Announces Artist Line-up

Tue 08 Jan 2019

Cleckheaton Announces Artist Line-up

Following our recent successful Advent Calendar Artist announcements we are pleased to list our artists on our website. The list includes Jon Boden & The Remnant Kings, London Philharmonic Skiffle Orchestra, Alden Patter.....Read more

Your chance to perform in stories of Hope Bank Pleasure Grounds

Mon 03 Sep 2018

Your chance to perform in stories of Hope Bank Pleasure Grounds

Would you like the opportunity to take part in a short performance as part of Honley Feast on Saturday 22nd September? Local arts organisations, Holme Valley Sharing Memories and Chol Theatre, are currently looking fo.....Read more

‘I love screaming on the mic’: On the road with hcmf// radio

Tue 19 Mar 2019

‘I love screaming on the mic’: On the road with hcmf// radio

It seemed like a hair-brained idea: taking a 45-year-old Classic Campervan called Betsy and turning it into a mobile radio, one that would tour Kirklees teaching students to DJ and host radio shows. But it was one our Le.....Read more

Dewsbury Lunchtime Concerts are back with Bite-Sized G&S

Sun 09 Sep 2018

Dewsbury Lunchtime Concerts are back with Bite-Sized G&S

Jeremy Peaker (Chorus of Opera North and formerly D’Oyly Carte) returns to Dewsbury Town Hall for the third year running to open the Lunchtime Chamber Concert Season with a delightful romp through the risqué wit of Gilbe.....Read more

Huddersfield premiere for Opera North's Armistice commemoration

Mon 05 Nov 2018

Huddersfield premiere for Opera North's Armistice commemoration

Opera North’s Orchestra, Youth Chorus, Young Voices and Children’s Chorus are preparing to join forces for the premiere of a specially commissioned work by leading composer Will Todd, in commemoration of the centenary of.....Read more

Three Women. One War. And a Ton of TNT

Mon 15 Oct 2018

Three Women. One War. And a Ton of TNT

Celebrate and commemorate the lives of Britain's unsung war heroes; The Canary Girls at The Beehive in Honiton on Friday 9 Nov 2018 at 7:30pm. Meet Agnes, Anne and Betty; a motley crew of munitions workers doing their.....Read more

1 / 2 /