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&view=list") 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-26" AND "2019-11-10", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-18", DATEDIFF(`media`.`mediaCreated`, "2019-08-18"), DATEDIFF("2019-08-18", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-26" AND "2019-11-10", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-18", DATEDIFF(`media`.`mediaUpdated`, "2019-08-18"), DATEDIFF("2019-08-18", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-26" AND "2019-11-10", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-18", DATEDIFF(`userLastUpdate`, "2019-08-18"), DATEDIFF("2019-08-18", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-18", IF(`media`.`mediaDate`>"2019-08-18", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-18", IF(`media`.`mediaDate`>"2019-08-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-26" AND "2019-11-10", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-18", IF(`media`.`mediaDate`>"2019-08-18", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-18", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-18", IF(`media`.`mediaDate`>"2019-08-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-18"), DATEDIFF("2019-08-18", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-18", IF(`media`.`mediaDate`>"2019-08-18", `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-18" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-18", IF(`media`.`mediaDate`>"2019-08-18", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-18", "2018-08-18") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-17", "2019-08-18")) 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 128

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 128

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

Vessel, Sophie Hulf

Fri 02 to Sun 25 Aug 2019 (3 weeks)

Vessel, Sophie Hulf

Sophie Hulf explores biology, psychology and how these elements interact in this collection of work that spans a year in residency at the Phoenix. We are all a body with a voice inside. It is the matter that connects us,.....Read more

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

Made of Memories - Textile showcase

Tue 06 to Sat 24 Aug 2019 (3 weeks)

Made of Memories - Textile showcase

'Made of Memories' is a series of large scale woven panels, artwork and frameless fragments. They are all hand dyed and made using traditional hand weaving techniques. The work is inspired by my everyday observations of .....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

Chroma City

Thu 08 Aug to Sun 15 Sep 2019 (1 month)

Chroma City

Paintings by Debbie Ayles Ceramics by Michele Connell Debbie Ayles presents a painterly exploration of the myriad patterns found in architectural landscapes. Her paintings include all the shadows, reflections, sunbur.....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

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

Changing Skies: Alexander James Gordon

Thu 25 Jul to Fri 30 Aug 2019 (1 month)

Changing Skies: Alexander James Gordon

Changing Skies - abstract landscape paintings 25th July - 30th August 2019 Open Monday - Friday 10am - 4pm Free entry Based in North London, Alexander creates paintings that depict abstract landscapes, using oils a.....Read more

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

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

Summer Holidays at Hertford Museum - Week 4: Seasons - Blossoms

Tue 20 to Thu 22 Aug 2019 (3 days)

Summer Holidays at Hertford Museum - Week 4: Seasons - Blossoms

Tues 20th August – Thurs 22rd 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 the Japanese seaso.....Read more

Coastal Currents

Sat 31 Aug to Sun 08 Sep 2019 (1 week)

Coastal Currents

Ian O'Halloran Open Studio An exhibition of work exploring the mystery of the landscape & natural world represented through the medium of printmaking. Artists:- Ian O'Halloran and Charlotte Matthews Opening times: .....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

Open Studios - Solo exhibition - Artistsmeet at Watersmeet

Mon 09 to Fri 27 Sep 2019 (3 weeks)

Open Studios - Solo exhibition - Artistsmeet at Watersmeet

Contemporary, abstract, Impressionistic paintings inspired by landscapes and nature. Open Studios - Solo exhibition - Artistsmeet at Watersmeet 9th to 27 September 2019 Open Monday to Friday 10am to 4pm or by appoi.....Read more

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