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`)>150, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 150), "..."), `media`.`mediaText`), "\r", ""), "\n", " "), "&", "&"), "\"", """), "\'", "'"), "<", "<"), ">", ">")="", "", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(IF(CHAR_LENGTH(`media`.`mediaText`)>150, CONCAT(SUBSTRING(`media`.`mediaText`, 1, 150), "..."), `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%5B0%5D=14&page=1") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=1 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-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-22", DATEDIFF(`media`.`mediaCreated`, "2019-07-22"), DATEDIFF("2019-07-22", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-22", DATEDIFF(`media`.`mediaUpdated`, "2019-07-22"), DATEDIFF("2019-07-22", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-22", DATEDIFF(`userLastUpdate`, "2019-07-22"), DATEDIFF("2019-07-22", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-22", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-22"), DATEDIFF("2019-07-22", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `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.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(50.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(50.468567))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.533231))+SIN(RADIANS(50.468567))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=1 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`=1 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-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-22", "2018-07-22") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-21", "2019-07-22")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (14) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Torbay / knowledge hub / News / Performing Arts / 1 to 15 of 26

Knowledge Hub

News / Performing Arts / 1 to 15 of 26

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

Don Juan makes fleeting visit to Holmfirth!

Thu 11 Jul 2019

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

Get Read for The HIDDEN VICTORIAN MUSLIMS

Thu 27 Jun 2019

Get Read for The HIDDEN VICTORIAN MUSLIMS

What's All This ... About These Victorian Muslims? My two new books are nearly ready! A historical biography PLUS a work of creative fiction abo.....Read more

New Creatives

Wed 22 May 2019

New Creatives

New Creatives is an exciting talent development scheme that offers commissioning opportunities for emerging artists to create new work in film, audio .....Read more

Ebb tide- a collection of three duets for clarinet and bassoon

Wed 19 Sep 2018

Ebb tide- a collection of three duets for clarinet and bassoon

Ebbtide is a collection of three duets for clarinet and bassoon which explores the symbolism of an ever-changing coastline as a metaphor for half-forg.....Read more

Dance Artist Call Out | Reckless Sleepers 'Take a Seat'

Tue 02 Apr 2019

Dance Artist Call Out | Reckless Sleepers 'Take a Seat'

Call out for dance artist residency with Reckless Sleepers May/June 2019 A collaboration between Reckless Sleepers, Dance in Devon and you? We ar.....Read more

Performance and Micro Commission Opportunity

Thu 25 Oct 2018

Performance and Micro Commission Opportunity

Performance Opportunity Dance in Devon is delighted to invite Devon dance artists to apply to take part in our seventh edition of Watch This Space. E.....Read more

U.Dance SW Regional Platform

Thu 25 Oct 2018

U.Dance SW Regional Platform

Dance in Devon is excited to announce that we will be hosting the U.Dance 2019 Regional Platform for the South West at Dartington on Sunday 14th April.....Read more

Dance and Fitness classes

Sun 18 Nov 2018

Dance and Fitness classes

Elizabeth is running taster classes at Pyramid Studios in Torquay starting on the 25th of November to create interest in regular weekly classes Th.....Read more

Three Women. One War. And a Ton of TNT

Mon 15 Oct 2018

Three Women. One War. And a Ton of TNT

Celebrate and commemorate the lives of Britain's unsung war heroes; The Canary Girls at The Beehive in Honiton on Friday 9 Nov 2018 at 7:30pm. Meet.....Read more

Centre of excellence initiative to pilot in Yorkshire

Thu 04 Oct 2018

Centre of excellence initiative to pilot in Yorkshire

A ground-breaking initiative to establish a network of centres of excellence for film and television in the nations and regions will be piloted in Yor.....Read more

Cleckheaton Announces Artist Line-up

Tue 08 Jan 2019

Cleckheaton Announces Artist Line-up

Following our recent successful Advent Calendar Artist announcements we are pleased to list our artists on our website. The list includes Jon Boden & .....Read more

Marshfest 2018 ...latest news

Thu 26 Jul 2018

Marshfest 2018 ...latest news

So you fancy trying a family festival? Marshfest fits the bill at only a fiver a ticket and kids go free! There are hundreds if not thousands of f.....Read more

Marshfest 2018  PRIZE DRAW!

Fri 03 Aug 2018

Marshfest 2018 PRIZE DRAW!

The Marshfest PRIZE DRAW is running on Facebook. Please Like AND Share the post to be in with a chance of winning. https://www.facebook.com/marshf.....Read more

Line-Up and times for Marshfest 2018

Wed 15 Aug 2018

Line-Up and times for Marshfest 2018

See poster for times of bands performing at Marshfest 2018..Read more

Dewsbury Lunchtime Concerts are back with Bite-Sized G&S

Sun 09 Sep 2018

Dewsbury Lunchtime Concerts are back with Bite-Sized G&S

Jeremy Peaker (Chorus of Opera North and formerly D’Oyly Carte) returns to Dewsbury Town Hall for the third year running to open the Lunchtime Chamber.....Read more

1 / 2 /