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

directory

Profiles / 1 to 15 of 1508

Show All / A / B / C / D / E / F / G / H / I / J / K / L / M / N / O / P / Q / R / S / T / U / V / W / X / Y / Z

Doorstep Arts / Participation/Music/Theatre

Doorstep Arts

Participation/Music/Theatre

Doorstep Arts is a non-profit arts education organisation based in Torbay. We run 14 drama groups across Torbay at key doorstep sites – youth clubs, church halls and schools. We are also the creative education company in.....Read more

Christmas By The Sea / 2016

Christmas By The Sea

2016

With FREE events throughout the festive period… you can see, hear, feel and create Christmas. Starting with the Christmas Carnival on Saturday 19th November there will be activities and art throughout the town, with .....Read more

Brixham College Creative & Media

Brixham College Creative & Media

In Development..Read more

Devon Open Studios / Devon Open Studios

Devon Open Studios

Devon Open Studios

Devon Open Studios takes place for two weeks in early September at venues across the county. Participating artists and makers can choose to open for the whole event or selected days of their own choosing. Devon Open .....Read more

Upcycle-Devon / Aboutus

Upcycle-Devon

Aboutus

A service catered and inspired by you Turning preloved materials and turning them into quirky, innovative pieces to be proud of. We will work with what you have to reduce, reuse and repurpose materials that would o.....Read more

Beyond The Beach / The Secret Wild Swims of Torbay

Beyond The Beach

The Secret Wild Swims of Torbay

Beyond the Beach: The Secret wild Swims of Torbay Matt Newbury and Sophie Pierce share Britain's best kept swimming secret: the coastlines of Torquay, Brixham and Paignton in Devon. Featuring stunning pictures by aw.....Read more

Groupon / Safety Guide to Attending Events with a Disability

Groupon

Safety Guide to Attending Events with a Disability

Groupon is an American worldwide e-commerce marketplace connecting subscribers with local merchants by offering activities, travel, goods and services in 15 countries. They created this practical guide called "The Def.....Read more

Torre Abbey Museum

Museum, Historic House, Gallery, Garden and Cafe

Est. in 1196, Torre Abbey is a museum of history and art housed in an Ancient Scheduled Monument on the iconic South Devon coast. Based in Torquay, this family friendly museum is a centre for creativity and curiosity.....Read more

Green Hill Arts & Heritage / Green Hill Arts Centre

Green Hill Arts & Heritage

Green Hill Arts Centre

Green Hill Arts is a contemporary award-winning art gallery on the edge of Dartmoor in Moretonhampstead. It has been acquiring a reputation as a serious innovative gallery and a vibrant experimental community space. T.....Read more

Gareth Ballyn / Independent Curator

Gareth Ballyn

Independent Curator

Independent curator working in Torbay, South Hams and Plymouth. Specialising in collaborative work with contemporary visual artists and also in schools...Read more

Sophie Atherton / Freelance Journalist, PR Consultant & Beer Sommelier

Sophie Atherton

Freelance Journalist, PR Consultant & Beer Sommelier

I am a freelance journalist with almost 15 years experience of working in newspapers, PR and radio. I'm available for all sorts of commissions, big or small, national or regional and I also take on other writing jobs suc.....Read more

Martin / Creative Beings CIC

Martin

Creative Beings CIC

Creative Beings CIC: drawing from nature to reconnect with self, community and planet. Creative Beings is an inspiring creative hub in East Devon where we can be curious & connect, learn & laugh, explore & express...Read more

Creative Junction

About us

Creative Junction aims to be a point at which ideas come together, explosions occur and new turns are taken. We build partnerships with and for young people, to develop creativity and to connect powerful, innovative lear.....Read more

Christian Parkes

Visionary Artist

Christian Parkes is an emerging artist having first exhibited in 2006. He was born in Torbay, Devon and the power and beauty of the south west continues to inspire him. Christian has always been touched with the creat.....Read more

Viera Portrait Photography

Viera Portrait Photography

Viera Photography is a New friendly Portrait Studio with Free Parking, Coffee or Tea situated in the beautiful Torbay Devon, Rew Hotels Resort. Viera Portrait Photography is run by three Professional Local Photographers.....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / / 11 / / 21 / / 31 / / 41 / / 51 / / 61 / / 71 / / 101 /