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`, "/")), "?fac%5B%5D=50") 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-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-20", DATEDIFF(`media`.`mediaCreated`, "2019-08-20"), DATEDIFF("2019-08-20", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-20", DATEDIFF(`media`.`mediaUpdated`, "2019-08-20"), DATEDIFF("2019-08-20", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-20", DATEDIFF(`userLastUpdate`, "2019-08-20"), DATEDIFF("2019-08-20", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-28" AND "2019-11-12", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-20", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-20"), DATEDIFF("2019-08-20", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-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`=9 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-20", IF(`media`.`mediaDate`>"2019-08-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-20", "2018-08-20") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-19", "2019-08-20")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (50) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Torbay / listings / creative space agency / Spaces / Toilets / 1 to 15 of 203

Spaces/Resources

 

 

Use this Creative Resource Agency page a as a virtual space for you to trade and barter your expertise, knowledge, skills and resources as well as listing your creative space.

Spaces / Toilets / 1 to 15 of 203

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

2 new spaces at Unit 7 Arts Collective, Coombe Park near Totnes

2 new spaces at Unit 7 Arts Collective, Coombe Park near Totnes

2 Studio Spaces coming up at Unit 7 Arts Collective, Coombe Park, near Totnes. One long space 2.4m x 4.3m with north and south skylights and daylight strip lights £40 pw or half each if shared with a friend. One s.....Read more

The Reclamation Gent Presents The Loft

The Reclamation Gent Presents The Loft

The Reclamation Gent is creating 'The Loft' with Cafe - a 3000 ft Showcase/Retail Space, where local traders will be able to display their creations. We aim to make the space a hub of community and creativity. Ready to g.....Read more

Loft 3, Studio apartment, ideal for living / working

Loft 3, Studio apartment, ideal for living / working

A spacious unfurnished large studio apartment, ideal for office or studio space or professionals for residential or live/work purposes Monthly rental = £687.39 Loft 3 is located on the ground floor of the Grade II .....Read more

Studio/art//workshop/creative/design space to rent. WD3 4NQ

We are delighted to announce that the newly purpose-built Studios at Potten Farm Equestrian are now available. ​ Set in 55 acres of land in the Hertfordshire hamlet of Chandlers Cross. We are developing an attractive.....Read more

Bentley Resource Centre

We have a variety of high quality and affordable spaces available to suit your needs. To discuss your specific needs and find the right office space for you get in touch. We have flexible prices for charities, social e.....Read more

Free work space? Hot desking at The Lounge

Free work space? Hot desking at The Lounge

Need space to work? What if you could kick-start a new venture, without any office overheads. Or work from a second, alternative space, when you need a little more inspiration to nurture your ideas. Come and innova.....Read more

Managed work space within a thriving hub - Available to let

Managed work space within a thriving hub - Available to let

When considering an office, it's much more than four walls. It’s a space to create, collaborate and grow. So, you need to look beyond the bare essentials such as high speed broadband and a great location. Your office.....Read more

The Craft Workshop at The Gallery cafe Honley

The Craft Workshop at The Gallery cafe Honley

Lianne Woodward runs her workshop st The Gallery Cafe Honley. Top floor...Read more

New gallery space at Cockington Court

New gallery space at Cockington Court

Inspiring and Innovative art and craft work needed for new exciting Gallery showcase at Cockington Court Craft Centre to open Easter 2015. Cockington Court is due to open an exciting a visitor welcome point at the fro.....Read more

Contemporary Creative Space for hourly/half or full day rent

Contemporary Creative Space for hourly/half or full day rent

Fantastic Creative Space in stunning surroundings available Sunday -Thursdays 9.30-6pm Ideal for facilitating creative workshops - music, crafts, arts. All ages and abilities welcome. Room has disabled access and to.....Read more

Craft in Devon, The Summerhouse

Craft in Devon, The Summerhouse

Craft in Devon’s dedicated team offer a variety of short art and craft courses in the stunning locations. The summerhouse is a log cabin in the heart of the South Hams hidden in a lovely Devon Coombe overlooking the pond.....Read more

BIG ART EXHIBITION IN TEIGNMOUTH

BIG ART EXHIBITION IN TEIGNMOUTH

An exhibition of affordable Art by local Artists some of which are now collectible. A big selection of original paintings, framed prints, mounted prints, craft, including cushions with limited edition Art Prints on, m.....Read more

workshop space

workshop space

Would you like to support the project and yourself by leading a workshop at the ReStore. We are hiring out our two spaces to creatives to teach craft skills using reclaimed materials which would end up in landfill...Read more

James Sharp, Drum Tutor studio, Totnes.

James Sharp, Drum Tutor studio, Totnes.

Brand new drum tuition studio, with full acoustic treatment & soundproofing. The only truly purpose-built drum tuition studio in South Devon. ..Read more

Main Gallery

Main Gallery

The main gallery benefits from professional hanging system, adjustable lighting and large window display area. With nearly 20m of white wall space to play with and high ceilings, this is a wonderful exhibition space for .....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / / 12 / / 14 /