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`, "/")), "?postcode=&q=batley&network%5B0%5D=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-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-19", DATEDIFF(`media`.`mediaCreated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-19", DATEDIFF(`media`.`mediaUpdated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-19", DATEDIFF(`userLastUpdate`, "2019-07-19"), DATEDIFF("2019-07-19", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-19", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-19"), DATEDIFF("2019-07-19", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `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/515)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/223)*`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-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-19", "2018-07-19") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-18", "2019-07-19")) AND MATCH(`media`.`mediaTitle`, `media`.`mediaSeoName`, `media`.`mediaText`, `media`.`mediaLink`, `media`.`mediaAddress`, `media`.`mediaLocation`, `media`.`mediaPostcode`, `media`.`mediaTelephone`, `media`.`mediaEmail`) AGAINST ('+batley*' IN BOOLEAN MODE) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
What's on in Kirklees, West Yorkshire / Events / Upcoming / "batley" / 1 to 15 of 70

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 / "batley" / 1 to 15 of 70

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

Fabric Lenny

Sat 20 Jul 2019

Fabric Lenny

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

Spotlight

Sat 20 to Sun 21 Jul 2019 (2 days)

Spotlight

Stuart Stage School present their fifth highly acclaimed annual showcase at the Lawrence Batley Theatre. This show once again features some of the North’s most talented young people presenting musical theatre at its b.....Read more

Writing: Making Your Mark Batley

Thu 11 to Tue 30 Jul 2019 (3 weeks)

Writing: Making Your Mark Batley

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

Edinburgh Festival Fringe Previews

Thu 04 to Thu 25 Jul 2019 (3 weeks)

Edinburgh Festival Fringe Previews

Join us for a double helping of hilarity this July with two Edinburgh Festival Fringe Comedy Cellar specials! THURSDAY 4 JULY PAUL SINHA As seen on The Chase, Tonight at the Palladium, Just A Minute, Loose Ends and .....Read more

Sound Events @ the LBT / Jul 2019

Tue 23 Jul 2019

Sound Events @ the LBT / Jul 2019

Come and join Inclusive Sound Events for free improvised music - all instruments and abilities welcome. Sound Events is a regular (every month or so) improvisation night taking place in the Syngenta Cellar Bar at Lawr.....Read more

Summer Explorers Trail

Sat 20 Jul to Sun 01 Sep 2019 (1 month)

Summer Explorers Trail

Pick up your seasonal explorer pack from the Visitor Centre Shop to start your adventure. Add new activities to your pack each week that you visit both Oakwell and Bagshaw Museum. £4 per pack then £1 for additional e.....Read more

Summer Explorers Pack

Sat 20 Jul to Sun 01 Sep 2019 (1 month)

Summer Explorers Pack

Pick up your seasonal explorer pack from the shop to start your adventure. Add new activities to your pack each week that you visit both Bagshaw Museum and Oakwell hall. 20 July - 1 September (closed Monday & Fridays).....Read more

Around the World Trail

Sat 20 Jul to Sun 01 Sep 2019 (1 month)

Around the World Trail

Collect stamps for your trail passport as you search for the hidden objects in the museum from all six continents! This is a free event, no booking required and all ages are welcome! 20 July - 1 September (Closed Mon.....Read more

FlatSpin

Tue 23 to Sat 27 Jul 2019 (5 days)

FlatSpin

Dick & Lottie Written by Alan Ayckbourn To celebrate their 15th anniversary, Dick & Lottie present Ayckbourn’s classic Damsels in Distress trilogy. A night of romance in her luxurious riverside apartment with the .....Read more

RolePlay

Wed 24 to Sat 27 Jul 2019 (4 days)

RolePlay

Dick & Lottie Written by Alan Ayckbourn To celebrate their 15th anniversary, Dick & Lottie present Ayckbourn’s classic damsels in distress trilogy. Justin and Julie-Ann, hopelessly mismatched in love, are about to.....Read more

Free Summer Family Creations Workshops

Thu 25 to Tue 30 Jul 2019 (6 days)

Free Summer Family Creations Workshops

Joins us for free fun arts, crafts and play sessions for families on Thursday 25th July, or jewellery making sessions on Tuesday 30th July. Sessions take place at 10am - 12:30pm or 1pm - 3:30pm. Please call or emai.....Read more

GamePlan

Sat 27 Jul 2019

GamePlan

Dick & Lottie Written by Alan Ayckbourn To celebrate their 15th anniversary, Dick & Lottie present Ayckbourn’s classic damsels in distress trilogy. A teenager sets herself up as an online call girl to help with he.....Read more

Charanga del Norte

Sun 28 Jul 2019

Charanga del Norte

To celebrate their 20th anniversary Charanga del Norte return to the Lawrence Batley Theatre. Featuring an exciting line-up which includes the cream of the crop from the UK salsa scene: pianist Kim Burton (Sonido de L.....Read more

Mon 29 Jul 2019

Game Design in a Day: Ocean Spark

Ocean Spark Studios is a Video Game Development Studio based in Huddersfield. The team consists of passionate game developers who seek to inspire and enthuse younger generations by actively reaching out to offer support .....Read more

Chapterhouse Theatre in the Walled Garden: Wuthering Heights

Wed 31 Jul 2019

Chapterhouse Theatre in the Walled Garden: Wuthering Heights

Chapterhouse Theatre Company bring Emily Brontë’s classic novel to life in the walled gardens. The gardens will be open from 6.30pm for viewing and picnics. Please bring your own seating but no tables. Refreshments wi.....Read more

1 / 2 / 3 / 4 / 5 /