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`, "/")), "") 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-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-26", DATEDIFF(`media`.`mediaCreated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-26", DATEDIFF(`media`.`mediaUpdated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-26", DATEDIFF(`userLastUpdate`, "2019-06-26"), DATEDIFF("2019-06-26", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-26", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-26"), DATEDIFF("2019-06-26", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `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/590)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/240)*`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-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-26", "2018-06-26") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-25", "2019-06-26")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
What's on in Kirklees, West Yorkshire / Events / Upcoming / 1 to 15 of 214

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. (Note: 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 / Upcoming / 1 to 15 of 214

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

Chapterhouse Theatre in the Walled Garden: Secret Garden

Wed 26 Jun 2019

Chapterhouse Theatre in the Walled Garden: Secret Garden

Chapterhouse Theatre Company stage this classic children’s story in the walled gardens of our Elizabethan Hall. The gardens will be open from 6.30pm for viewing and picnics. Please bring your own seating but no tables.....Read more

Reflections on the Cosmic Web - Work in Progress by Jill Woods

Tue 25 Jun to Thu 04 Jul 2019 (1 week)

Reflections on the Cosmic Web - Work in Progress by Jill Woods

"As part of my MA, I’m exploring the idea of interconnectedness and the webs that exist within and around us at the nano-scale all the way up to the galactic. I’m also interested in how art experiences impact the health .....Read more

Monoprinting – Taster Session – June

Thu 27 Jun 2019

Monoprinting – Taster Session – June

Evening session Thursday 27th June 2019 6 – 9pm £30 This session will introduce you to the technique of monoprinting, a way of producing one-off prints by rolling ink onto a plastic plate surface. Ink can be adde.....Read more

Jyotsna Srikanth & The Bollywood Brass Band

Thu 27 Jun 2019

Jyotsna Srikanth & The Bollywood Brass Band

There are few more joyous, more thundering noises to be heard than the sound of the Bollywood Brass Band in full flight. As their name suggests, they take the hit songs from decades of Bollywood movies and give them a.....Read more

Yan Tan Tether - 'The Theory of Concentric Circles'

Thu 27 to Sat 29 Jun 2019 (3 days)

Yan Tan Tether - 'The Theory of Concentric Circles'

Yan Tan Tether is a series of public exhibitions and events exploring how we experience and interact with the various landscapes around us; from the historic to the geological, economic to the digital. Located in a di.....Read more

Choose To Refuse

Wed 12 to Sun 30 Jun 2019 (3 weeks)

Choose To Refuse

It's time for Huddersfield to become PLASTIC CLEVER! What will you choose to refuse. In community workshops held in the demo zone at Queensgate Market fairandfunky created a landscape of Huddersfield using recycled ma.....Read more

Writing: Making Your Mark Cleckheaton

Thu 20 Jun to Tue 09 Jul 2019 (3 weeks)

Writing: Making Your Mark Cleckheaton

Our Writing: Making Your Mark exhibition draws on the themes of a new British Library exhibition, which spans five millennia and five continents, to deconstruct the art of writing and consider its future in the digital a.....Read more

Quilting Together and The Laundry Pile exhibitions

Mon 24 Jun to Sat 13 Jul 2019 (3 weeks)

Quilting Together and The Laundry Pile exhibitions

Gallery 1: Nicola Parren in collaboration with the Meltham Quilting Bee ‘The Quilting Together: Studies of Communal Quilting exhibition presents a series of quilts and drawings that are the result of the work carried .....Read more

Ceramics for Beginners - Free course

Wed 05 to Wed 26 Jun 2019 (3 weeks)

Ceramics for Beginners - Free course

Join us at our sites across Kirklees throughout June to have a go at something new! Our FREE course is an introduction to the basics of ceramics. Starting Wednesday 5th June 1pm - 3pm, running for 4 weeks, at Oldro.....Read more

Jewellery Making - Free Course

Thu 13 Jun to Thu 04 Jul 2019 (3 weeks)

Jewellery Making - Free Course

Join us at our sites across Kirklees throughout June to have a go at something new! Our FREE course is an introduction to jewellery making. Starting Thursday 13th June 9:15am - 11:45am running for 4 weeks at Birkby.....Read more

Knit and Knatter - Free Course

Tue 04 Jun to Tue 02 Jul 2019 (1 month)

Knit and Knatter - Free Course

Join us at our sites across Kirklees throughout June to have a go at something new! Learn knitting skills along with a brew and lots of chat! All levels of experience welcome. Starting Tuesday 4th June 4:30pm - 6:3.....Read more

Ed Allen - Small Seeds, Huddersfield

Fri 28 Jun 2019

Ed Allen - Small Seeds, Huddersfield

'Friday Night Jive' presents Ed Allen 28th June 2019 - Small Seeds, Huddersfield Free entry This multi-instrumentalist and songwriter Ed Allen is a regular on the Leeds music scene performing with various pop and s.....Read more

The Human Figure / Art Exhibition

Sat 01 to Sun 30 Jun 2019 (1 month)

The Human Figure / Art Exhibition

This exhibition showcases the work of artists who are members of West Yorkshire Print Workshop and who use the Human Figure in their work. Each one approaches their medium and their subject in diverse ways. For some, t.....Read more

Mindful Drawing Workshops with Maggie O'Keefe

Sat 15 Jun to Sat 20 Jul 2019 (1 month)

Mindful Drawing Workshops with Maggie O'Keefe

Maggie O'Keefe returns with her popular Mindful Drawing monthly workshops. She will guide you in exploring some simple drawing practices designed to help us let go of the inner critic. You don’t need to know anything abo.....Read more

Silk Painting | Celebrating Age

Thu 27 Jun to Thu 18 Jul 2019 (3 weeks)

Silk Painting | Celebrating Age

Join members of Holme Valley Sharing Memories, for 4 creative sessions where we'll make a series of silk wall hangings. Experiment and play with different paint techniques each week, share life experiences and have fu.....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / … / 11 / … / 13 / … / 15 /