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`, "/")), "?vt%5B%5D=28") 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-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-16", DATEDIFF(`media`.`mediaCreated`, "2019-07-16"), DATEDIFF("2019-07-16", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-16", DATEDIFF(`media`.`mediaUpdated`, "2019-07-16"), DATEDIFF("2019-07-16", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-16", DATEDIFF(`userLastUpdate`, "2019-07-16"), DATEDIFF("2019-07-16", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-23" AND "2019-10-08", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-16", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-16"), DATEDIFF("2019-07-16", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `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-16" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-16", IF(`media`.`mediaDate`>"2019-07-16", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-16", "2018-07-16") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-15", "2019-07-16")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (28) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Somerset / Spaces / Spaces / Club / 1 to 11 of 11

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 / Club / 1 to 11 of 11

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

Bridgwater schools for businesses & community to hire

Bridgwater schools for businesses & community to hire

In Bridgwater there are 3 amazing schools that have been built in the last couple of years: • Chilton Trinity School • Robert Blake Science Colleg.....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 cu.....Read more

The Old Brick Workshop

The Old Brick Workshop

Space for creative industries. I am offering studio spaces in a large building on the edge of Wellington, Somerset. I have up to 9 self contained .....Read more

Okehampton Acoustic Club an ambient space for musicans to perfom

Okehampton Acoustic Club an ambient space for musicans to perfom

Okehampton Acoustic club, a low tech ambient setting for Acoustic Musicians to perform and for members of the audience to sit back,relax or may be ev.....Read more

The River Room, Hertford Theatre

The River Room, Hertford Theatre

There is a selection of spaces available for hire at Hertford Theatre. From receptions and dinners to award ceremonies and workshops, we offer stunni.....Read more

Studio to hire, Hertford Theatre

Studio to hire, Hertford Theatre

Hire this flexible space which is perfect for classes, workshops and breakout sessions. It provides a relaxed environment for day time or evening .....Read more

Auditorium, Hertford Theatre

Auditorium, Hertford Theatre

Auditorium A versatile space with retractable seating ideal for meetings, performances and presentations. With a state-of-the-art sound and li.....Read more

Cafe/Bar at Hertford Theatre

Cafe/Bar at Hertford Theatre

Start your day with a breakfast meeting or networking group in one of our flexible spaces. Fuel those creative juices whilst building that essenti.....Read more

Studio / Room Hire

Studio / Room Hire

We offer meeting room/studio hire for clubs and meetings. Our venue would suit Karate, Judo, Dance, Zumba, Aerobics, Yoga, Fitness and Exercise classe.....Read more

The Huddersfield Ukrainian Club, Edgerton Rd, Hudds HD1 5RA

The Huddersfield Ukrainian Club, Edgerton Rd, Hudds HD1 5RA

A great music venue set in spacious grounds...Read more

Horsefield

Horsefield

We have 3 acres of woods, wildflower meadow, orchard & growing areas bordered by the river Colne and only five minutes walk from Slaithwaite village c.....Read more