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") 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`))) What's on in Kirklees, West Yorkshire / Events / Archive / 1 to 15 of 3602

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 / 1 to 15 of 3602

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

Groove & The Bathtub Pings at Small Seeds, Huddersfield

Fri 16 Aug 2019

Groove & The Bathtub Pings at Small Seeds, Huddersfield

'Friday Night Jive' presents Groove & The Bathtub Pings 16th of August - Small Seeds, Huddersfield Free entry (donations welcome) 7-piece funk/soul/Motown/80s/90s/all-round bangers band!..Read more

Suffragette Storymarch

Thu 15 Aug 2019

Suffragette Storymarch

Suffragette Storymarch Thu 15 Aug 2019, 2:30PM Wilton Park Batley - meet by the bowling green Join us on an empowering storywalk celebrating Votes for Women. Discover more about the people who risked so much to figh.....Read more

Huddersfield life drawing sessions

Thu 15 Aug 2019

Huddersfield life drawing sessions

Come along to the Huddersfield Life Drawing Sessions every Thursday Evenings 7pm - 9pm. £6.00 per 2hr session and they are held at The Corner, 5 Market Walk, Huddersfield, HD1 2QA Everyone is welcome, from those who .....Read more

Chinese Blossom Painting

Thu 15 Aug 2019

Chinese Blossom Painting

The second of these workshops is run by Diane who is a renowned artist and teacher with a passion for bringing art to all, (winner of the 2019 West Yorkshire ‘Illustrator of the Year’ award). Hosted by Diane and Kati.....Read more

Conversations in Sculpture artist's workshop led by Victoria Fer

Wed 14 Aug 2019

Conversations in Sculpture artist's workshop led by Victoria Fer

The aim of this workshop for young people is to expand the Conversation in Sculpture by looking, sharing and making. The conversation will begin with loosening up drawing exercises in the gallery as a way of understandin.....Read more

Wet Felt Making at Standedge Visitors Centre. 14th August 10-12

Wed 14 Aug 2019

Wet Felt Making at Standedge Visitors Centre. 14th August 10-12

Traditional Wet felt Making. At Standedge Visitors centre Marsden. 10-12noon £15 per person. Each participant will learn the art of Wet felt making and make a purse/ pencil case/ phone cover. The workshop will include.....Read more

Paper Making and Marbeling. At Standedge Visitors Centre 1.30-3.

Wed 14 Aug 2019

Paper Making and Marbeling. At Standedge Visitors Centre 1.30-3.

Paper making and Marbling. £15 per person. At Standedge Visitor Centre, Marsden. 1.30-3.30 pm During this Workshop Participants will learn and have a go at the Art of Paper Making from making their own Pulp to turning.....Read more

Summer Holiday Activity Days

Wed 31 Jul to Wed 14 Aug 2019 (2 weeks)

Summer Holiday Activity Days

Come along and try a range of activities and crafts linked to Huddersfield's transport and architecture. We will be making balloon powered cars, building bridges and crafting our own vehicles and more! Wednesdays 31 .....Read more

Brigantia Bootcamp: Sketching

Tue 13 Aug 2019

Brigantia Bootcamp: Sketching

If you’re itching to dust off your sketchbook or haven’t picked up a pencil since school, Steve Mcgarth’s Sketching brings together people of all abilities for a fun and creative workshop. Steve will help you with the ba.....Read more

Brigantia Bootcamp: Creative Writing

Tue 13 Aug 2019

Brigantia Bootcamp: Creative Writing

Ever wished you could have the confidence to put pen to paper or have a first draft of a novel hidden on your desktop? No matter what your writing experience, aims or confidence, experienced writer Rachel Laurence delive.....Read more

Pyrography Workshop: Key-ring / Fridge Magnet / Pendant

Tue 13 Aug 2019

Pyrography Workshop: Key-ring / Fridge Magnet / Pendant

Learn the ancient art of wood-burning in this hands-on introductory workshop. No previous experience or drawing skills required and all materials provided. The format is friendly and informal, starting with a discu.....Read more

Needle Felt Art - August 2019

Mon 12 Aug 2019

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 .....Read more

Huddersfield’s Classical Architecture

Sun 11 Aug 2019

Huddersfield’s Classical Architecture

In 1963 John Betjeman said of Huddersfield, ‘A sort of Athens on the steep slopes of the River Colne.' Had he had a drink too many or was there something about the town’s architecture that led to this remark? To disco.....Read more

Byram Arcade Craft Fair August

Sun 11 Aug 2019

Byram Arcade Craft Fair August

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

Go Compose: Everyday Everywhere is a Sound

Sat 10 to Sun 11 Aug 2019 (2 days)

Go Compose: Everyday Everywhere is a Sound

Do you want to learn DJing, computer based music production, audio electronics and sound composition? The department of Music and Drama at the University of Huddersfield, in partnership with Yorkshire Sound Women Net.....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / / 11 / / 21 / / 31 / / 41 / / 91 / / 141 / / 191 / / 241 /