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(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")="", "", REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")) AS `desc`,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("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-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-24", DATEDIFF(`media`.`mediaCreated`, "2019-07-24"), DATEDIFF("2019-07-24", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-24", DATEDIFF(`media`.`mediaUpdated`, "2019-07-24"), DATEDIFF("2019-07-24", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-24", DATEDIFF(`userLastUpdate`, "2019-07-24"), DATEDIFF("2019-07-24", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-01" AND "2019-10-16", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-24", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-24"), DATEDIFF("2019-07-24", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `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-07-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-24", IF(`media`.`mediaDate`>"2019-07-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-24", "2018-07-24") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-23", "2019-07-24")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (6) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 50;
What's on in Kirklees, West Yorkshire / Events / Design / Upcoming / 1 to 18 of 18 https://www.creativekirklees.com/listings/events/?disc%5B0%5D=6&view=rss Find amazing arts and creative events with Creative Kirklees’s What’s On guide for Huddersfield, Holmfirth, Dewsbury, Batley and surrounding areas. Get dates in your diary now! Potters' Wheel Taster Sessions Sat, 06 Jul 2019 00:00:00 +0100 https://creativekirklees.com/the-clay-mill/potters-wheel-taster-sessions/ Taster sessions to try out the potters's wheel. If you've always wanted a go but not sure if you want to commit to a course then try our July tasters. We have a special offer of £15 for one hour per person. Keep your fav... ARTWEEK: EXHIBITION - KILN FORMED GLASS FOR INTERIORS Thu, 04 Jul 2019 00:00:00 +0100 https://creativekirklees.com/louise-watson-1/standedgetunnel-co-uk/ The exhibition features a selection of works influenced by colour, light and the repetition of pattern found within architecture, in combination with the process of manipulating glass in a kiln. Bold is Beautiful - June 2019 Mon, 10 Jun 2019 00:00:00 +0100 https://creativekirklees.com/create-space/bold-is-beautiful-june-2019/ A course focusing on colour mixing, colour combinations and the human shape. We will mainly work with acrylic paint to really see how colour and combinations of colour can bring a painting to life. Monday 10th June ... Oil Painting Continued - June 2019 Mon, 10 Jun 2019 00:00:00 +0100 https://creativekirklees.com/create-space/oil-painting-continued-june-2019/ This is a course for novices and advanced painters alike, who would like some guidance in using oil-paint. Monday 10th June 13:00 - 15:30 8 Week Course *Please be aware this course will be deliv... Colour Linocut - July 2019 Tue, 30 Jul 2019 00:00:00 +0100 https://creativekirklees.com/create-space/colour-linocut-july-2019/ Interested in trying lino printing for the first time? Of have you done it before but want to know how to print more than one layer in different colours? Come along and have a go, you’ll be surprised what you can make! ... Knitty Gritty Thu, 11 Jul 2019 00:00:00 +0100 https://creativekirklees.com/create-space/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... SCRAPtastic Summer Crafts Wed, 07 Aug 2019 00:00:00 +0100 https://creativekirklees.com/tolson-museum/scraptastic-summer-crafts/ Join fairandfunky for some summer crafts using recycled materials. 11am - 1pm & 2pm - 4pm £3.50 per child Fabric Lenny Sat, 10 Aug 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-libraries/lennyfabric/ Join artist Fabric Lenny in this fun hands-on family workshop where you'll combine photography and drawing techniques with cool graffiti inspired materials to make an original artwork and make your mark. Children mus... Needle Felt Art - August 2019 Mon, 12 Aug 2019 00:00:00 +0100 https://creativekirklees.com/create-space/needle-felt-art-august-2019/ Needle Felt Art An in-depth workshop exploring how to maintain colourful fibres to create a summer landscape. Monday 12th August 13:00 - 15:00 Day Workshop £20 ... Space Chase: Summer Reading Challenge Mon, 19 Aug 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-libraries/space-chase/ 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 ... T-shirt Braiding - August 2019 Wed, 21 Aug 2019 00:00:00 +0100 https://creativekirklees.com/create-space/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... Presentation of Research Wed, 19 Jun 2019 00:00:00 +0100 https://creativehertfordshire.com/uharts/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... Wish You Were Here - A History Wardrobe Presentation Sun, 08 Sep 2019 00:00:00 +0100 https://creativekirklees.com/bagshaw-museum/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... A Potted History of Britain Thu, 19 Sep 2019 00:00:00 +0100 https://creativekirklees.com/arts-society-huddersfield/lecture-at-7-30pm-by-julian-richards/ 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... Making Huddersfield Cloth Tue, 24 Sep 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-libraries/makinghuddersfieldcloth/ Join Local Studies staff member Lorna Brooks for an interesting and engaging talk about the making of Huddersfield Cloth Huddersfield Raspberry Jam Sat, 12 Oct 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-libraries/hudds-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... Gold in Japanese Art: Sacred and Profane Thu, 17 Oct 2019 00:00:00 +0100 https://creativekirklees.com/arts-society-huddersfield/lecture-by-dr-meri-arichi-at-7-30pm/ 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... Peasant Pastimes? The Art of Pieter Bruegel the Elder Thu, 21 Nov 2019 00:00:00 +0000 https://creativekirklees.com/arts-society-huddersfield/lecture-by-dr-sophie-oosterwijk-at-7-30pm/ 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...