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%5B%5D=39") 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-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-17", DATEDIFF(`media`.`mediaCreated`, "2019-07-17"), DATEDIFF("2019-07-17", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-17", DATEDIFF(`media`.`mediaUpdated`, "2019-07-17"), DATEDIFF("2019-07-17", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-17", DATEDIFF(`userLastUpdate`, "2019-07-17"), DATEDIFF("2019-07-17", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-24" AND "2019-10-09", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-17", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-17"), DATEDIFF("2019-07-17", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `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-17" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-17", IF(`media`.`mediaDate`>"2019-07-17", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-17", "2018-07-17") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-16", "2019-07-17")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (39) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Torbay / events / Events / Dance / Upcoming / 1 to 14 of 14

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 / Dance / Upcoming / 1 to 14 of 14

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

Spotlight

Sat 20 to Sun 21 Jul 2019 (2 days)

Spotlight

Stuart Stage School present their fifth highly acclaimed annual showcase at the Lawrence Batley Theatre. This show once again features some of the .....Read more

Le Vendredi Danse - 8 February 2019

Fri 08 Feb to Tue 31 Dec 2019 (11 months)

Le Vendredi Danse - 8 February 2019

The February session for lovers of French social dance. Held every second Friday (usually) at Honley Village Hall. Informal, friendly and great fun. T.....Read more

Gandini Juggling: Sigma at Broadway Theatre

Sat 29 Sep 2018 to Sun 29 Sep 2019 (1 year)

Gandini Juggling: Sigma at Broadway Theatre

Sigma is a spectacular new cross art-from production in collaboration with Gandini Juggling and dazzling Bharatanatyam dancer and choreographer Seeta .....Read more

Dancers Wanted

Sat 17 Feb 2018 to Fri 31 Dec 2021 (4 years)

Dancers Wanted

We are looking for dancers to join us. We perform a style of English traditional dance called North West Morris. ALL are welcome whether experience.....Read more

Light Years Adult Dance Class - Hertford

Wed 22 Mar 2017 to Thu 31 Dec 2020 (4 years)

Light Years Adult Dance Class - Hertford

Tim Blowfield studied at Doreen Bird College and London Contemporary Dance School. He performed with AMP (now New Adventures) in Matthew Bourne's "Sw.....Read more

Mon 15 Jan 2018 to Fri 31 Dec 2021 (4 years)

Creative Dance for over 50s

New creative dance class starting for over 50s. Every Monday 1.30-3pm in term time. An opportunity to dance, create, perform, make friends, have fun i.....Read more

A.L.I.C.E In Wanderlust

Fri 30 to Sat 31 Aug 2019 (2 days)

A.L.I.C.E In Wanderlust

We called the mission Wanderlust. No one could have predicted what would come next. Out in the darkness, in the vastness of space and time, what truth.....Read more

Big Fish Little Fish 'Vikings & Dragons' Family Rave

Sun 22 Sep 2019

Big Fish Little Fish 'Vikings & Dragons' Family Rave

Come join raving Valhalla! Award-winning, pioneering Big Fish Little Fish family rave return triumphantly to the Watford Colosseum with a 'Vikings & .....Read more

Tropicana Nights

Sat 28 Sep 2019

Tropicana Nights

Looking for a fun filled evening of fantastic 80s music and dancing? Then look no further… Join us at Tropicana Nights and indulge yourselves in pure .....Read more

Rudolph Rave

Sun 15 Dec 2019

Rudolph Rave

With a DJ, glow sticks, glitter and giant balloons, our family-friendly event brings everyone together for a fun-filled party afternoon, complete with.....Read more

The Rite of Spring & Left Unseen

Tue 15 Oct 2019

The Rite of Spring & Left Unseen

Phoenix Dance Theatre. Phoenix Dance Theatre present a culturally distinctive 21st century re-working of the iconic ballet, The Rite of Spring. For.....Read more

Staging Schiele

Wed 30 Oct 2019

Staging Schiele

Shobana Jeyasingh Dance. Award-winning Shobana Jeyasingh Dance stage a new searing piece inspired by the life and work of artist Egon Shiele. Fo.....Read more

Wasteland

Tue 12 to Wed 13 Nov 2019 (2 days)

Wasteland

Gary Clarke Company. In 1994 hundreds of coal miners hung up their pit boots as Grimethorpe Colliery was destroyed, along with the tight-knit worki.....Read more

Folk Dance and Snowdrop Weekend

Fri 31 Jan to Sun 02 Feb 2020 (3 days)

Folk Dance and Snowdrop Weekend

Based in the medieval village of Dunster, our annual Folk Dance workshop also includes a wonderful excursion out to Exmoor's hidden Snowdrop Valley fo.....Read more