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&month=8") 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-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-26", DATEDIFF(`media`.`mediaCreated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-26", DATEDIFF(`media`.`mediaUpdated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-26", DATEDIFF(`userLastUpdate`, "2019-06-26"), DATEDIFF("2019-06-26", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-26", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-26"), DATEDIFF("2019-06-26", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `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/590)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/240)*`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`=2 AND `userNetwork` IN (9) AND DATE_FORMAT(`media`.`mediaDate`, '%Y%m') = 201808 GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
News from Creative Kirklees / News / August 2018 / 1 to 15 of 34

News

The latest arts and creative news from members of the Creative Kirklees directory.

News posted on the site is regularly featured in the newsletter and our social media, which reach thousands of local individuals and businesses.

To share your news, register and log into MyAccount.

News / August 2018 / 1 to 15 of 34

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

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

Guided Tours at Tolson Museum

Wed 08 Aug 2018

Guided Tours at Tolson Museum

TOLSON GUIDED TOURS A revealing tour of the museum Tolson Museum, Ravensknowle Park, Wakefield Road, Huddersfield HD5 8DJ Sunday 19 August: 1pm and 2.30pm FREE; book on the day at the reception desk For more info.....Read more

Tolson Summer Activity Day

Wed 08 Aug 2018

Tolson Summer Activity Day

TOLSON SUMMER ACTIVITY DAY Discover what life was like as a Roman soldier Tolson Museum, Ravensknowle Park, Wakefield Road, Huddersfield HD5 8DJ Wednesday 15 August: 12noon-4pm £2 per child; no need to book For m.....Read more

Morris Dancing in the Garden

Thu 09 Aug 2018

Morris Dancing in the Garden

MORRIS DANCING IN THE GARDEN The White Rose Morris Men entertain in the Memorial Garden at Tolson Museum, Ravensknowle Park, Wakefield Road, Huddersfield HD5 8DJ Sunday 12 August: 2pm-4pm FREE Continuing the summer.....Read more

WILL THE TOLSON PANTHER STEAL THE SHOW?

Thu 16 Aug 2018

WILL THE TOLSON PANTHER STEAL THE SHOW?

Motorcycle enthusiasts are gearing up for the hugely popular annual Tolson Museum Motorbike Show on Sunday 9 September. Whilst there is excited anticipation about the variety of makes, models and vintages of motorbikes .....Read more

Arts Fundraising & Philanthropy - 1 Day Fundraising Courses

Wed 01 Aug 2018

Arts Fundraising & Philanthropy - 1 Day Fundraising Courses

Between September 2018 and March 2019, Arts, Fundraising & Philanthropy are offering five one-day training courses, all of which are aimed at equipping participants with the Fundraising Essentials to succeed in raising f.....Read more

Arts Fundraising & Philanthropy - Leadership Courses

Wed 01 Aug 2018

Arts Fundraising & Philanthropy - Leadership Courses

Between September 2018 and March 2019, Arts Fundraising and Philanthropy are offering three Leadership courses, all of which are aimed at equipping participants to succeed in fundraising as managers and leaders within a .....Read more

Arts Fundraising & Philanthropy - Governance Courses

Wed 01 Aug 2018

Arts Fundraising & Philanthropy - Governance Courses

Arts Fundraising & Philanthropy are delivering Governance courses which are designed for current Trustees or those who would like to become a Trustee. Whether you would like to learn more on how you could support Fund-ra.....Read more

Arts Fundraising & Philanthropy -Specialist Series of Courses

Wed 01 Aug 2018

Arts Fundraising & Philanthropy -Specialist Series of Courses

Arts Fundraising & Philanthropy are delivering a specialist series of courses which is dedicated to specific fundraising needs and skills around need and demand in the sector. Their specialist training series for 2019 ar.....Read more

Money for Music in Kirklees

Fri 17 Aug 2018

Money for Music in Kirklees

An ambitious project to make the most of Kirklees’ rich and diverse musical heritage has received a cash boost this week. The project has received £299,032 from the Leeds LEP’s Business Rates Pool fund to spend on m.....Read more

Music A-level “in danger of disappearing from state schools”

Mon 20 Aug 2018

Music A-level “in danger of disappearing from state schools”

The sharp warning from the Association of School and College Leaders comes as A-level data reveals the decline in entries for arts subjects has doubled in speed since last year. A-level music is “hanging on by [its] f.....Read more

Just How Big is the Video Gaming Industry?

Mon 20 Aug 2018

Just How Big is the Video Gaming Industry?

Back in the days - in the 80’s, the video game industry was just a small-but-steadily-growing part of a larger picture. Today, the gaming industry is now generating not just hundreds of thousands or millions of dollars b.....Read more

Don't be a

Wed 29 Aug 2018

Don't be a "d..k" What no one tells you about running a business

An interesting article observing some of the highlights, frustrations and benefits of being self-employed. Don't be a "d..k". What no one tells you about running your own business... Written by Geoff Shepherd, Chairm.....Read more

Mural takes shape in Queensgate Market event space

Wed 29 Aug 2018

Mural takes shape in Queensgate Market event space

The mural by artist Kasia Breska is taking shape in Queensgate Market as she continues to brighten up the event space. This image shows the vibrant colours used on the end wall and the start of the large back wall. Wor.....Read more

Sugarlift and Spit-Bite Aquatint – September

Thu 02 Aug 2018

Sugarlift and Spit-Bite Aquatint – September

Day course Saturday 22nd September 2018 11 – 5 £70.00 This day course will introduce you to sugarlift and spit-bite aquatint techniques. Sugarlift is a way of making positive marks on an etching plate. Stopping o.....Read more

Linocut Day – September

Thu 02 Aug 2018

Linocut Day – September

Day workshop Saturday 15th September 2018 11 – 5 £70 Learn the basics of linocut printmaking and come away with a small edition of prints carved by your very own hands! This course will show you how to transfer y.....Read more

1 / 2 / 3 /