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=6") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=9 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(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(53.644394))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-1.784605))+SIN(RADIANS(53.644394))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=9 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`.`mediaApproved`=1 AND `userID`=`media`.`mediaUser` AND `networkID`=`userNetwork` AND `userPublish`=1 AND `userActive`=1 AND `mediatypes`.`mtID`=`media`.`mediaType` AND `weightingNetwork`=9 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 (6) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
What's on in Kirklees, West Yorkshire / Events / Design / Upcoming / 1 to 13 of 13

What's On

Find out about arts, cultural and creative events in Kirklees, West Yorkshire - covering Huddersfield, Holmfirth, Dewsbury, Batley and surrounding areas. 

SIGN UP TO OUR NEWSLETTER
Keep up-to-date with the latest events
. (N
ote: event information is added by the organiser who is responsible for its accuracy).  For more information about places to visit and stay in the area go to Visit Kirklees.

To add arts or creative events, register, set up your creative profile and start adding your events

Events / Design / Upcoming / 1 to 13 of 13

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

Mon 19 Aug 2019

Space Chase: Summer Reading Challenge

Join this intergalactic Love Science workshop and launch an Apollo rocket, make an LED light up lunar module and create and take home a colour changing alien. Don't forget to look our for more Space Chase events and .....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

Making Your Mark: DIY journal making workshop

Sat 24 Aug 2019

Making Your Mark: DIY journal making workshop

Huddersfield Library & Art Gallery, Huddersfield Library, HD1 2SU Sat 24th August 2019. 1.15 - 3.30 pm Come along and make your very own journal from scratch. Use it for all your creative writing, ideas and sketches......Read more

Knitty Gritty

Thu 11 Jul to Thu 19 Dec 2019 (5 months)

Knitty Gritty

Knitty Gritty is a regular, knitting; crochet and sewing circle. This is a peer led group intended for those with previous experience, please be aware this is not a teaching group. Please bring with you your own equipmen.....Read more

Wish You Were Here - A History Wardrobe Presentation

Sun 08 to Mon 09 Sep 2019 (2 days)

Wish You Were Here - A History Wardrobe Presentation

Inspired by our seaside gallery, find out about a happy history of swimwear, from the bracing bathing of the 18th Century to knitted cozzies and kiss-me-quick hats. With fun stories and fabulous vintage costumes covering.....Read more

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

Tue 24 Sep 2019

Making Huddersfield Cloth

Join Local Studies staff member Lorna Brooks for an interesting and engaging talk about the making of Huddersfield Cloth..Read more

Presentation of Research

Wed 19 Jun to Sat 07 Sep 2019 (3 months)

Presentation of Research

Artist Stuart Whipps presents his research into a number of sites in Essex and Hertfordshire, with particular focus on New Town architecture and the lives that interplay around these sites. You will have an opportunity t.....Read more

Huddersfield Raspberry Jam

Sat 12 Oct 2019

Huddersfield Raspberry Jam

Meet like minded people and learn to code with Raspberry Pi and micro:bit Make games, animations, and websites in programmes like Scratch and Python. No coding experience necessary but you should be able to use a m.....Read more

Gold in Japanese Art: Sacred and Profane

Thu 17 Oct 2019

Gold in Japanese Art: Sacred and Profane

Lecture by Dr Meri Arichi at 7.30pm. (Doors open 7.00pm) The reputation of Japan as a country fabulously rich in silver and gold reached the west in the 14th century through the writings of the Venetian merchant and exp.....Read more

Upcycling - From Rags to Bags

Fri 27 Sep to Fri 25 Oct 2019 (1 month)

Upcycling - From Rags to Bags

Learn how to turn old or memorable clothes into a great looking sturdy bag - a perfect gift! You'll discover tips and tricks to give a new lease of life to old clothing and create beautiful gifts to share with others...Read more

Drawing and Painting

Wed 25 Sep to Wed 27 Nov 2019 (2 months)

Drawing and Painting

This exciting, intensive course is specifically designed for the learner with little or no previous experience, but with an interest to learn and develop drawing and painting skills. Develop observational drawing skills.....Read more

Peasant Pastimes? The Art of Pieter Bruegel the Elder

Thu 21 Nov 2019

Peasant Pastimes? The Art of Pieter Bruegel the Elder

Lecture by Sophie Oosterwijk at 7.30pm. (Doors open 7.00pm) The year 2019 marks 450 years since the death of Pieter Bruegel the Elder in 1569. This Flemish artist is probably best known for his colourful depictions of p.....Read more