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`, "/")), "?network%5B0%5D=9&archive=1&page=9") 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-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-17", DATEDIFF(`media`.`mediaCreated`, "2019-07-17"), DATEDIFF("2019-07-17", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-17", DATEDIFF(`media`.`mediaUpdated`, "2019-07-17"), DATEDIFF("2019-07-17", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-17", DATEDIFF(`userLastUpdate`, "2019-07-17"), DATEDIFF("2019-07-17", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-17", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-17"), DATEDIFF("2019-07-17", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `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/0)*IF(`userTotalItems`>0, 0, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/528)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/227)*`userProfileViews`)*`weightingProfileviews`, 0)))/(`weightingCreated`+`weightingUpdated`+`weightingProfileupdated`+`weightingDate`+`weightingDuration`+`weightingProximity`+`weightingSpecial`+`weightingTotalitems`+`weightingMediaviews`+`weightingProfileviews`) AS `relevance` FROM `media`, `users`, `mediatypes`, `networks`, `weightings` 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 `userNetwork` IN (9) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) What's on in Kirklees, West Yorkshire / Events / Archive / 121 to 135 of 3518

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 / Archive / 121 to 135 of 3518

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

SEED by Pif Paf at Holmfirth Arts Festival 2019

Sat 15 Jun 2019

SEED by Pif Paf at Holmfirth Arts Festival 2019

SEED by PIF PAF Free street theatre performance. SEED is a fantastical exploration of our relationship with the long suffering plants that keep us fed, sheltered and breathing. The performance, built around int.....Read more

Circus Raj at Holmfirth Arts Festival 2019

Sat 15 Jun 2019

Circus Raj at Holmfirth Arts Festival 2019

Street circus performers by CIRCUS RAJ (India) Free street theatre performance Fresh from filming for Tim Burton in Disney’s live action remake of Dumbo, this cast of aerialists, acrobats, musicians, slack-rope wa.....Read more

A Touch of Brass at Holmfirth Arts Festival 2019

Sat 15 Jun 2019

A Touch of Brass at Holmfirth Arts Festival 2019

A Touch of Brass by Putney and Wimbledon Brass Band with Hade Edge Brass Band Brass music and the Yorkshire countryside is like a hand in a glove, and this Brass Band has come all the way from London to play their re.....Read more

Spectacular Showcase of Textile Innovation

Sat 15 Jun 2019

Spectacular Showcase of Textile Innovation

The Spectacular Showcase of Textile Innovation will shine a spotlight on the incredible scientific and creative innovation taking place in the textile industry today. Scientists, businesses and artists are continually ex.....Read more

Makers Market - Huddersfield

Sat 15 Jun 2019

Makers Market - Huddersfield

WOVEN Makers market will take place across two venues in Huddersfield on Saturday 15 June. Join selected makers in the beautiful settings of the Lawrence Batley Theatre Courtyard and Byram Arcade. Find out what amazin.....Read more

Wool Walk - Made in Huddersfield

Sat 15 Jun 2019

Wool Walk - Made in Huddersfield

A weird, wonderful and unbeWEAVEable scavenger hunt. Get your family or team of friends together to take on this woolly walk through Huddersfield! Pick up your trail map from the Spectacular Showcase at the University.....Read more

Ripping Yarns - Mirfield

Sat 15 Jun 2019

Ripping Yarns - Mirfield

Six short films by Alistair I MacDonald telling the stories behind some of our most innovative textile recycling businesses; turning old jeans into car interiors, creating yarn from nettles, and recycling 1000's of weddi.....Read more

How to be a Craftivist: Art of Gentle Protest by Sarah Corbett

Sat 15 Jun 2019

How to be a Craftivist: Art of Gentle Protest by Sarah Corbett

If we want our world to be more beautiful, kind and fair then shouldn't our activism be more beautiful, kind and fair? That's what Sarah Corbett believes and will be showing how she is doing activism differently that .....Read more

Woven in Kirklees Makers Market Byram Arcade

Fri 14 to Sat 15 Jun 2019 (2 days)

Woven in Kirklees Makers Market Byram Arcade

This is a great opportunity for all makers and artists using textile, yarn or felt living or working in Kirklees!! In June their is a week long textile Celebration, and Crafty Baggage is working with creative Kirklees.....Read more

Woven in Kirklees Makers Market LBT Courtyard

Fri 14 to Sat 15 Jun 2019 (2 days)

Woven in Kirklees Makers Market LBT Courtyard

This is a great opportunity for all makers and artists using textile, yarn or felt living or working in Kirklees!! In June their is a week long textile Celebration, and Crafty Baggage is working with creative Kirklees.....Read more

Figure Sculpture Masterclass

Wed 12 to Sat 15 Jun 2019 (4 days)

Figure Sculpture Masterclass

In this masterclass you will spend four days working from a live model to study the art of clay figure sculpture. At the end of the course you will have produced a half life-size sculpture from quality handbuilding clay .....Read more

Tons of Money

Tue 11 to Sat 15 Jun 2019 (5 days)

Tons of Money

Huddersfield Thespians Updated by Alan Ayckbourn from an original play by Will Evans & Arthur Valentine Aubrey is an unsuccessful inventor who inherits a fortune, which is to revert on his death to his cousin. As Co.....Read more

Tons of Money by Alan Ayckbourn

Tue 11 to Sat 15 Jun 2019 (5 days)

Tons of Money by Alan Ayckbourn

Tons of Money by Alan Ayckbourn at 7.15pm and 2.00pm Saturday matinee. Aubrey is an unsuccessful inventor who inherits a life interest in a fortune which is to revert on his death to his cousin. As Cousin George is thoug.....Read more

Market Showcase: WOVEN textile artists exhibition

Fri 07 to Sat 15 Jun 2019 (1 week)

Market Showcase: WOVEN textile artists exhibition

Textile artists were invited to take over an empty stall in Queensgate Market to showcase their work as part of WOVEN (a celebration of innovation in textiles across Kirklees). Call in to the market, near the Temporary .....Read more

Holmfirth Arts Festival 14-16 June 2019

Fri 14 to Sun 16 Jun 2019 (3 days)

Holmfirth Arts Festival 14-16 June 2019

Holmfirth Arts Festival 14 - 16 June 2019. This year's festival reflects 'Creativity in the Landscape' inspired by the stunning surroundings of the Holme Valley. Come and try something different from a sparkling progra.....Read more

/ 1 / / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11 / 12 / 13 / / 35 / / 235 /