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=2") 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') = 201902 GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
News from Creative Kirklees / News / February 2019 / 1 to 15 of 40

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 / February 2019 / 1 to 15 of 40

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

Tolson Half-Term Activity Day

Wed 06 Feb 2019

Tolson Half-Term Activity Day

Children can have ‘SCRAPtastic’ fun at Tolson Museum in Huddersfield this half-term. On Wednesday, 20 February, fairandfunky will be bringing their popular family workshop to the museum on Wakefield Road to show famili.....Read more

Celebrating The Women In Kirklees Museums’ Displays

Wed 06 Feb 2019

Celebrating The Women In Kirklees Museums’ Displays

To mark International Women’s Day 2019, there will be events held at Bagshaw Museum in Batley and Tolson Museum in Huddersfield which will focus on the women who have helped create Kirklees Museums and look at how women.....Read more

Tolson Guided Tours

Wed 06 Feb 2019

Tolson Guided Tours

A new series of monthly guided tours of Tolson Museum in Huddersfield starts on Sunday, 17 February. The free tours of the museum in Ravensknowle Park on Wakefield Road tell the fascinating history of the Victorian mans.....Read more

Tea & Cake & talk

Wed 06 Feb 2019

Tea & Cake & talk

A cuppa will be the perfect accompaniment to good advice at the next ‘Tea & Cake’ afternoon at Tolson Museum in Huddersfield on Wednesday, 13 February. The Friends of Tolson Museum, who run the social afternoon, have in.....Read more

St.Valentine’s Cream Tea

Fri 08 Feb 2019

St.Valentine’s Cream Tea

There is still time to treat someone you love to a special St. Valentine’s Cream Tea at Tolson Museum, Huddersfield, on Sunday 17 February. The Friends of Tolson Museum will be serving cream teas between 1pm and 3.30pm.....Read more

Mothering Sunday Cream Teas at Tolson

Thu 28 Feb 2019

Mothering Sunday Cream Teas at Tolson

This Mothering Sunday you can spoil your mum - or any other special person in your life – with afternoon cream tea at Tolson Museum in Huddersfield. On Sunday, 31 March, the Friends of Tolson will once again open the do.....Read more

Tea & Cake at Tolson Museum

Thu 28 Feb 2019

Tea & Cake at Tolson Museum

Honley’s long-lost pleasure resort Hope Bank is the subject of the next Tea & Cake meeting at Tolson Museum, Huddersfield on Wednesday, 13 March. Hope Bank Pleasure Grounds was a massive attraction in the early and midd.....Read more

Big Lottery Fund and Heritage Lottery Fund Announce Name Changes

Mon 04 Feb 2019

Big Lottery Fund and Heritage Lottery Fund Announce Name Changes

The two lottery funders have changed their names and logos to reflect the direct connection between the sale of National Lottery tickets and the money going to good causes across the UK. The Big Lottery Fund will now be.....Read more

Epicure celebrates the town in their newsletter & facebook post

Mon 04 Feb 2019

Epicure celebrates the town in their newsletter & facebook post

Epicure Bar and Kitchen are spreading some positivity and good vibes about Huddersfield town centre. They believe there's lots to be excited about and have written an item for their newsletter and facebook post whic.....Read more

CuratorSpace launches subscription with Public Liability

Thu 07 Feb 2019

CuratorSpace launches subscription with Public Liability

CuratorSpace have just launched a new subscription which provides £5m Public Liability Insurance as well as eligibility to apply for their bursaries for only £35 per year. £5m Public & Products Liability (PPL) artist .....Read more

Get Creative Festival

Mon 11 Feb 2019

Get Creative Festival

Get Creative Festival shines a light on all the great cultural activity that takes place right across the UK on a regular basis and encourages people to try their hand at something new and creative. This huge national ce.....Read more

New film - Destination Dewsbury

Wed 20 Feb 2019

New film - Destination Dewsbury

We've been asked to give a shout out for a new film just out called Destination Dewsbury - the Premiere is at the Showcase Cinema in Birstall on Saturday 23 February and on general release from Friday 01 March. Dire.....Read more

Setting Up as a Freelance Artist

Mon 25 Feb 2019

Setting Up as a Freelance Artist

There are still a few places left on Creative Scene's 'Setting up as a Freelance Artist' workshop this Thursday from 1-3pm with Leeds-based producer Anna Turzynski. The workshop will cover everything from finances to.....Read more

Diversity, Inclusion and Innovation in Kirklees event

Tue 26 Feb 2019

Diversity, Inclusion and Innovation in Kirklees event

Since the arrival of the Windrush Generation (people from around the Commonwealth who were invited to help rebuild Britain after World War II) our communities and businesses have become increasingly diverse, inclusive an.....Read more

Economic Impact Study on Music Festivals

Wed 27 Feb 2019

Economic Impact Study on Music Festivals

An update to an Economic Impact Study has recently been produced, which builds on a wide-ranging economic research project that was undertaken across six Kirklees festivals and events back in 2007. The latest study focus.....Read more

1 / 2 / 3 /