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%5B0%5D=5&page=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-30" AND "2019-10-15", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-23", DATEDIFF(`media`.`mediaCreated`, "2019-07-23"), DATEDIFF("2019-07-23", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-30" AND "2019-10-15", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-23", DATEDIFF(`media`.`mediaUpdated`, "2019-07-23"), DATEDIFF("2019-07-23", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-30" AND "2019-10-15", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-23", DATEDIFF(`userLastUpdate`, "2019-07-23"), DATEDIFF("2019-07-23", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-30" AND "2019-10-15", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-23", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-23"), DATEDIFF("2019-07-23", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `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-07-23" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-23", IF(`media`.`mediaDate`>"2019-07-23", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-23", "2018-07-23") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-22", "2019-07-23")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (5) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Hertfordshire / Events / Events / Arts and Crafts / Upcoming / 1 to 15 of 134

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 / Arts and Crafts / Upcoming / 1 to 15 of 134

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

Summer Art & Wellbeing Workshops

Sat 06 Jul to Tue 27 Aug 2019 (2 months)

Summer Art & Wellbeing Workshops

Free Art workshops every Tuesday of August at The Family Centre Turnford. For 11 - 19yr olds A Programme of workshops led by Artist Rosanna Mckenna and Wellbeing Coach Rachel Breskal. Our summer Art workshops.....Read more

DC & Marvel Superheroes Workshop

Thu 25 to Fri 26 Jul 2019 (2 days)

DC & Marvel Superheroes Workshop

I am so very excited to tell you that we can now take bookings for this amazing 2 day family course. Taking place on Thursday 25th & Friday 26th July 10am - 3pm, here at our base in South Oxhey, this exciting new course .....Read more

Homage

Fri 28 Jun to Sun 04 Aug 2019 (1 month)

Homage

This exhibition presents work by artists attending the painting and drawing sessions led by Roger Jeffs in the Project Space at Parndon Mill. This has been an ongoing project where the students have been encouraged to ex.....Read more

CALL FOR ARTISTS - Home

Sun 21 Jul to Sat 31 Aug 2019 (1 month)

CALL FOR ARTISTS - Home

We invite artists in all creative media to submit work for our forthcoming exhibition celebrating the theme of ‘home.’ We welcome wall-hung paintings, drawing, prints, mixed media, textiles, plus 3D work including wood, .....Read more

Zen Garden at Dartington Hall

Wed 03 Jul to Fri 06 Sep 2019 (2 months)

Zen Garden at Dartington Hall

The 2019 Bushey Photographic Competition is now open to visitors and I'm pleased to have my photo 'Zen Garden at Dartington Hall' Highly Commended by the judges. The Print is on display with a selection of over 50 pri.....Read more

Summer Art & Wellbeing Workshops

Wed 07 to Wed 28 Aug 2019 (3 weeks)

Summer Art & Wellbeing Workshops

Free Art workshops every Wednesday of August at Wormley and Turnford Big Local Hub For 11 - 19yr olds A Programme of workshops led by Artist Rosanna Mckenna and Wellbeing Coach Rachel Breskal. Our summer Art .....Read more

Summer Holidays at Hertford Museum - Week 1: Seahore and Sushi

Tue 30 Jul to Thu 01 Aug 2019 (3 days)

Summer Holidays at Hertford Museum - Week 1: Seahore and Sushi

Tues 30th July - Thurs 1st 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. Paint wax resist waves and ripples.....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

Crochet Bunting

Sat 27 Jul 2019

Crochet Bunting

Get summer ready with this fun crocheted bunting, fit for any garden and any occasion! In this workshop you will learn how to make 2 different types of bunting using a combination treble and double crochet, how to inc.....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

Lewes Artwave: Venue 49 Jevington Open Studios

Sat 17 Aug to Sun 01 Sep 2019 (2 weeks)

Lewes Artwave: Venue 49 Jevington Open Studios

An exhibition featuring the work of the Artists:- Charlotte Matthews - Printmaker Ian O'Halloran - Printmaker Ian Seccombe - Printmaker and Photographer Work inspired by the landscape and the natural world.....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

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

Raku Pottery Day

Sun 28 Jul 2019

Raku Pottery Day

Come and enjoy experimenting with Raku - the ancient Japanese technique of glazing and firing. What is Raku? Raku is a pottery firing process developed in 16th Century Japan for the Japanese tea ceremony. The pieces.....Read more

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