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-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-20", DATEDIFF(`media`.`mediaCreated`, "2019-08-20"), DATEDIFF("2019-08-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-20", DATEDIFF(`media`.`mediaUpdated`, "2019-08-20"), DATEDIFF("2019-08-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-20", DATEDIFF(`userLastUpdate`, "2019-08-20"), DATEDIFF("2019-08-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-20"), DATEDIFF("2019-08-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `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`=3 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-20", "2018-08-20") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-19", "2019-08-20")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (14) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Hertfordshire / Events / Events / Performing Arts / Upcoming / 1 to 15 of 49

Events

Find out about arts, cultural and creative events across Hertfordshire.

To find events near you, select map view from the left hand menu and enter your postcode. Events are regularly featured in the newsletter and via our social media channels which reach thousands of local individuals and businesses.

To add an event, join our network and login to your Member profile, alternatively refer to our User Guides. .

Events / Performing Arts / Upcoming / 1 to 15 of 49

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

Summer Holiday Club

Tue 20 to Thu 22 Aug 2019 (3 days)

Summer Holiday Club

Children’s Summer Holiday Club! * Tuesday- Cheerleading & Sports * Wednesday- Performing Arts & Sports * Thursday- Mindfulness & Sports Plus our popular lunchtime Talent Show!!!! * 5-12 year olds * E.....Read more

Herts Tween Fest

Wed 21 Aug 2019

Herts Tween Fest

EVENT OVERVIEW DATE:21/08/2019 START TIME:11:00 END TIME:16:00 LOCATION: Hertford Town Centre..Read more

Just Soph

Tue 20 Aug 2019

Just Soph

Marsden Library Tue 20th August 2019 10.30 - 11.30 am A storytelling adventure based on Rudyard Kipling's 'The Just So Stories'. Have you ever wondered how the camel got his hump? Or how the elephant got his trun.....Read more

Writing: Making Your Mark - A Celebration day

Sat 24 Aug 2019

Writing: Making Your Mark - A Celebration day

Huddersfield Library & Art Gallery Sat 24th August 2019 10.00 am - 3.30 pm A day of free family activities to celebrate our Writing: Making Your Mark exhibition. 10.00 am -12.00 noon: Book making on a space theme w.....Read more

Hoot & Holler in concert at The Carlile Institute, Meltham

Sun 25 Aug 2019

Hoot & Holler in concert at The Carlile Institute, Meltham

Hoot and Holler is an appealing young American folk/roots and Americana duo that blends old time Appalachian traditions with fine contemporary songwriting and excellent musicianship on fiddle, guitar and banjo. Based.....Read more

A.L.I.C.E. in Wanderlust

Fri 30 to Sat 31 Aug 2019 (2 days)

A.L.I.C.E. in Wanderlust

We called the mission Wanderlust. No one could have predicted what would come next. Out in the darkness, in the vastness of space and time, what truths can be discovered, what fragments of data have been collected? What .....Read more

Trestle School of Drama | February Half Term Workshop

Thu 21 Feb to Mon 21 Oct 2019 (8 months)

Trestle School of Drama | February Half Term Workshop

Trestle’s Adventures in Wonderland 21st February 2019, 10am-3pm | For ages 7-16 (Optional early drop off from 9am) This February Half Term Trestle will be creating their very own version of ‘Alice in Wonderland’ in.....Read more

A Concert of Orchestral Classical Music

Sun 13 Oct 2019

A Concert of Orchestral Classical Music

Please see attached poster..Read more

Face Front Theatre | It's My Move

Tue 01 Oct 2019

Face Front Theatre | It's My Move

Face Front Inclusive Theater presents It's My Move which is a show about the transition from school to adult life for young people with mild to moderate Learning disabilities/difficulties and their parent/carers. It a.....Read more

Flight: Circlesongs and Improvisation

Tue 16 Jul to Tue 27 Aug 2019 (1 month)

Flight: Circlesongs and Improvisation

These sessions are inspired by the work Jess has been doing with international teachers Bobby McFerrin and Rhiannon. The sessions will be exploring lots of ways of approach collaborative music making with the voice. See .....Read more

Hot Flush - The Musical

Thu 03 Oct 2019

Hot Flush - The Musical

Don't miss the outrageous Hot Flush! The Musical starring Su Pollard, Helen Pearson, Melanie Gutteridge, Matt Slack and Ruth keeling. Meet Myra, Sylvia, Helen and Jessica in this hilarious naughty musical that’s the .....Read more

Jeremiah

Tue 03 Sep 2019

Jeremiah

From the critically-acclaimed rap storyteller Jack Dean comes a raucous new gig theatre show about England’s forgotten revolution. On 9 June 1817, Jeremiah Brandreth assembles a crew of protesters in a pub near Nottin.....Read more

Jeremiah

Wed 04 Sep 2019

Jeremiah

From the critically-acclaimed rap storyteller Jack Dean comes a raucous new gig theatre show about England’s forgotten revolution. On 9 June 1817, Jeremiah Brandreth assembles a crew of protesters in a pub near Nottin.....Read more

Music Lessons Start

Mon 02 to Mon 30 Sep 2019 (1 month)

Music Lessons Start

Music Lessons start back this week. Spaces available for new pupils and taster sessions available for all Brass, Woodwind, Guitar, Ukulele and Piano pupils. email us : HD9CommunityMusic@aol.com or vist our Twi.....Read more

Jeremiah

Thu 05 Sep 2019

Jeremiah

From the critically-acclaimed rap storyteller Jack Dean comes a raucous new gig theatre show about England’s forgotten revolution. On 9 June 1817, Jeremiah Brandreth assembles a crew of protesters in a pub near Nottin.....Read more

1 / 2 / 3 / 4 /