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`, "/")), "?network%5B0%5D=1&page=4") 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-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-26", DATEDIFF(`media`.`mediaCreated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-26", DATEDIFF(`media`.`mediaUpdated`, "2019-06-26"), DATEDIFF("2019-06-26", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-26", DATEDIFF(`userLastUpdate`, "2019-06-26"), DATEDIFF("2019-06-26", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-03" AND "2019-09-18", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-26", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-26"), DATEDIFF("2019-06-26", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `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` 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 `userNetwork` IN (1) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-26" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-26", IF(`media`.`mediaDate`>"2019-06-26", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-26", "2018-06-26") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-25", "2019-06-26")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 45, 15;
Creative Torbay / knowledge hub / News / 46 to 60 of 71

Knowledge Hub

News / 46 to 60 of 71

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

Halloween Activities & Workshops

Wed 12 Sep 2018

Halloween Activities & Workshops

Half Term Halloween Activities. View our website for further information or call message...Read more

A bevvy of badgers!

Mon 01 Apr 2019

A bevvy of badgers!

Arriving soon, a bevvy of little badgers, all wanting new homes! These little lovelies should be arriving at my studio near Totnes within the next wee.....Read more

Slug Bait - A Paignton Noir Mystery

Sat 15 Sep 2018

Slug Bait - A Paignton Noir Mystery

I have a new novelette out now: SLUG BAIT! Here’s the synopsis: Traumatised and brutalised after a grisly encounter with a serial killer known a.....Read more

Repetition Kills You - Out Now

Fri 21 Sep 2018

Repetition Kills You - Out Now

My new Paignton Noir book, REPETITION KILLS YOU, is out now from All Due Respect (an imprint of Down & Out Books)! Here's the synopsis: Repetiti.....Read more

Spine Farm - A Paignton Noir Mystery

Tue 18 Dec 2018

Spine Farm - A Paignton Noir Mystery

Christmas has come early for fans of Paignton Noir – my new e-book SPINE FARM is out now via Amazon! Still coming to terms with the traumatic event.....Read more

Clear Waters Arts Trail

Thu 18 Oct 2018

Clear Waters Arts Trail

For 3 weeks from the end of October you may well see some unusual objects in the shops of Totnes when, from the 29th October to the 19th November, Tot.....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

Help us to keep older people in Devon dancing!

Tue 24 Jul 2018

Help us to keep older people in Devon dancing!

At Dance in Devon, we believe that dance can be for everyone. Life is better when we move together and we are proud that we have been able to make thi.....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

Duologue

Mon 16 Jul 2018

Duologue

"Duologue" Deborah's latest Monoprint is in The Summer Show at the Devon Guild of Craftsmen. Open daily 10-5.30pm until Sunday 2 September 2018...Read more

Oil Painting Workshop in Totnes. Five days in September.

Thu 19 Jul 2018

Oil Painting Workshop in Totnes. Five days in September.

Join me on a five-day workshop to learn how to paint animals in oils. Spaces are extremely limited, so if you are interested, please don't hesitate to.....Read more

Granite Elements Winter Exhibition

Fri 09 Nov 2018

Granite Elements Winter Exhibition

Granite Elements Winter Exhibition at TAAG in Teignmouth Saturday 17 November - Friday 23 November 10 -5 Daily Granite Element Artists, Bridget A.....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

The moral of today

Wed 27 Jun 2018

The moral of today

Do not believe everything you read online or in the letters pages of the local press. In the past few months Brixham Arts & Theatre Society (BATS) .....Read more

/ 1 / 2 / 3 / 4 / 5 /