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=3") 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 30, 15;
Creative Hertfordshire / Events / Events / Arts and Crafts / Upcoming / 31 to 45 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 / 31 to 45 of 128

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

Brigantia Bootcamp: Why Don't U

Wed 21 Aug 2019

Brigantia Bootcamp: Why Don't U

Our Why Don’t U? sessions are for anyone who wants to try something new in a trial and error environment. Aimed at anyone with an inquisitive mind, Why Don’t U? is led entirely by the group in what and how they want to l.....Read more

Free Family Workshop - Beach Bag Craft

Mon 19 Aug 2019

Free Family Workshop - Beach Bag Craft

Get arty and make your own beach bag out of an old t-shirt from home! Monday 19th August, 1pm - 3pm. Email us or give us a call to reserve your place. Up to 2 children per adult...Read more

Slow Stitch Sunday in the Byram Art & Design Studio

Sun 18 Aug 2019

Slow Stitch Sunday in the Byram Art & Design Studio

Take a couple of hours for yourself this Sunday mid-morning and join maker Nicola Twynham in exploring the experience of Slow Stitch. The process of hand embroidery and appliqued fabric offering a mindful and calming env.....Read more

Summer In Space

Fri 26 Jul to Mon 02 Sep 2019 (1 month)

Summer In Space

Event Date: Friday 26 July to Sunday 1 September from 10:00am - 4:30pm Young adventurers will be able to enjoy space themed activities throughout the summer at Lakeside Village. Located in the unit next to Thornton.....Read more

Creepy Crawly Crafting - Free Family Workshop

Mon 19 Aug 2019

Creepy Crawly Crafting - Free Family Workshop

Join us for marvellous mini beast crafts for curious young minds. Email us or call us to reserve your place. Up to 2 children per adult...Read more

Pottery Skills - Animal Plant Pot Workshop

Sun 15 Sep 2019

Pottery Skills - Animal Plant Pot Workshop

A new selection of one off pottery workshops designed to cover different skills whilst making something really nice for your home! Create a stylish animal plant pot. Choose a giraffe like ours, or maybe a zebra, eleph.....Read more

Sculpture Class in Hatfield

Thu 05 Sep to Thu 05 Dec 2019 (3 months)

Sculpture Class in Hatfield

SCULPTURE CLASS IN HATFIELD Wednesday 0900 - 1300 : drop in class , materials, tools, refreshments provided. Small friendly group, all levels welcome Thursday 0930 - 1200 - blocks of 12 classes, term time only, m.....Read more

Twinkle, Twinkle Little Star

Wed 21 Aug 2019

Twinkle, Twinkle Little Star

Summer drop in sessions at Cliffe House 10am -3pm. A chance to make star themed crafts in the beautiful grounds of Cliffe House. This is a drop in session so there’s no need to book and we’ll be using paint and glue so w.....Read more

Huddersfield Photo-Imaging Club Annual Exhibition 2019

Sat 29 Jun to Sat 31 Aug 2019 (2 months)

Huddersfield Photo-Imaging Club Annual Exhibition 2019

Huddersfield Photo-Imaging Club will showcase their members best work in print and digital image form at their Annual Exhibition in Huddersfield Art Gallery. Opening on 29th June 2019 and running to 31st August 2019 aro.....Read more

T-shirt Braiding - August 2019

Wed 21 Aug 2019

T-shirt Braiding - August 2019

T-shirt Braiding This workshop will teach you how to upcycle a T-shirt into a really versatile yarn then transform this into chunky statement jewellery. Learn a variety of braiding and professional finish.....Read more

35 Years of WYPW - Exhibition

Sat 06 Jul to Fri 06 Sep 2019 (2 months)

35 Years of WYPW - Exhibition

6th July – 6th September 2019 Celebrating 35 years of WYPW, we bring together an exhibition of prints, paintings, sculpture and photography by artists who have had a close connection with us over the years. Initial.....Read more

Indian Block Printing. At Standedge Visitors Centre Marsden

Mon 26 Aug 2019

Indian Block Printing. At Standedge Visitors Centre Marsden

Indian Block Printing. £15 per person 10-12noon. At Standedge Visitors Centre Marsden. Using a vast selection of beautifully hand carved Indian blocks, Participants will have the opportunity to print their very own To.....Read more

Cuddly Sock Creature Making Workshop. Standedge Visitors Centre

Mon 26 Aug 2019

Cuddly Sock Creature Making Workshop. Standedge Visitors Centre

Sock Creatures. 1.30-3.30pm £10 per person. At Standedge Visitors Centre Marsden. A Fantastic Creative workshop for all ages. Using the Humble Sock, during this workshop we will create super creatures and bring the.....Read more

Wizard Wands and Staffs

Tue 27 Aug 2019

Wizard Wands and Staffs

Summer drop in sessions at Cliffe House 10am-3pm. A chance to make wizard wands and staff as well as other magical crafts in the beautiful grounds of Cliffe House. This is a drop in session so there’s no need to book and.....Read more

FeltingWorkshop at the Peppercorn Aug

Thu 22 Aug 2019

FeltingWorkshop at the Peppercorn Aug

Come and enjoy felting at the lovely Vegan Peppercorn café which is open at 6.30pm prior to the workshop for food, cakes, and other goodies. Workshop 7 -9pm All felting supplies provided £15 per person. Needle Felte.....Read more

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