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(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")="", "", REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>220, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 220), "..."), `media`.`mediaText`), "\r", ""), "\n", " ")) AS `desc`,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("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-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-21", DATEDIFF(`media`.`mediaCreated`, "2019-07-21"), DATEDIFF("2019-07-21", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-21", DATEDIFF(`media`.`mediaUpdated`, "2019-07-21"), DATEDIFF("2019-07-21", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-21", DATEDIFF(`userLastUpdate`, "2019-07-21"), DATEDIFF("2019-07-21", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-21", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-21"), DATEDIFF("2019-07-21", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `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/504)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/225)*`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 DATE_FORMAT(`media`.`mediaDate`, '%Y%m') = 201910 GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 50;
What's on in Kirklees, West Yorkshire / Events / October 2019 / 1 to 26 of 26 https://www.creativekirklees.com/listings/events/?network%5B0%5D=9&month=10&view=rss Find amazing arts and creative events with Creative Kirklees’s What’s On guide for Huddersfield, Holmfirth, Dewsbury, Batley and surrounding areas. Get dates in your diary now! The Very Hungry Caterpillar Show Tue, 01 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/the-very-hungry-caterpillar-show/ MEI Theatrical Ltd. The timeless classic has made its way off the page and onto the stage. Created by Jonathan Rockefeller, the critically acclaimed production of The Very Hungry Caterpillar Show features a menager... Under Three Moons Tue, 01 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/under-three-moons/ Box of Tricks Theatre Company. “I bet when they get older they’re going to look back on tonight and say, that was a night that was, by that fire, that was a night.” Mike and Paul are mates. They drink, they smoke, ... Orchestra of Opera North: A Feast of Gilbert and Sullivan Sun, 06 Oct 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-concert-season/a-feast-of-gilbert-and-sullivan/ A concert performance brimming with sparkling satire, titillating tongue twisters and colourful characters. Famed for their catchy creations, up-tempo thrills and unavoidable earworms, now’s your chance to enjoy Gilb... Organ Concert: Alex Berry - 7 October Mon, 07 Oct 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-concert-season/organ-concert-alex-berry-7-october/ The Director of Music at Bradford Cathedral makes his Huddersfield Town Hall debut in a wide-ranging programme which includes Herbert Brewer's wonderful transcription of the prelude and final section of Elgar's Dream of ... Reasons To Stay Alive Tue, 08 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/reasons-to-stay-alive/ Matt Haig An English Touring Theatre and Sheffield Theatres co-production. Imagined for the stage by Jonathan Watkins Adapted by April de Angelis At 24 Matt’s world collapsed and he could see no way to go on. ... The Musical World of Ivor Novello Wed, 09 Oct 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-concert-season/the-musical-world-of-ivor-novello/ David Greed joins acclaimed pianist Ian Buckle and Opera North Chorister Sarah Estill for a delightful expedition through some of Ivor Novello's greatest musicals. Featuring a selection of beloved classics including, ... Portrait Sculpture Masterclass Thu, 10 Oct 2019 00:00:00 +0100 https://creativekirklees.com/jamie-frost-mrss/portrait-sculpture-masterclass/ In this masterclass you will spend three days working from a live model to study the art of clay portrait sculpture. At the end of the course you will have produced a life-size sculpture from quality handbuilding clay an... Huddersfield Raspberry Jam Sat, 12 Oct 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-libraries/hudds-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... Count Arthur Strong: Is There Anybody Out There? Wed, 16 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/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... The Rite of Spring & Left Unseen Tue, 15 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/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... Dorian Thu, 17 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/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... October Comedy Cellar Thu, 17 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/october-comedy-cellar-2019/ 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... Clare Teal and her Band Thu, 24 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/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... Memories of an Indian Childhood Fri, 25 Oct 2019 00:00:00 +0100 https://creativekirklees.com/lawrence-batley-theatre/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... Soonchild Mon, 28 Oct 2019 00:00:00 +0000 https://creativekirklees.com/lawrence-batley-theatre/soonchild/ Red Earth Theatre in association with Arena Theatre Wolverhampton & Derby Theatre. Based on the book by Russell Hoban. Dig out your snowshoes for an Arctic Adventure with live music and songs, 3D and shadow puppets, ... John Robbins: Hot Shame (comedian) Tue, 29 Oct 2019 00:00:00 +0000 https://creativekirklees.com/lawrence-batley-theatre/john-robbins-hot-shame-comedian/ Edinburgh Comedy Award Winner, Digital DJ, Internet-Based Quiz Show Host, yells into a well. Robins returns with his first new show since the sell-out smash The Darkness Of Robins. Soul-bearing, self-lacerating, pipin... Staging Schiele Wed, 30 Oct 2019 00:00:00 +0000 https://creativekirklees.com/lawrence-batley-theatre/staging-schiele/ Shobana Jeyasingh Dance. Award-winning Shobana Jeyasingh Dance stage a new searing piece inspired by the life and work of artist Egon Shiele. Four dancers inhabit Schiele’s highly-charged world of colour, masterful... Seaside Terror Thu, 31 Oct 2019 00:00:00 +0000 https://creativekirklees.com/lawrence-batley-theatre/seaside-terror/ Odd Doll. Let Odd Doll take you on a terrifying trip to the seaside this Halloween. Be careful as you walk along the dilapidated pier, as the ice cream man is not quite who he seems… Explore his mind-boggling co... Organ Concert: Gordon Stewart with George King - 21 October Mon, 21 Oct 2019 00:00:00 +0100 https://creativekirklees.com/kirklees-concert-season/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... Shrink Plastic Workshop at Holmfirth Tech, 27/10/19 1-3 Sun, 27 Oct 2019 00:00:00 +0100 https://creativekirklees.com/darnitworkshops/shrink-plastic-workshop-at-holmfirth-tech-27-10-19-1-3/ This session we'll be working with shrink plastic, it's amazing and comes in different colours, you draw on it and it shrinks down 7 times, turning into a thick plastic piece with a condensed and fab looking image. You'l... Batik Workshop at The Peppercorn Thu, 31 Oct 2019 00:00:00 +0000 https://creativekirklees.com/darnitworkshops/batik-workshop-at-the-peppercorn-huddersfield/ In this session you will learn how to do the ancient art of Batik. Batik is a textile surface pattern technique that's existed in many eastern cultures for hundreds of years and creates a distinct and attractive design.... Halloween crafts – mummies, mummies, mummies! Tue, 29 Oct 2019 00:00:00 +0000 https://creativekirklees.com/j-howroyd/halloween-crafts-mummies-mummies-mummies/ Halloween drop in session at Bagshaw Museum from 11am-3pm. Make your own mummy fingers and toes to scare people this Halloween! You can even decorate a spooky jar to keep them in. Also have a go at making mummy masks as... Lower Cumberworth Community Rooms- Autumn Craft Fair 2019 Sat, 26 Oct 2019 00:00:00 +0100 https://creativekirklees.com/jesmond-cat-designs/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. Gold in Japanese Art: Sacred and Profane Thu, 17 Oct 2019 00:00:00 +0100 https://creativekirklees.com/arts-society-huddersfield/lecture-by-dr-meri-arichi-at-7-30pm/ 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... Byram Arcade Craft Fair - Oct Sun, 13 Oct 2019 00:00:00 +0100 https://creativekirklees.com/crafty-baggage/byramarcadecraftfairoct/ 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, ... Felting Workshop at The Peppercorn - Oct Thu, 24 Oct 2019 00:00:00 +0100 https://creativekirklees.com/crafty-baggage/feltingpeppercornoct/ 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...