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&page=11") 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-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-17", DATEDIFF(`media`.`mediaCreated`, "2019-08-17"), DATEDIFF("2019-08-17", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-17", DATEDIFF(`media`.`mediaUpdated`, "2019-08-17"), DATEDIFF("2019-08-17", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-17", DATEDIFF(`userLastUpdate`, "2019-08-17"), DATEDIFF("2019-08-17", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-17", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-17"), DATEDIFF("2019-08-17", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-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/344)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/178)*`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-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-17", "2018-08-17") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-16", "2019-08-17")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 150, 15;
What's on in Kirklees, West Yorkshire / Events / Upcoming / 151 to 165 of 232

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 / Upcoming / 151 to 165 of 232

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

Terror From The Skies

Sat 12 Oct 2019

Terror From The Skies

TERROR FROM THE SKIES by Matthew Bellwood An extraordinary story of everyday people. Terror From The Skies is a new play about community, friendship and the things that are important about where we live. Told with re.....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

Multi process : Combining Woodblock and Etching - October

Sat 12 to Sat 19 Oct 2019 (1 week)

Multi process : Combining Woodblock and Etching - October

3 day workshop Saturday 12th, Sunday 13th, Saturday 19th October 2019 10am – 4pm Indulge yourself in this 3 day workshop with experienced printmaker Jo Gorner, learning how to combine the techniques of etching and.....Read more

Byram Arcade Craft Fair - Oct

Sun 13 Oct 2019

Byram Arcade Craft Fair - Oct

The craft fair at the amazing Victorian Byram Arcade is back every second Sunday of the month 10am - 4pm. Good news if you don't have your own public liability insurance, I can now arrange stall cover for this event, .....Read more

The Rite of Spring & Left Unseen

Tue 15 Oct 2019

The Rite of Spring & Left Unseen

Phoenix Dance Theatre. Phoenix Dance Theatre present a culturally distinctive 21st century re-working of the iconic ballet, The Rite of Spring. For his first work created in the UK, Haitian contemporary and folklore c.....Read more

Count Arthur Strong: Is There Anybody Out There?

Wed 16 Oct 2019

Count Arthur Strong: Is There Anybody Out There?

As well as being the all-round entertainer we all know and love from the telly, Count Arthur Strong is also a lifelong fan of astronomy, since having been given a microscope, or whatever it is they use, for Christmas whe.....Read more

Dorian

Thu 17 Oct 2019

Dorian

Andrew McMillan and Proper Job Theatre Company. What if a portrait didn’t accurately reflect the life you’ve lived, but could be manipulated to show the life you wish you’d lived? What if your body was changing, but th.....Read more

October Comedy Cellar

Thu 17 Oct 2019

October Comedy Cellar

Join us for Huddersfield premiere comedy night. Acts this month: Danny McLoughlin As seen on Dave’s One Night Stand. Voted best MC in the UK in a poll of his fellow comedians. Theatre tour support for Sean Lock, Mic.....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

Organ Concert: Gordon Stewart with George King  - 21 October

Mon 21 Oct 2019

Organ Concert: Gordon Stewart with George King - 21 October

One of the country's finest improvisers and Kirklees Concert Season favourite, George King joins Gordon Stewart for Bach's Prelude and Fugue in G Minor, Franck's Prelude, Fugue and Variation and Philip Moore's Prelude, A.....Read more

Clare Teal and her Band

Thu 24 Oct 2019

Clare Teal and her Band

As the hot bed of Teal creativity, award winning jazz vocalist and Radio 2 presenter Clare Teal’s concerts with her Trio are constantly evolving and renowned across the country for their fabulous arrangements intersperse.....Read more

Felting Workshop at The Peppercorn - Oct

Thu 24 Oct 2019

Felting Workshop at The Peppercorn - Oct

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

Stained Glass Workshops with Diane Mellor

Wed 23 Oct to Wed 20 Nov 2019 (1 month)

Stained Glass Workshops with Diane Mellor

This Autumn we welcome back our tutor Diane Mellor for 2 special workshops. Diane is an experienced stained glass artist and she will lead you through the basics of glass cutting, soldering and leading glass. You'll ha.....Read more

Memories of an Indian Childhood

Fri 25 Oct 2019

Memories of an Indian Childhood

Settle Stories. Be transported to Bombay… dusty, crowded and vibrant… Welcome to Sita’s world of large families, stubborn hairdos and romantic train journeys. Slowly the light-hearted stories about friendships and g.....Read more

Lower Cumberworth Community Rooms- Autumn Craft Fair 2019

Sat 26 Oct 2019

Lower Cumberworth Community Rooms- Autumn Craft Fair 2019

We have very recently booked our place and will be taking part in this event for the first time! It will be open to the public between 10.30am and 4pm...Read more

/ 1 / / 5 / / 7 / 8 / 9 / 10 / 11 / 12 / 13 / 14 / 15 / 16 /