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=77") 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-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-24", DATEDIFF(`media`.`mediaCreated`, "2019-06-24"), DATEDIFF("2019-06-24", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-24", DATEDIFF(`media`.`mediaUpdated`, "2019-06-24"), DATEDIFF("2019-06-24", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-24", DATEDIFF(`userLastUpdate`, "2019-06-24"), DATEDIFF("2019-06-24", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-01" AND "2019-09-16", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-24", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-24"), DATEDIFF("2019-06-24", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `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-06-24" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-24", IF(`media`.`mediaDate`>"2019-06-24", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-24", "2018-06-24") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-23", "2019-06-24")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (77) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Torbay / listings / creative space agency / Spaces / Fire alarm/Extinguishers / 1 to 15 of 142

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 / Fire alarm/Extinguishers / 1 to 15 of 142

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

Art Parties & Private Workshops

Art Parties & Private Workshops

Enjoy exclusive use of our Studio space, along with an art or craft activity of your choice. Suitable for children, teens, adults and groups. A great opportunity for friends and family to get together and create toge.....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

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

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

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

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

Occombe Farm Event Space

Occombe Farm Event Space

Occombe Farm are delighted to offer our café and farmyard for all kinds of events! The café has been recently refurbished with an outdoor balcony overlooking the farmyard. The yard has been recently concreted to make the.....Read more

Soundart Radio 102.5fm

Soundart Radio 102.5fm

Our door is open to all at our low key, relaxed broadcast studio. We are based on the Dartington Estate and often make use of the beautiful studio spaces and the grounds to hold events and workshops. We also use Totn.....Read more

Gallery space at the Blue Walnut Cafe

Gallery space at the Blue Walnut Cafe

Each month we display and sell artwork from a chosen local artist. The Cafe is clean and well lit with magnolia walls, a professional hanging system and space for up to 10 pieces. The Cafe is open to the public 6 days .....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

Rear Gallery

Rear Gallery

The Rear Gallery (previously Café Gallery) was recently converted. The small coffee bar still features in the corner and attracts a number of visitors for drinks throughout the day. As with the Main Gallery the space ben.....Read more

Artizan Gallery Events Venue

Artizan Gallery Events Venue

Artizan's exhibitions make it an attractive location for events and performances, and is available for evening hire. From music, to meetings, to formal functions, the gallery and café provide the necessary facilities for.....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

Agatha's Closet : A place for all things needlecraft.

Agatha's Closet : A place for all things needlecraft.

Agatha's Closet have opened a new space at 45 Hyde Road, Paignton, Devon. As a fashion and needlecraft project we needed a space that allowed us to develop a retail arm as well as spaces for workshops and events. .....Read more

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