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=41") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=2 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-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-17", DATEDIFF(`media`.`mediaCreated`, "2019-08-17"), DATEDIFF("2019-08-17", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-17", DATEDIFF(`media`.`mediaUpdated`, "2019-08-17"), DATEDIFF("2019-08-17", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-17", DATEDIFF(`userLastUpdate`, "2019-08-17"), DATEDIFF("2019-08-17", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-25" AND "2019-11-09", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-17", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-17"), DATEDIFF("2019-08-17", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-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(50.960251))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.461586))+SIN(RADIANS(50.960251))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(50.960251))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.461586))+SIN(RADIANS(50.960251))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(50.960251))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-0.461586))+SIN(RADIANS(50.960251))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=2 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`.`mediaChecked`=0 OR `media`.`mediaApproved`=1) AND `userID`=`media`.`mediaUser` AND `networkID`=`userNetwork` AND `userPublish`=1 AND `userActive`=1 AND `mediatypes`.`mtID`=`media`.`mediaType` AND `weightingNetwork`=2 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-08-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-17", IF(`media`.`mediaDate`>"2019-08-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-17", "2018-08-17") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-16", "2019-08-17")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (41) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creatives Across Sussex / News / News / Festivals / 1 to 15 of 37

News

The latest arts and creative news from members of the Creatives Across Sussex directory.

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

To share your news, register and log into My Space.

News / Festivals / 1 to 15 of 37

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

&Piano 2019 Event Dates Announced

Wed 14 Aug 2019

&Piano 2019 Event Dates Announced

After it's first successful year in 2018, &Piano returns for another season of fantastic music performed by fantastic musicians. &Piano begins again with a relaxed afternoon of Musical Theatre on Sunday September 8th .....Read more

Marsden Jazz Festival needs your help & support

Tue 09 Jul 2019

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.....Read more

WOVEN textile artists in Queensgate Market

Tue 11 Jun 2019

WOVEN textile artists in Queensgate Market

Textile artists have taken over some of the vacant stalls in Queensgate Market during the WOVEN festival 8-16 June. The work on show gives an example of the range of work that textiles covers - 3D, 2D, floor pieces and .....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

Official Selection

Wed 19 Sep 2018

Official Selection

COMING OF AGE... Hello friends, delighted that Award Winning Heaven's Rage is an Official Selection at The LGBTQ COMING OF AGE short-films Festival in San Francisco, USA. Exclusively dedicated to movies dealing wi.....Read more

Official Selection

Fri 21 Sep 2018

Official Selection

Hello friends, delighted again to announce that Heaven's Rage is an Official Selection at Darkroom Film Festival hosted by Deptford Cinema on 29/30 September in London. Darkroom festival at Deptford Cinema presents a.....Read more

Early Bird Ticket offer for Holmfirth Arts Festival 2019

Sat 01 Jun 2019

Early Bird Ticket offer for Holmfirth Arts Festival 2019

Grab your discounted Early Bird Tickets for Holmfirth Arts Festival 2019 before midnight tomorrow Sunday 2 June. Early Bird Sale ends 11.59pm. Three days of shows coming from all corners of the globe, including head.....Read more

FREE Drop In Workshops for Holmfirth Arts Festival Parade 2019

Sat 01 Jun 2019

FREE Drop In Workshops for Holmfirth Arts Festival Parade 2019

Come and create your own crafty addition before you join the Holmfirth Arts Festival Parade 2019. Join Edgelands Arts as they use multiple lengths of decorative ribbon to create a unique river of stories to weave thro.....Read more

TV comedian Simon Evans to star at Holmfirth Arts Festival 2019

Sat 01 Jun 2019

TV comedian Simon Evans to star at Holmfirth Arts Festival 2019

Off the Kerb Productions presents Simon Evans: Genius Ever since he was a small boy, all Evans really wanted was to be recognised by the world as a man of genius. He has, until now, remained thwarted. The world seem.....Read more

Celebrate Father's Day at Holmfirth Arts Festival 2019

Sat 01 Jun 2019

Celebrate Father's Day at Holmfirth Arts Festival 2019

See Children's Theatre at Holmfirth Arts Festival on Father's Day Sunday 16 June at 12 noon. Catch Bird's Nest Billy, by Fidget Theatre at Holmfirth Civic Hall, for perfect way to spend time with your little ones. .....Read more

Worldwide Knit in Public Day

Tue 28 May 2019

Worldwide Knit in Public Day

On the 8th of June 2019, people all over Kirklees will be celebrating Worldwide Knit in Public Day with THE BIG KNIT. The Big Knit is an opportunity to share skills, get creative and have a cuppa, by joining in with e.....Read more

Guitarist/singer wanted

Fri 24 Aug 2018

Guitarist/singer wanted

Groove style and originality without ego. Originals only, ability to jam out ideas and to groove with great feel and timing. As a start point for a musical style imagine what the 80's band Japan would sound like .....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

Local festivals encourage residents to become ‘music hosts’

Fri 12 Oct 2018

Local festivals encourage residents to become ‘music hosts’

Kirklees is home to internationally recognised world class music, and every year its diverse programme of events attracts thousands of music and cultural tourists from across the UK and all around the world. During t.....Read more

Kirklees' Year of Music 2023 launch

Mon 15 Apr 2019

Kirklees' Year of Music 2023 launch

A visionary music project is expected to come out of a partnership between groups, festivals, the University of Huddersfield and Kirklees Council. Kirklees Year of Music 2023 launched at the University on Thursday 1.....Read more

1 / 2 / 3 /