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`, "/")), "?fac%5B%5D=55") AS `href`,CONCAT("https://", `networkUrl`, "/", `users`.`userSeoName`, "/", IF(`mediatypes`.`mtCode`="profiles", "", CONCAT(`media`.`mediaSeoName`, "/"))) AS `abshref`,CASE WHEN `users`.`userNetwork`=5 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(51.013397))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.106869))+SIN(RADIANS(51.013397))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<100, (IF((3959*ACOS(COS(RADIANS(51.013397))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.106869))+SIN(RADIANS(51.013397))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))))<10, 100, 100-(100/(3959*ACOS(COS(RADIANS(51.013397))*COS(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`)))*COS(RADIANS(IFNULL(`media`.`mediaLongitude`, `userLongitude`))-RADIANS(-3.106869))+SIN(RADIANS(51.013397))*SIN(RADIANS(IFNULL(`media`.`mediaLatitude`, `userLatitude`))))))))*`weightingProximity`, 0))+(IF(`weightingSpecial`>0 AND `userNetwork`=5 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`=5 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-20" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-20", IF(`media`.`mediaDate`>"2019-07-20", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-20", "2018-07-20") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-19", "2019-07-20")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (55) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Somerset / Spaces / Spaces / Load/Unload Area to Hall/Stage / 1 to 15 of 57

Spaces, venues, places and rooms available for use and hire

Check here if you are looking for creative hubs, whether it is studio space, rehearsal or meetings rooms, or even a community space.

At Creative Somerset we encourage opportunities for collaboration, networking and cross sharing ideas and information, so it maybe that you wish to promote a co-working space or hot-desking. After all, ideas don’t come alive until shared.

To list you space, join our network and login to your Member profile, alternatively refer to the User Guides.

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

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 cu.....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 CICCI.....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.....Read more

Shoebox Theatre

Shoebox Theatre

The Shoebox Theatre is a small 50 seat flexible studio space in the heart of Swindon's cultural quarter. The space is managed by Wrong Shoes, who are .....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 .....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 .....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 technica.....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, a.....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.....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 Commun.....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 spaciou.....Read more

New Theatre

New Theatre

The NEW THEATRE is a flexible performance space and will s eat approx 100 people. The playing space is approx 10 mtrs x 7 mtrs New Theatre welcomes.....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/e.....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 stag.....Read more

1 / 2 / 3 / 4 /