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

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 / Festivals / Upcoming / 1 to 12 of 12

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

Marshfest 2019 ...Huddersfield's biggest charity music festival

Fri 19 to Sat 20 Jul 2019 (2 days)

Marshfest 2019 ...Huddersfield's biggest charity music festival

Marsh Blues Club in association with The Welcome Centre proudly presents Marshfest 2019, July 19th - 20th. This family friendly music festival is h.....Read more

Marshfest 2019 ...Huddersfield's biggest charity music festival

Fri 19 to Sat 20 Jul 2019 (2 days)

Marshfest 2019 ...Huddersfield's biggest charity music festival

Marsh Blues Club in association with The Welcome Centre proudly presents Marshfest 2019, July 19th - 20th. This family friendly music festival is h.....Read more

Watford Short Film Festival 2019

Sat 27 to Sun 28 Jul 2019 (2 days)

Watford Short Film Festival 2019

Watford Short Film festival is an exciting new opportunity for undiscovered film-makers across the UK and beyond to showcase their work. Open to a.....Read more

Kirklees College Free Family Fun Day

Wed 07 Aug 2019

Kirklees College Free Family Fun Day

Join us on Wednesday the 7th August for our Family Summer Spectacular Fun Day in partnership with Yorkshire Children's Centre. There will be informati.....Read more

Music Holiday Week in Dunster

Sun 11 to Sun 18 Aug 2019 (1 week)

Music Holiday Week in Dunster

Music Holiday Week is held at the Yarn Market Hotel in Dunster, and offers a 7 night package workshop for singers and musicians. The repertoire for.....Read more

Fun in the Park- Borehamwood

Wed 21 Aug 2019

Fun in the Park- Borehamwood

This years Fun in the Parks is bringing you the BRAND NEW Bubble Party!! along with our classic inflatables and wonderful Magic Show. The perfect cha.....Read more

Fun in the Park- Potters Bar

Thu 22 Aug 2019

Fun in the Park- Potters Bar

This years Fun in the Parks is bringing you the BRAND NEW Bubble Party!! along with our classic inflatables and wonderful Magic Show. The perfect cha.....Read more

Fun in the Park- Bushey

Fri 23 Aug 2019

Fun in the Park- Bushey

This years Fun in the Parks is bringing you the BRAND NEW Bubble Party!! along with our classic inflatables and wonderful Magic Show. The perfect cha.....Read more

The 4th World Congress of Psychogeography

Fri 06 to Sun 08 Sep 2019 (3 days)

The 4th World Congress of Psychogeography

The 4th World Congress of Psychogeography in 2019 brings together people from all walks of life to Kirklees this autumn. With a mix of walks, talks an.....Read more

&Piano 2019 Event 1 - An Afternoon of Musical Theatre

Sun 08 Sep 2019

&Piano 2019 Event 1 - An Afternoon of Musical Theatre

&Piano is back for another season, celebrating and guiding you through music you may know, and may not! We begin &Piano again with another relaxed aft.....Read more

Ashton Lad: Victorian 'Hidden' Muslim

Sat 21 Sep 2019

Ashton Lad: Victorian 'Hidden' Muslim

Robert Stanley was a respectable, northern working-class Victorian man who converted to Islam. But his family managed to keep his Muslim identity a .....Read more

hcmf// 2019

Fri 15 to Sun 24 Nov 2019 (1 week)

hcmf// 2019

The UK’s largest international festival of new and experimental music will return for its 42nd year, running from Friday 15 - Sunday 24 November 2019......Read more