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%5B%5D=12") 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-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/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`=2 AND IF(`mediatypes`.`mtDate`=0, 1, 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 IF(`mediatypes`.`mtFuture`=1, "2019-07-21", "2018-07-21") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-20", "2019-07-21")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (12) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
News from Creative Kirklees / News / Places / Venues / Event / 1 to 15 of 219

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 / Places / Venues / Event / 1 to 15 of 219

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

Screen Printing Posters – July

Wed 17 Jul 2019

Screen Printing Posters – July

Weekend course Saturday 27th & Sunday 28th July 2019 10am – 4pm Learn the process of screen printing in our professionally equipped workshops and produce hand-made posters and art-prints! This 2 day course will cove.....Read more

Lino etching summer school - August

Tue 16 Jul 2019

Lino etching summer school - August

Our next Lino printing course coming up is our new 'Lino Etching Summer School' in August with artists Jenny Thomas and Fabian Osborne. 3 day course Friday 2nd, Saturday 3rd & Sunday 4th August 2019 10am – 4pm .....Read more

Big Art Fair Preview Night: awards + Open Studios Launch

Tue 09 Jul 2019

Big Art Fair Preview Night: awards + Open Studios Launch

Join our celebration on Friday 12th July 7pm-9pm Our Friday Preview Night is our official opening and sees the launch of our 2019 Open Studios brochure, as well as Big Art Fair Sponsors Choice Award certificates. With.....Read more

Textile Screen Printing – July

Thu 04 Jul 2019

Textile Screen Printing – July

4 week course Wednesday evenings 10th, 17th, 24th & 31st July 2019 6 – 9pm £135.00 Tutor: Karen Stansfield Learn textile screen printing over 4 evening sessions in our fully equipped workshop and take home s.....Read more

Monoprinting – Taster Session – June

Thu 20 Jun 2019

Monoprinting – Taster Session – June

Coming up next week! Monoprinting – Taster Session Thurs 27 June £30 - Evening session 6 - 9 Join artist Cath Brooke and explore monoprinting, a way of producing one-off prints by rolling ink onto a plastic .....Read more

Linocut & Colour Blends – June

Thu 20 Jun 2019

Linocut & Colour Blends – June

Sat 29 & Sun 30 June £135 - Weekend course 11 - 5 Tutor: Scarlette Averley Join artist Scarlette Averley for this immersive weekend course exploring linocut printing. Learners will be guided through the red.....Read more

Can Artweek Hit the Million in 2019?

Tue 18 Jun 2019

Can Artweek Hit the Million in 2019?

Artweek is poised to break through the Million pounds donated to Macmillan Cancer Support this year. Following a fantastic sum raised last year (£41,000), they are hoping to get the total passed the £1 million milestone......Read more

Huddersfield Repair Café needs you!

Tue 18 Jun 2019

Huddersfield Repair Café needs you!

Are you interested in helping to run a monthly repair café in Huddersfield Queensgate Market? If you're a fixer of things - for electrical goods, computers, kids’ toys, bikes, wooden bits and random stuff - or can help .....Read more

Musica Mirfield Swing Band - This Saturday

Thu 13 Jun 2019

Musica Mirfield Swing Band - This Saturday

Saturday 15th June, 7.30 - 9.30pm Join us at St Paul’s Church for a night dancing with Musica Mirfield Swing Band! We are organising a fundraiser of swing music, by the wonderful Mirfield Musica swing band, to take.....Read more

Drypoint – Taster Session – June

Wed 12 Jun 2019

Drypoint – Taster Session – June

Our next printmaking taster session coming up in June is Drypoint with artist Cath Brooke! Thurs 20 June £30 - Evening session 6 - 9 This workshop will introduce you to the technique of #drypoint, an ‘intaglio’.....Read more

Makers Market in Huddersfield this weekend

Tue 11 Jun 2019

Makers Market in Huddersfield this weekend

Pop in to Huddersfield this weekend for the WOVEN Makers Market at the Byram Arcade and the Lawrence Batley Theatre courtyard. Come and browse local crafts and makers on Saturday 15 June...Read more

Recycling Through Print - FREE Family activity - 8 & 15 June

Thu 06 Jun 2019

Recycling Through Print - FREE Family activity - 8 & 15 June

Recycling Through Print - FREE Family activity bring along some textiles! 8 & 15 June, 10.30am - 3.00pm Do you have textile items such as a shirt, T-shirt, jacket or cushion which need some TLC? Revitalise your f.....Read more

Screen Printing: Paper – Taster Session – June

Thu 06 Jun 2019

Screen Printing: Paper – Taster Session – June

Thurs 13 June £30 - Evening session 6 - 9 Tutor: Neil Anderson In this workshop you will be introduced to the technique of screen printing, where ink is pushed through a frame covered in a fine mesh screen, on.....Read more

Photo-Plate Lithography - June

Thu 06 Jun 2019

Photo-Plate Lithography - June

Sat 15 June £80 - Day course 10 - 5 Tutor: Kate Desforges Spend a day learning photo-plate lithography in our specially equipped workshops. Photo-plate lithography can produce prints with remarkable subtle tona.....Read more

Circle, Line and Geometric Patterns - June

Tue 04 Jun 2019

Circle, Line and Geometric Patterns - June

Sat 8 June £70 - Day workshop 10 - 4 Only a few places left on our latest #screenprinting course with printmaker Saba Rifat. On this one-day workshop you will be guided through creating simple geometric pattern.....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / / 11 / / 13 / / 15 /