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`=2 AND `userNetwork` IN (9) AND DATE_FORMAT(`media`.`mediaDate`, '%Y%m') = 201907 GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 50;
News from Creative Kirklees / News / July 2019 / 1 to 13 of 13 https://www.creativekirklees.com/listings/news/?network%5B0%5D=9&month=7&view=rss Read the latest Creative Kirklees news and sign up to receive our weekly newsletter. Keep up to date with arts and creative events going on near you and pick up on the latest jobs and funding info. Screen Printing Posters – July Wed, 17 Jul 2019 00:00:00 +0100 https://creativekirklees.com/wyprintworkshop/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... Lino etching summer school - August Tue, 16 Jul 2019 00:00:00 +0100 https://creativekirklees.com/wyprintworkshop/lino-etching-summer-school/ 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 ... Decline in local authority culture spend slows Mon, 15 Jul 2019 00:00:00 +0100 https://creativekirklees.com/creative-kirklees/decline-in-local-authority-culture-spend-slows/ Cuts to local authorities’ culture budgets are slowing, with a 1% drop across England reported to the Government this year. Figures for 2019/20 show councils and other authorities are allocating a total of £38.7bn for ... Don Juan makes fleeting visit to Holmfirth! Thu, 11 Jul 2019 00:00:00 +0100 https://creativekirklees.com/access-north/don-juan-makes-fleeting-visit-to-holmfirth/ As a company, Access North actively supports culture and the arts as part of our CSR programme. Business development director, Daniel Northcott has a strong affiliation with the arts scene so for 2019, Access North is sp... Marsden Jazz Festival needs your help & support Tue, 09 Jul 2019 00:00:00 +0100 https://creativekirklees.com/creative-kirklees/marsden-jazz-festival-needs-your-help-support/ Award-winning Marsden Jazz Festival has launched a funding campaign and needs to raise £10,000 by 21 July to secure the festival for this October. The 28th Marsden Jazz Festival will take place from Friday 11th - Sund... Free Family Summer Holiday Workshops Tue, 09 Jul 2019 00:00:00 +0100 https://creativekirklees.com/kc-adult-community-education/free-family-summer-holiday-workshops/ Join us at sites across Kirklees during the Summer Holidays for some Free Family workshops. We look forward to receiving your call or email to reserve your place. 'Landscape Through Language' - Tom Ratcliffe Fri, 05 Jul 2019 00:00:00 +0100 https://creativekirklees.com/creative-kirklees/landscape-through-language-tom-ratcliffe/ You are invited to join Creative Arts Hub for the launch of Tom Ratcliffe’s latest exhibition, this Friday from 6pm (5 July). “My work is influenced by the theoretical writings of the philosopher Michel Foucault and c... Digital Enterprise Phase 2 Thu, 04 Jul 2019 00:00:00 +0100 https://creativekirklees.com/creative-kirklees/digital-enterprise-phase-2/ In September, phase two of the Digital Enterprise programme (DE 2.0) will launch, offering an enhanced programme of support for SMEs in the Leeds City Region that are keen to develop their digital capabilities. The progr... Textile Screen Printing – July Thu, 04 Jul 2019 00:00:00 +0100 https://creativekirklees.com/wyprintworkshop/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... Temporary Contemporary Happening - Thursday 4 July Tue, 02 Jul 2019 00:00:00 +0100 https://creativekirklees.com/temporary-contemporary/temporary-contemporary-happening-thursday-4-july/ With the Woven Festival still fresh in our minds, this week's Happening event is right on cue! Quilting Together" and "The Laundry Pile" exhibitions launch in the Market Gallery and quilts made from recycled fabric wi... Request for book donations please! Tue, 02 Jul 2019 00:00:00 +0100 https://creativekirklees.com/temporary-contemporary/request-for-book-donations-please/ We would be very grateful for any donations of old or unwanted books for our shelves (opposite Market Hardware) in Queensgate Market. As part of the Temporary Contemporary project, we have created a resource for ins... Can you help our young people? Mon, 01 Jul 2019 00:00:00 +0100 https://creativekirklees.com/creative-kirklees/can-you-help-our-young-people/ Can you help young Producers bring their ideas to life? Pledge today: crowdfunder.co.uk/paper-peace A team of 48 young producers aged 18 to 25 around the country have been working for a year on training and heritage p... Bassment Unplugged Music Industry Training Mon, 01 Jul 2019 00:00:00 +0100 https://creativekirklees.com/safisarah/bassment-unplugged-music-industry-training/ I have now hooked up with Bassment to create a music industry training provision, we are now extremely proud to present Bassment Unplugged! Over the past year, we have been putting together a musical education program...