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=7") 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 90, 15;
Creative Hertfordshire / Events / Events / Arts and Crafts / Upcoming / 91 to 105 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 / 91 to 105 of 128

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

A Potted History of Britain

Thu 19 Sep 2019

A Potted History of Britain

Lecture by Julian Richards at 7.30pm. (Doors open 7.00pm) Ceramics are part of everyday life, from the cups that we drink from to other, less obvious but equally useful vessels. But the products of modern industry are j.....Read more

Rudolph Rave

Sun 15 Dec 2019

Rudolph Rave

With a DJ, glow sticks, glitter and giant balloons, our family-friendly event brings everyone together for a fun-filled party afternoon, complete with a spectacular laser-light display. Santa & Rudolph will be there and .....Read more

Ecoprinting workshop - September 2019

Fri 13 Sep to Tue 13 Aug 2019 (-30 days)

Ecoprinting workshop - September 2019

Explore the process of eco-printing with natural dyes during this relaxed day time workshop (11 - 4pm) and create beautiful botanical imagery, textures and colour on paper using locally foraged leaves and natural dyes. .....Read more

Drawing for All

Wed 11 Sep to Tue 17 Dec 2019 (3 months)

Drawing for All

Claire Murray is an experienced art tutor and talented artists. She returns with her popular Drawing for All class on Wednesday mornings. Her class incorporates traditional drawing skills with experimentation. This is.....Read more

Duncan's Art Class at Multicraft Cabin Every Monday

Fri 11 Jan to Mon 16 Dec 2019 (11 months)

Duncan's Art Class at Multicraft Cabin Every Monday

DRAWING - PAINTING - COMPUTER ART If you have never drawn or painted before or you would like to improve your art technique do come along. All are welcome of any age. Each individual can pursue whatever subject or med.....Read more

Craftanoon with Zoe Gale

Thu 12 Sep to Wed 18 Dec 2019 (3 months)

Craftanoon with Zoe Gale

Craftanoon is our relaxed afternoon of crafting - it's a time to try out craft skills and create your own handmade uniques pieces. Each term, we cover a range of drawing and crafting skills such as weaving, paper cuttin.....Read more

Parties & Private Hire

Wed 26 Sep 2018 to Wed 01 Jan 2020 (1 year)

Parties & Private Hire

Enjoy exclusive use of our Studio space, along with an art or craft activity of your choice. Suitable for children, teens, adults and groups. We can offer parties from age 7 years and above - prices start from £120 f.....Read more

Carving workshop- carve wood or stone. Every Wednesday afternoon

Wed 23 Jan 2019 to Sat 31 Dec 2022 (4 years)

Carving workshop- carve wood or stone. Every Wednesday afternoon

Carving is a beautiful process. The textures, sounds and aroma of the materials will awaken your senses, accompanied by the rhythms of each student driving chisel with mallet. In this class you'll work using finest qu.....Read more

Wire and Mixed Media Sculpture

Sat 12 Oct 2019

Wire and Mixed Media Sculpture

Saturday October 12th 10am -4pm. £65 materials provided. A great opportunity to create a finished sculpture using wire, acrylic resin and mixed media. No previous experience is required and the day will be suitable for .....Read more

Intro to: Screen Printing onto Textiles - October

Sat 26 to Sun 27 Oct 2019 (2 days)

Intro to: Screen Printing onto Textiles - October

Print workshop - weekend course Spend a weekend learning how to screen print onto textiles in our fully equipped workshop and take home samples, t-shirts, and bags printed with your own designs! This fun, hands-on .....Read more

Acrylic Painting Workshop for Beginners

Sun 29 Sep 2019

Acrylic Painting Workshop for Beginners

Acrylic Painting Workshop for Beginners Subject matter - Sea horses - Sunday 29th September - 10.30am - 3.00pm Learn how to paint with acrylics, enhance or develop skills further. Friendly relaxing environment.....Read more

Life drawing workshop Worthing

Sat 04 Apr 2020

Life drawing workshop Worthing

This is a fun and friendly sketching workshop with a nude model. This course is suitable for all levels as individual support will be given to help you get the most out of the day. Come along and give it a go! Pleas.....Read more

Life Drawing Workshop in Worthing

Sat 01 Feb 2020

Life Drawing Workshop in Worthing

This is a fun and friendly sketching workshop with a nude model. This course is suitable for all levels as individual support will be given to help you get the most out of the day. Come along and give it a go! Please br.....Read more

Life Drawing in Worthing

Sat 04 Jul 2020

Life Drawing in Worthing

This is a fun and friendly sketching workshop with a nude models. This course is suitable for all levels as individual support will be given to help you get the most out of the day. Come along and give it a go! Pleas.....Read more

Life Drawing Workshop in Worthing

Sat 07 Dec 2019

Life Drawing Workshop in Worthing

This is a fun and friendly sketching workshop with a nude model. This course is suitable for all levels as individual support will be given to help you get the most out of the day. Come along and give it a go! Pleas.....Read more

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