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=dewsbury&network%5B%5D=9&resetpos=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`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-17", "2018-08-17") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-16", "2019-08-17")) AND MATCH(`media`.`mediaTitle`, `media`.`mediaSeoName`, `media`.`mediaText`, `media`.`mediaLink`, `media`.`mediaAddress`, `media`.`mediaLocation`, `media`.`mediaPostcode`, `media`.`mediaTelephone`, `media`.`mediaEmail`) AGAINST ('+(dewsbury* dewsburies*)' IN BOOLEAN MODE) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
What's on in Kirklees, West Yorkshire / Events / Upcoming / "dewsbury" / 1 to 15 of 48

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 / "dewsbury" / 1 to 15 of 48

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

Just Soph

Sat 17 Aug 2019

Just Soph

Greenwood Centre Library Dewsbury Saturday 17 Aug 2019, 2:30 pm A storytelling adventure based on Rudyard Kipling's 'The Just So Stories'. Have you ever wondered how the camel got his hump? Or how the elephant g.....Read more

Creepy Crawly Crafting - Free Family Workshop

Mon 19 Aug 2019

Creepy Crawly Crafting - Free Family Workshop

Join us for marvellous mini beast crafts for curious young minds. Email us or call us to reserve your place. Up to 2 children per adult...Read more

Free Family Workshop - Beach Bag Craft

Mon 19 Aug 2019

Free Family Workshop - Beach Bag Craft

Get arty and make your own beach bag out of an old t-shirt from home! Monday 19th August, 1pm - 3pm. Email us or give us a call to reserve your place. Up to 2 children per adult...Read more

Wed 21 Aug 2019

MIni-Tech Jam

Take part in this mini-tech jam and programme, code and play with tech. Make your own model to test, trial and take home. Suitable for age 8+. Parents/Carers are welcome to stay and help their child. Booking is essen.....Read more

Brigantia Bootcamp: Why Don't U

Wed 21 Aug 2019

Brigantia Bootcamp: Why Don't U

Our Why Don’t U? sessions are for anyone who wants to try something new in a trial and error environment. Aimed at anyone with an inquisitive mind, Why Don’t U? is led entirely by the group in what and how they want to l.....Read more

Writing: Making Your Mark - A Celebration day

Sat 24 Aug 2019

Writing: Making Your Mark - A Celebration day

Huddersfield Library & Art Gallery Sat 24th August 2019 10.00 am - 3.30 pm A day of free family activities to celebrate our Writing: Making Your Mark exhibition. 10.00 am -12.00 noon: Book making on a space theme w.....Read more

Young Curators Progamme: Drop In Sessions

Thu 29 Aug 2019

Young Curators Progamme: Drop In Sessions

hcmf//’s Young Curators Programme is aimed at developing talent and leadership amongst the music programmers, promoters and curators of the future. For this project hcmf// is looking to recruit a team of six, Kirklees-ba.....Read more

Brigantia Bootcamp: Creative Writing

Tue 03 Sep 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

Jeremiah

Wed 04 Sep 2019

Jeremiah

From the critically-acclaimed rap storyteller Jack Dean comes a raucous new gig theatre show about England’s forgotten revolution. On 9 June 1817, Jeremiah Brandreth assembles a crew of protesters in a pub near Nottin.....Read more

Creative Breakfast

Thu 05 Sep 2019

Creative Breakfast

Bringing together local artists, businesses and Kirklees residents, Brigantia’s monthly Creative Breakfast aims to facilitate conversations on how creativity can benefit our area and improve the lives of those who live a.....Read more

Freelance Thursdays: Personal Brand

Thu 05 Sep to Thu 17 Oct 2019 (1 month)

Freelance Thursdays: Personal Brand

Devising your personal brand can be difficult and making your business or practise stand out in a crowded field can sometimes feel impossible. In these four creative sessions, Pauline Lietch will harness your creative si.....Read more

Brigantia Bootcamp: Sketching

Tue 10 Sep 2019

Brigantia Bootcamp: Sketching

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

Lunchtime Concert: Murray Greig Trumpet Recital

Wed 11 Sep 2019

Lunchtime Concert: Murray Greig Trumpet Recital

Nothing heralds the start of a Lunchtime Concert Season in Dewsbury more than a rousing brass concert! This varied programme by Opera North's Principal Trumpet, with piano accompaniment, includes pieces Mahler Rachman.....Read more

Young Curators Progamme: Drop In Sessions

Thu 12 Sep 2019

Young Curators Progamme: Drop In Sessions

hcmf//’s Young Curators Programme is aimed at developing talent and leadership amongst the music programmers, promoters and curators of the future. For this project hcmf// is looking to recruit a team of six, Kirklees-ba.....Read more

Young Curators Progamme: Drop In Sessions

Sat 14 Sep 2019

Young Curators Progamme: Drop In Sessions

hcmf//’s Young Curators Programme is aimed at developing talent and leadership amongst the music programmers, promoters and curators of the future. For this project hcmf// is looking to recruit a team of six, Kirklees-ba.....Read more

1 / 2 / 3 / 4 /