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`, "/")), "") 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-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-27", DATEDIFF(`media`.`mediaCreated`, "2019-06-27"), DATEDIFF("2019-06-27", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-27", DATEDIFF(`media`.`mediaUpdated`, "2019-06-27"), DATEDIFF("2019-06-27", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-27", DATEDIFF(`userLastUpdate`, "2019-06-27"), DATEDIFF("2019-06-27", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-27", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-27"), DATEDIFF("2019-06-27", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `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/0)*IF(`userTotalItems`>0, 0, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/665)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/665)*`userProfileViews`)*`weightingProfileviews`, 0)))/(`weightingCreated`+`weightingUpdated`+`weightingProfileupdated`+`weightingDate`+`weightingDuration`+`weightingProximity`+`weightingSpecial`+`weightingTotalitems`+`weightingMediaviews`+`weightingProfileviews`) AS `relevance` FROM `media`, `users`, `mediatypes`, `networks`, `weightings` 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 `userNetwork` IN (7) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-27", "2018-06-27") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-26", "2019-06-27")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Hertfordshire / Events / Events / Upcoming / 1 to 15 of 141

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 / Upcoming / 1 to 15 of 141

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

Scam Awareness Roadshow WAR

Fri 28 Jun 2019

Scam Awareness Roadshow WAR

Scam Awareness Roadshows are taking place in libraries across Hertfordshire in June and July.  The Roadshows are an opportunity to learn more about doorstep, phone and postal criminal cons and cheats – how to avoid them,.....Read more

Hertford Choral Society 80th Anniversary Gala Concert

Sat 29 Jun 2019

Hertford Choral Society 80th Anniversary Gala Concert

A spectacular concert featuring steel band, accordions and choir in an end-of-season joyful celebration as Hertford Choral Society closes its 80th sanniversary. The evening commences with the ringing of a quarter peal.....Read more

Scam Awareness Roadshow ABB

Thu 27 Jun 2019

Scam Awareness Roadshow ABB

Scam Awareness Roadshows are taking place in libraries across Hertfordshire in June and July.  The Roadshows are an opportunity to learn more about doorstep, phone and postal criminal cons and cheats – how to avoid them,.....Read more

Lincoln Through the Lens

Thu 04 Jul 2019

Lincoln Through the Lens

Lincoln through the lens : a photographic journey through his life St Albans Library Thursday 4th July 7.15pm Tickets £5.00 available online, from the library or by phone 01707 281533 https://bit.ly/2ILE0qd..Read more

Scam Awareness Roadshow OAK

Tue 02 Jul 2019

Scam Awareness Roadshow OAK

Scam Awareness Roadshows are taking place in libraries across Hertfordshire in June and July.  The Roadshows are an opportunity to learn more about doorstep, phone and postal criminal cons and cheats – how to avoid them,.....Read more

Artists Open House Weekends

Sat 29 Jun to Sun 07 Jul 2019 (1 week)

Artists Open House Weekends

East Finchley Open Artists. Hertfordshire sculptor John Brown is a guest exhibitor at this event at 21 Beech Drive N2 9NX on 29/30 June and 6/7 July from 11am - 6pm. Other exhibitors are Adam E Justic-Mills, Visua.....Read more

Oceans 14 : exhibition at Artistsmeet

Tue 11 Jun to Mon 08 Jul 2019 (4 weeks)

Oceans 14 : exhibition at Artistsmeet

Oceans 14 11th June - 8th July 2019 Open Monday - Friday 10am - 4pm Free entry ‘Oceans 14’ is an exciting exhibition representing 14 of the schools who belong to the Three Rivers District Youth Council. Arnett H.....Read more

Carers & Dementia

Wed 03 Jul 2019

Carers & Dementia

Carers & Dementia Promoting wellbeing for the whole community Welwyn Garden City Library Wednesday 3rd July 10am to 2pm At 11am - Bean bags, balls & Rhythm : fun seated exercised set to music Confirmed attend.....Read more

Ver Open Poetry competition prizegiving and reading

Sat 06 Jul 2019

Ver Open Poetry competition prizegiving and reading

An afternoon of prizewinning poems and poets in the annual Ver Open. Distinguished American poet Kathryn Maris will introduce the winning and selected poems. She will then read form her recent work. A great intro to the .....Read more

The Art of Traditional Canalware / Painting on Pottery

Sun 30 Jun 2019

The Art of Traditional Canalware / Painting on Pottery

With over 25 years' of experience, Julia Power will teach you how to produce a beautifully painted object to be admired by all. There are so many ways the folk art of canal painting can enhance anything, either for us.....Read more

St Albans Folk Festival concert with Flook

Sat 29 Jun 2019

St Albans Folk Festival concert with Flook

St Albans Folk Festival concert at 8pm in the Roman Theatre at Verulamium, also forms part of Ovo Theatre’s open air Roman festival. The guests will be the iconic band Flook. After achieving national and international ac.....Read more

Gangsta Granny

Sat 06 Jul 2019

Gangsta Granny

Come and meet the original Gangsta Granny Actress Gilly Tompkins becomes Granny and reads from David Walliams bestselling book, followed by a craft session Saturday 6th July: St Albans 10.30am to 11.30am Ticket.....Read more

Gangsta Granny

Sat 06 Jul 2019

Gangsta Granny

Come and meet the original Gangsta Granny Actress Gilly Tompkins becomes Granny and reads from David Walliams bestselling book, followed by a craft session Saturday 6th July: Stevenage 1.30pm to 2.30pm Tickets .....Read more

Abraham Lincoln through the lens

Wed 03 Jul 2019

Abraham Lincoln through the lens

Kings Langley Community Library Abraham Lincoln through the lens: a photographic journey through his life Wednesday 3rd July at 7pm Speaker Andrew Houseman Tickets £6.00 (£5 conc) available from the library .....Read more

Lego Club for Children

Thu 04 Jul 2019

Lego Club for Children

Lego Club for Children Buntingford Library Thursday 4th July 4pm to 5pm £2 per session and suitable for children aged 5 to 12 (all children under 8 must be accompanied by an adult) #HertsLibraryLego..Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 /