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&view=list&page=24") 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-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-17", DATEDIFF(`media`.`mediaCreated`, "2019-07-17"), DATEDIFF("2019-07-17", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-17", DATEDIFF(`media`.`mediaUpdated`, "2019-07-17"), DATEDIFF("2019-07-17", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-17", DATEDIFF(`userLastUpdate`, "2019-07-17"), DATEDIFF("2019-07-17", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-17", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-17"), DATEDIFF("2019-07-17", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-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/528)*`media`.`mediaViews`)*`weightingMediaviews`, 0))+(IF(`weightingProfileviews`>0 AND `userProfileViews`>0, ((100/227)*`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 IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-17", "2018-07-17") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-16", "2019-07-17")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 345, 15;
News from Creative Kirklees / News / 346 to 354 of 354

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 / 346 to 354 of 354

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

The Flint Street Nativity

Mon 24 Sep 2018

The Flint Street Nativity

From the author of Calendar Girls and The Band comes a play of festive cheer and humour. The second play of our Season is The Flint Street Nativity by Tim Firth. Squabbles, grumbles and subversion... a normal school nati.....Read more

YSWN welcomes new Coordinator Emma Dick to the team

Wed 12 Dec 2018

YSWN welcomes new Coordinator Emma Dick to the team

Yorkshire Sound Women Network is delighted to welcome Emma Dick to the team this month as YSWN’s new Coordinator. Emma will be working part-time to support YSWN in the next exciting stages of its development as a fle.....Read more

Double bass maker and string instrument repairer opens workshop

Wed 02 Jan 2019

Double bass maker and string instrument repairer opens workshop

A new string instrument workshop is to open in Mirfield, West Yorkshire in January 2019. Neal Heppleston will be focusing on making new double basses as well as serving the local and national community with string instru.....Read more

Fashion icon swaps runway for Kirklees College hallways

Tue 12 Mar 2019

Fashion icon swaps runway for Kirklees College hallways

Legendary fashion designer and style icon Zandra Rhodes, who is as famous off the catwalk as she is on it, thanks to her bold pink hair and theatrical makeup, swapped the runways for the hallways of Kirklees College as s.....Read more

Celebrate The Civic

Fri 22 Mar 2019

Celebrate The Civic "It's all yours!"

The trustees are delighted to announce that The Civic in Slaithwaite has now transferred from Kirklees Council into community ownership - this means Slawit...'It's all yours!'. To celebrate this fantastic news we are.....Read more

Volunteer with Holmfirth Festival of Folk and get involved

Wed 27 Mar 2019

Volunteer with Holmfirth Festival of Folk and get involved

Would you like to volunteer during the Holmfirth Festival of Folk in May? We are a community based festival that relies on a dedicated group of volunteers to make the weekend happen. We still need volunteers for stew.....Read more

WOVEN Festival 2019

Thu 04 Apr 2019

WOVEN Festival 2019

Kirklees’ textile heritage is being put into the spotlight with the launch of the WOVEN festival, a celebration of the globally recognized industry. A series of events will be taking place over the week-long festival fro.....Read more

Huddersfield's Cloth and Textile Industry

Fri 05 Apr 2019

Huddersfield's Cloth and Textile Industry

It has been well known for a long time that Huddersfield has been home to the world’s finest cloth, but it is questionable as to whether the knowledge and passion is still existent today or is the legacy slowly raveling .....Read more

Woven in Kirklees

Tue 16 Apr 2019

Woven in Kirklees

A celebration of textiles A celebration of innovation A celebration of heritage THIS is what Woven is all about. Keep an eye out for our upcoming events across Kirklees!..Read more

/ 1 / / 5 / / 10 / / 12 / / 14 / 15 / 16 / 17 / 18 / 19 / 20 / 21 / 22 / 23 / 24