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=55") 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-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-19", DATEDIFF(`media`.`mediaCreated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-19", DATEDIFF(`media`.`mediaUpdated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-19", DATEDIFF(`userLastUpdate`, "2019-07-19"), DATEDIFF("2019-07-19", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-19", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-19"), DATEDIFF("2019-07-19", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `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-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-19", "2018-07-19") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-18", "2019-07-19")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (55) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Torbay / listings / creative space agency / Spaces / Load/Unload Area to Hall/Stage / 1 to 15 of 57

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 / Load/Unload Area to Hall/Stage / 1 to 15 of 57

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

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

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

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

Hannahs

Hannahs

Hannahs Seale-Hayne is a creative community space. A passion infused social enterpise which creates inspring opportunities for all abilities. With a host of incredible on-site facitlities from Live Music Venue, Music.....Read more

Space - Studios & Rehearsal Spaces

Rehearsal & Performance Studios to Hire Call 01803 847147 to book We have a wide range of studios available for hire for your work. For technical specifications for each studio click on the links below. Rates shown.....Read more

Space for Artists and Makers at Unit 7 Coombe Park near Totnes

Space for Artists and Makers at Unit 7 Coombe Park near Totnes

Coombe Park is a mixed Art and Craft rural centre in a pleasant location 2 miles from Totnes. Unit 7 Arts Collective have spaces available to let to artists and makers, we also have a nice bright gallery area that is op.....Read more

Merlin Theatre

Merlin Theatre

Built in 1974, The Merlin Theatre has a 240-seat auditorium with a smaller, outdoor, amphitheatre (ECOS) and is situated on the campus of Frome Community College. We programme theatre, dance, comedy, live literature .....Read more

Minehead EYE Exhibition Space

Minehead EYE Exhibition Space

Do you need somewhere to display your artwork? Looking for an exhibition space with a difference? Why not try Minehead EYE. We have loads of wall/exhibition space in our cafe and around the centre. Give Molly a call .....Read more

Minehead EYE Music Venue

Minehead EYE Music Venue

Minehead EYE is a great location for music gigs or performances. The main hall can be reconfigured to provide a 300 capacity venue complete with stage, lighting and PA connections. The cafe area provides a more intimat.....Read more

Creative Innovation Centre Taunton

Creative Innovation Centre Taunton

About Our Venue at CICCIC Creative Innovation Centre is a creative open space for activities around the development of enterprise, community and culture. Situated in the centre of Taunton and built in the 1800′s our .....Read more

CICCIC Cafe and Gallery Open 9.30-4pm Taunton

CICCIC Cafe and Gallery Open 9.30-4pm Taunton

Soft Launch of CICCIC Daytime Cafe We are pleased to announce that we are open during the day for coffee, tea, hot chocolate, paninis, cakes at CICCIC, and what a great place to relax and enjoy a cuppa with our amazing .....Read more

Top Studio

Top Studio

The top studio is our premium space. We have an area large enough to accommodate up to 25 people for seated conferences or presentations. For movement workshops, there is space for 15 people. Our free Wifi service is als.....Read more

Netherhay Chapel

Netherhay Chapel

This restored chapel is a beautiful and adaptable space, ideal for a variety of uses. It has good acoustics for musicians, and the excellent light makes it well suited for exhibitions and workshops. The community room ha.....Read more

Woodhayes Gallery

The innovative conversion of a traditional Steel Dutch Barn has preserved an example of 1930’s agricultural farm heritage. Woodhayes Art Gallery offers 125 m2 / 1345 sq ft of exhibition space and 200m2 /2150 sq ft of pi.....Read more

Rehearsal Studio and Workshop Space to Hire

Rehearsal Studio and Workshop Space to Hire

Emmanuel Hall Rehearsal Studios, based in Exeter, are available for hire to performing arts organisations and artists. Rehearsal Studio: A spacious and bright room with a high ceiling. Design Workshop: A well lit.....Read more

1 / 2 / 3 / 4 /