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`, "/")), "?disc%5B0%5D=8&view=list&archive=1") 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-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(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`=3 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`))) Creative Torbay / events / Events / Creative Organisations / Archive / 1 to 15 of 1187

What's On

Top search tips:

Narrow down your search by using Choose by Age or Postcode Search from the left hand menu.

Or to find an event near you select map view.

Creative Torbay advises that you check with the event organiser(s) prior to attending any event for any last minute changes or ticket information.

Events / Creative Organisations / Archive / 1 to 15 of 1187

Upcoming / Today / Jul / Aug / Sep / Oct / Nov / Dec / Jan / Feb / Mar / Apr / May / Jun / Archive

BMN meets Psychotherapy Sussex: Art, Longing & Desire

Thu 18 Jul 2019

BMN meets Psychotherapy Sussex: Art, Longing & Desire

Blue Monkey Network member Mandy Wax takes the reins at our monthly event for July. A practicing psychotherapist and member of Psychotherapy Sussex, s.....Read more

2 Part Beginners Crochet Course (July)

Thu 04 to Thu 18 Jul 2019 (2 weeks)

2 Part Beginners Crochet Course (July)

We have teamed up with Denise Burrows from The Natural Yarn Barn to bring you a series of new crochet workshops, from beginners to those wanting to im.....Read more

Silk Painting | Celebrating Age

Thu 27 Jun to Thu 18 Jul 2019 (3 weeks)

Silk Painting | Celebrating Age

Join members of Holme Valley Sharing Memories, for 4 creative sessions where we'll make a series of silk wall hangings. Experiment and play with di.....Read more

Philippe Gaulier Workshop

Mon 08 to Wed 17 Jul 2019 (1 week)

Philippe Gaulier Workshop

He’s coming back! -and this time for 2 weeks. Small Nose are really excited to announce that Philippe Gaulier will be running two weeks of workshop.....Read more

Craftanoon

Thu 02 May to Thu 18 Jul 2019 (3 months)

Craftanoon

Craftanoon is our relaxed afternoon of crafting - it's a time to try out craft skills and create your own handmade uniques pieces. Each term, we cove.....Read more

Fused Glass - Monday Evening class

Tue 30 Apr to Thu 18 Jul 2019 (3 months)

Fused Glass - Monday Evening class

Learn the basic techniques of fused glass making, or develop your skills further in our term time day and evening class - perfect to experiment and c.....Read more

Crochet Baskets

Sun 14 Jul 2019

Crochet Baskets

This class is the ideal follow-on to the Taster and Learn to Crochet Beginners workshops or for anyone who would like to learn a new technique – it is.....Read more

Saturday Art Club - kids only!

Sat 04 May to Mon 15 Jul 2019 (2 months)

Saturday Art Club - kids only!

Weekly, term-time art club for children 6 to 14 years. We run term time, developing technical art and craft skills, each half term is theme - we've j.....Read more

Lunchtime Talks with Tricia Thompson

Thu 11 Jul 2019

Lunchtime Talks with Tricia Thompson

Four British Composers Arnold Bax, Benjamin Britten, Frederick Delius, John Ireland The talk begins with a substantial buffet lunch (please info.....Read more

'Playing with Writing'  -  Creative Writing Workshop

Wed 10 Jul 2019

'Playing with Writing' - Creative Writing Workshop

Following the success of our first workshop at Miriam's, The Curious Creative Club has a new date coming up for our 'Playing with Writing' Workshop, w.....Read more

Mental Health Awareness Training

Mon 08 Jul 2019

Mental Health Awareness Training

What is mental health and how does it link to physical health? This course will help you to: Spot the signs and symptoms of ill mental health. Res.....Read more

Pottery Skills - Cactus Vase Workshop

Sun 07 Jul 2019

Pottery Skills - Cactus Vase Workshop

A new selection of one off pottery workshops designed to cover different skills whilst making something really nice for your home! Our first is thi.....Read more

Frida Kahlo Portrait Painting Workshop

Sun 07 Jul 2019

Frida Kahlo Portrait Painting Workshop

How about an evening of fun 'me time' with a friendly and relaxed tutor? Join us at CLP's base in South Oxhey for a spot of TLC with a difference. Fr.....Read more

Upcycling T-Shirt to Tote Bag

Thu 04 Jul 2019

Upcycling T-Shirt to Tote Bag

A fun workshop transforming the humble T- Shirt into a Tote bag. Other upcycling ideas available on the day. It’s a drop in workshop between 10-12noon.....Read more

The Art of Traditional Canalware / Painting on Pottery

Sun 30 Jun 2019

The Art of Traditional Canalware / Painting on Pottery

With over 25 years' of experience, Julia Power will teach you how to produce a beautifully painted object to be admired by all. There are so many w.....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / / 15 / / 20 / / 30 / / 40 / / 50 / / 60 / / 70 / / 80 /