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`, "/")), "?network%5B0%5D=7&month=8") 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-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-16", DATEDIFF(`media`.`mediaCreated`, "2019-07-16"), DATEDIFF("2019-07-16", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-16", DATEDIFF(`media`.`mediaUpdated`, "2019-07-16"), DATEDIFF("2019-07-16", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-16", DATEDIFF(`userLastUpdate`, "2019-07-16"), DATEDIFF("2019-07-16", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-16", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-16"), DATEDIFF("2019-07-16", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `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/699)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/699)*`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 DATE_FORMAT(`media`.`mediaDate`, '%Y%m') = 201908 GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Hertfordshire / Events / Events / August 2019 / 1 to 15 of 25

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 / August 2019 / 1 to 15 of 25

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

1st / 2nd / 3rd / 4th / 5th / 6th / 7th / 8th / 9th / 10th / 11th / 12th

Build and code your own robot

Thu 01 Aug 2019

Build and code your own robot

Hertfordshire libraries are welcoming Prepare Robo’s coding experts for an exciting, new event. Working in pairs, your children can build their own amazing constructions; maybe a scout robot, or even a sumo warrior! .....Read more

Build and code your own robot

Wed 07 Aug 2019

Build and code your own robot

Hertfordshire libraries are welcoming Prepare Robo’s coding experts for an exciting, new event. Working in pairs, your children can build their own amazing constructions; maybe a scout robot, or even a sumo warrior! .....Read more

A Summer Retreat - The Art of Wellbeing

Sat 03 Aug 2019

A Summer Retreat - The Art of Wellbeing

The Art of Wellbeing 10.00am-3.00pm Come and enjoy a creative art making day based on the 5 steps to wellbeing. We all know that creativity helps us to maintain our well being, so come and explore how we can do th.....Read more

Build and code your own robot

Tue 06 Aug 2019

Build and code your own robot

Hertfordshire libraries are welcoming Prepare Robo’s coding experts for an exciting, new event. Working in pairs, your children can build their own amazing constructions; maybe a scout robot, or even a sumo warrior! .....Read more

Build and code your own robot

Tue 13 Aug 2019

Build and code your own robot

Hertfordshire libraries are welcoming Prepare Robo’s coding experts for an exciting, new event. Working in pairs, your children can build their own amazing constructions; maybe a scout robot, or even a sumo warrior! .....Read more

Build and code your own robot

Tue 13 Aug 2019

Build and code your own robot

Hertfordshire libraries are welcoming Prepare Robo’s coding experts for an exciting, new event. Working in pairs, your children can build their own amazing constructions; maybe a scout robot, or even a sumo warrior! .....Read more

Summer Holidays at Hertford Museum - Week 2: Robotic Futures

Tue 06 to Thu 08 Aug 2019 (3 days)

Summer Holidays at Hertford Museum - Week 2: Robotic Futures

Tues 6th August – Thurs 8th August, 10.30-3.30pm (last entry 3pm). Drop in and take part in quality arts & crafts inspired by the Japanese collections in our exciting new exhibition. Be inspired by Japanese technology .....Read more

Build and code your own robot

Wed 14 Aug 2019

Build and code your own robot

Hertfordshire libraries are welcoming Prepare Robo’s coding experts for an exciting, new event. Working in pairs, your children can build their own amazing constructions; maybe a scout robot, or even a sumo warrior! .....Read more

Robotic Futures: Autism Friendly Craft Activity for Families

Sat 10 Aug 2019

Robotic Futures: Autism Friendly Craft Activity for Families

Sat 10th August 2-4pm NEW Autism Friendly Session. Booking essential www.ticketsource.co.uk Be inspired by Japanese technology and learn about piperoid robot models. Create your own papercraft robot or build a pet ro.....Read more

The Big Bounce 2019

Tue 13 Aug 2019

The Big Bounce 2019

Join us for summer fun in our HUGE auditorium filled with softplay, bouncy castles, ball pits, giant balloons, music and lights! Recommended for Toddlers to 6 years old. £5 Kids per session £1.50 Adults per sessio.....Read more

Zee Sa Re Ga Ma Pa Live Concert

Sat 03 Aug 2019

Zee Sa Re Ga Ma Pa Live Concert

This Bollywood Musical show features artists from Sa Re Ga Ma Pa, an Indian musical reality TV show which has been running since 1995. The show has seen multiple variations over the years and used to follow a format w.....Read more

Summer Holidays at Hertford Museum - Week 3: Kites, Kimonos and

Tue 13 to Thu 15 Aug 2019 (3 days)

Summer Holidays at Hertford Museum - Week 3: Kites, Kimonos and

Tues 13th August – Thurs 15th August, 10.30-3.30pm (last entry 3pm). Drop in and take part in quality arts & crafts inspired by the Japanese collections in our exciting new exhibition. Make a wonderful Japanese carp wi.....Read more

Build and code your own robot

Tue 20 Aug 2019

Build and code your own robot

Hertfordshire libraries are welcoming Prepare Robo’s coding experts for an exciting, new event. Working in pairs, your children can build their own amazing constructions; maybe a scout robot, or even a sumo warrior! .....Read more

Fun in the Park- Potters Bar

Thu 22 Aug 2019

Fun in the Park- Potters Bar

This years Fun in the Parks is bringing you the BRAND NEW Bubble Party!! along with our classic inflatables and wonderful Magic Show. The perfect chance to get outside this Summer and let your little ones have a great d.....Read more

MARSWORTH FLOWER FESTIVAL AND OPEN PRINT STUDIO

Sat 24 to Mon 26 Aug 2019 (3 days)

MARSWORTH FLOWER FESTIVAL AND OPEN PRINT STUDIO

AUGUST 24 - 26TH 2019 This is the weekend that All Saints' Church, Marsworth celebrates its Flower Festival - this year the theme is 'Time for a Rhyme'. The church will be filled with over 25 stunning flower arrangem.....Read more

1 / 2 /