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`=7 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-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-26", DATEDIFF(`media`.`mediaCreated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-26", DATEDIFF(`media`.`mediaUpdated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-26", DATEDIFF(`userLastUpdate`, "2019-06-26"), DATEDIFF("2019-06-26", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-26", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-26"), DATEDIFF("2019-06-26", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `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(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(51.803509))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.208628))+SIN(RADIANS(51.803509))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=7 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`.`mediaChecked`=0 OR `media`.`mediaApproved`=1) AND `userID`=`media`.`mediaUser` AND `networkID`=`userNetwork` AND `userPublish`=1 AND `userActive`=1 AND `mediatypes`.`mtID`=`media`.`mediaType` AND `weightingNetwork`=7 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-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-26", "2018-06-26") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-25", "2019-06-26")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (14) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Hertfordshire / News / News / Performing Arts / 1 to 15 of 26

News

The latest arts and creative news from members of the Creative Hertfordshire 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 in to My Account.

News / Performing Arts / 1 to 15 of 26

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

New Creatives

Wed 22 May 2019

New Creatives

New Creatives is an exciting talent development scheme that offers commissioning opportunities for emerging artists to create new work in film, audio or interactive media, designed for BBC platforms. Calling the Shots.....Read more

Plan a Fun Palaces event in 2019

Fri 26 Apr 2019

Plan a Fun Palaces event in 2019

Fun Palaces - a campaign celebrating community at the heart of Culture - will see a weekend of creative action (created by, for and with local people) return on 5-6 October 2019. Fun Palaces believes that everyone a.....Read more

Poetry at the Pudding Stop 6/3/19

Sat 23 Feb 2019

Poetry at the Pudding Stop 6/3/19

I'll be reading (along with several other Ver poets) at the Pudding Stop in St. Albans on Wednesday 6th March. Come along and eat pudding/listen to poetry!..Read more

Unrivaled acting classes available for teens in Hertfordshire as

Tue 22 Jan 2019

Unrivaled acting classes available for teens in Hertfordshire as

Master-Craft Theatre school courses, based at The Elstree UTC, aims to provide high quality professional actor training for young people aged 14 to 21. Our courses have been developed to prepare students for the challeng.....Read more

Opportunities to engage with local secondary schools

Thu 10 Jan 2019

Opportunities to engage with local secondary schools

Would you, or your business, like to work with a secondary school in Hertfordshire to enable its students to make better informed decisions about future career options? Why not join our team of over 80 Enterprise Adviser.....Read more

Creative & Commerce

Thu 11 Apr 2019

Creative & Commerce

So pleased I can now reveal I'm hosting my first ever networking event! Creative and Commerce is an opputunity for artistic businesses to mix and mingle and find out more about what's happening in the Doncaster Crea.....Read more

Summer Concert on Saturday 14th July

Mon 09 Jul 2018

Summer Concert on Saturday 14th July

Sizzling Summer Concert At St Paul's Church Hall, Preston, next Saturday 14th July at 7.30pm. Tickets - only £7 include light refreshments. An evening of musical delights and respite before the World Cup Final the.....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

Dance Artist Call Out | Reckless Sleepers 'Take a Seat'

Tue 02 Apr 2019

Dance Artist Call Out | Reckless Sleepers 'Take a Seat'

Call out for dance artist residency with Reckless Sleepers May/June 2019 A collaboration between Reckless Sleepers, Dance in Devon and you? We are head over heels with excitement that the incredible company Reckless.....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

1 / 2 /