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`, "/")), "?disc%5B0%5D=13&month=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-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-15", DATEDIFF(`media`.`mediaCreated`, "2019-07-15"), DATEDIFF("2019-07-15", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-15", DATEDIFF(`media`.`mediaUpdated`, "2019-07-15"), DATEDIFF("2019-07-15", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-15", DATEDIFF(`userLastUpdate`, "2019-07-15"), DATEDIFF("2019-07-15", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-22" AND "2019-10-07", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-15", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-15"), DATEDIFF("2019-07-15", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-15" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-15", IF(`media`.`mediaDate`>"2019-07-15", `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/11)*IF(`userTotalItems`>11, 11, `userTotalItems`))*`weightingTotalitems`, 0))+(IF(`weightingMediaviews`>0 AND `media`.`mediaViews`>0, ((100/25351)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/2605)*`userProfileViews`)*`weightingProfileviews`, 0)))/(`weightingCreated`+`weightingUpdated`+`weightingProfileupdated`+`weightingDate`+`weightingDuration`+`weightingProximity`+`weightingSpecial`+`weightingTotalitems`+`weightingMediaviews`+`weightingProfileviews`) AS `relevance` FROM `media`, `users`, `mediatypes`, `networks`, `weightings`, `mediarefinements` 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 DATE_FORMAT(`media`.`mediaDate`, '%Y%m') = 201909 AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (13) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
What's on in Kirklees, West Yorkshire / Events / Music / September 2019 / 1 to 10 of 10

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 / Music / September 2019 / 1 to 10 of 10

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

1st / 2nd / 3rd / 4th / 5th / 6th / 7th / 8th / 9th / 10th / 11th / 12th

&Piano 2019 Event 1 - An Afternoon of Musical Theatre

Sun 08 Sep 2019

&Piano 2019 Event 1 - An Afternoon of Musical Theatre

&Piano is back for another season, celebrating and guiding you through music you may know, and may not! We begin &Piano again with another relaxed afternoon of songs from Musical Theatre. This year, as well as offering a.....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

Out of the Ashes Gospel Band

Sat 14 Sep 2019

Out of the Ashes Gospel Band

Christian Gospel, Rock and B&B band.This band is fronted by the Christian Jazz Singer PENNY LYON who was featured in the back page profile in Church Times on the 8th March 2019. Tickets go on sale on June 14th at .....Read more

Organ Concert: Gordon Stewart - 16 September

Mon 16 Sep 2019

Organ Concert: Gordon Stewart - 16 September

Gordon Stewart opens the season with a superb programme that includes arguably the most popular of Handel's overtures, Mendelssohn's wonderful Second Sonata and the Final from Vierne's First Symphony, a Toccata in all bu.....Read more

Orchestra of Opera North: The Emperor

Thu 19 Sep 2019

Orchestra of Opera North: The Emperor

Webern, Schubert, Beethoven Commanding orchestral showstoppers coupled with a phenomenal piano solo: you’ve got the perfect recipe for an impressive start to the Concert Season. THE MUSIC… Short, sharp and dyn.....Read more

Organ Concert: Gordon Stewart - 23 September

Mon 23 Sep 2019

Organ Concert: Gordon Stewart - 23 September

The blind organist Augustin Barié was considered by Vierne to be the finest improviser in Paris. Sadly he died young and left very few pieces for organ, but the three which end today's programme show him to be a composer.....Read more

The Drifters

Fri 20 Sep 2019

The Drifters

The Drifters are the longest running singing group in pop history, still performing live, having enjoyed over 50 hits world wide. The Drifters were created in 1953 by George Treadwell and Clyde McPhatter. George Treadwel.....Read more

Big Fish Little Fish 'Vikings & Dragons' Family Rave

Sun 22 Sep 2019

Big Fish Little Fish 'Vikings & Dragons' Family Rave

Come join raving Valhalla! Award-winning, pioneering Big Fish Little Fish family rave return triumphantly to the Watford Colosseum with a 'Vikings & Dragons' themed event on 22 September 2019. DJ Aston Harvey (Freestyle.....Read more

Jasper Carrot: Stand Up and Rock

Thu 26 Sep 2019

Jasper Carrot: Stand Up and Rock

Stand Up & Rock is back…. The 2019 tour will see the legendary Jasper Carrott return with a new stand up show alongside his musical compatriots, the Bev Bevan Band that have been ‘rockin’ audiences all over the world......Read more

Tropicana Nights

Sat 28 Sep 2019

Tropicana Nights

Looking for a fun filled evening of fantastic 80s music and dancing? Then look no further… Join us at Tropicana Nights and indulge yourselves in pure 80s heaven. Whether you go all out in your favourite 80s outfit or .....Read more