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%5B0%5D=8&letter=r") 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-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-20", DATEDIFF(`media`.`mediaCreated`, "2019-07-20"), DATEDIFF("2019-07-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-20", DATEDIFF(`media`.`mediaUpdated`, "2019-07-20"), DATEDIFF("2019-07-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-20", DATEDIFF(`userLastUpdate`, "2019-07-20"), DATEDIFF("2019-07-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-27" AND "2019-10-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-20"), DATEDIFF("2019-07-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `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`=1 AND IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*r" AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (8) GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 15;
Creative Torbay / directory / Profiles / Creative Organisations / R / 1 to 15 of 31

directory

Profiles / Creative Organisations / R / 1 to 15 of 31

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

rachel brown / brown ink graphic designer

rachel brown

brown ink graphic designer

brown ink is a graphic design company located in Somerset. We specialise in custom design for print, the internet and social media..Read more

Rachel Hill

Marketing/Programme Development/Project Management

Communication and Programme Manager at Halsway Manor, National Centre for the Folk Arts...Read more

RammoFilms

Video Production

Hello, We are a Video production company based in Torbay, Southampton and Bournemouth. We're both studying TV Production degree's; Anne-Marie Alexander (see directory) at Southampton Solent Uni and Ryan Biercewicz at Bo.....Read more

Rebecca Morland / Arts Management/consultant

Rebecca Morland

Arts Management/consultant

Working with cultural and community organisations to support them through the provision of additional skills and expertise. Areas of specialism: support for the early stages of capital projects, including feasibility stu.....Read more

RECOVER / 'Up-cycling furniture & lives'

RECOVER

'Up-cycling furniture & lives'

RECOVER is a vibrant, exciting & inspirational furniture up-cycling Social Enterprise with a fabulous artisan workshop / showroom in Welwyn Garden City, Hertfordshire. At it's heart is our commitment to sustainability b.....Read more

Red Brick Building / Arts+Education+Enterprise

Red Brick Building

Arts+Education+Enterprise

The Red Brick Building Centre is a unique community-owned social enterprise set between Glastonbury and Street. We host many events ranging from gigs to workshops and meetings. We have: - desk space for hire for co-wo.....Read more

Red Brick Building / Glastonbury

Red Brick Building

Glastonbury

The Red Brick Building Centre is an innovative project based in the former  Morlands factory building, situated in a prominent position between Glastonbury and Street. It was built in the 1880s by Clark son and Mor.....Read more

REFRAME / Framing Studio

REFRAME

Framing Studio

Based in a fully equipped workshop in Chilgrove, located in the heart of the South Downs near Chichester, we offer a full range of framing and display options including: . A wide selection of frames and mount boards to.....Read more

Revu Photography / Fine Art Dance Photography

Revu Photography

Fine Art Dance Photography

Large professional studio in the heart of Doncaster. Specialising in Fine Art photography for Dancers of all ages...Read more

Richard Jefferies Museum / Richard Jefferies Museum

Richard Jefferies Museum

Richard Jefferies Museum

The Richard Jefferies Museum is set in a beautiful old farmhouse on the edge of Swindon, complete with outhouses, gardens and an orchard, and is dedicated to bringing the wonders of literature, nature and the arts to bot.....Read more

Richard Lalchan / Creatives Hub

Richard Lalchan

Creatives Hub

At Creatives Hub, we aim to get you inspired to ignite your creative life. We’re about helping creatives (whether full or part time) to connect with eachother, to put aside fears, to rid ourselves of the perils of procra.....Read more

Right Up Our Street / Right Up Our Street

Right Up Our Street

Right Up Our Street

Right Up Our Street is all about Doncaster people choosing, making, seeing and sharing brilliant cultural ideas. From poetry to performance, film to radio, sculpture to design, technology to physical activity, we want.....Read more

RISE Studios / Dance and Performing Arts Schools in Watford and Rickmansworth

RISE Studios

Dance and Performing Arts Schools in Watford and Rickmansworth

RISE Studios Dance and Performing Arts Schools in Watford and Rickmansworth, Hertfordshire. Classes take place at St John's Church, Berry Lane and Rickmansworth School, Scots Hill in Ricky and West Herts Squash and Fi.....Read more

ROC CREATIVE

ROC

ROC CREATIVE is a part of the Robert Owen Communities, a registered charity supporting adults with learning disabilities...Read more

Roger M

Mr

I'm responsible for publicity for the Torbay Singers www.torbaysingers.com We are a chamber choir that has been performing in South Devon for over 40 years. Based in Torquay, the group welcomes members from all ov.....Read more

1 / 2 / 3 /