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=10") 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 (10) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Torbay / events / Events / Other / Upcoming / 1 to 15 of 80

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 / Other / Upcoming / 1 to 15 of 80

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

Event for volunteer-involving organisations

Thu 18 Jul 2019

Event for volunteer-involving organisations

TeamHerts Volunteering, a countywide project which aims to give information and guidance on volunteering in Hertfordshire, is running a consultation .....Read more

Writing: Making Your Mark Batley

Thu 11 to Tue 30 Jul 2019 (3 weeks)

Writing: Making Your Mark Batley

Our Writing: Making Your Mark exhibition draws on the themes of a new British Library exhibition, which spans five millennia and five continents, to d.....Read more

Edinburgh Festival Fringe Previews

Thu 04 to Thu 25 Jul 2019 (3 weeks)

Edinburgh Festival Fringe Previews

Join us for a double helping of hilarity this July with two Edinburgh Festival Fringe Comedy Cellar specials! THURSDAY 4 JULY PAUL SINHA As seen .....Read more

Monster Joe - Small Seeds, Huddersfield

Fri 19 Jul 2019

Monster Joe - Small Seeds, Huddersfield

'Friday Night Jive' presents Monster Joe 19th July, 2019 - Small Seeds, Huddersfield Free entry All singing, some dancing. Looped violin, Latin-.....Read more

Flight: Circlesongs and Improvisation

Tue 16 Jul to Tue 27 Aug 2019 (1 month)

Flight: Circlesongs and Improvisation

These sessions are inspired by the work Jess has been doing with international teachers Bobby McFerrin and Rhiannon. The sessions will be exploring lo.....Read more

Tall Tales | Music, Comedy & Poetry for older adults

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

Tall Tales | Music, Comedy & Poetry for older adults

Join us at Tall Tales for tea & happy chatting. A variety mix of music, comedy, poetry, music hall and our mystery tour box. Come along to play, be.....Read more

Guided Tours

Sun 19 May to Sun 18 Aug 2019 (3 months)

Guided Tours

Join our volunteer guides for a fascinating tour of Tolson Museum, where you will discover more about the people who once lived and worked here. Tours.....Read more

Beer, Brass & BBQ with Hepworth Band

Sun 21 Jul 2019

Beer, Brass & BBQ with Hepworth Band

Bring your deckchairs and picnic blankets and join the Hepworth Brass Band for summer beers, brass & BBQ at Hepworth United Sports Club, Far Lane, Hep.....Read more

Summer Explorers Pack

Sat 20 Jul to Sun 01 Sep 2019 (1 month)

Summer Explorers Pack

Pick up your seasonal explorer pack from the shop to start your adventure. Add new activities to your pack each week that you visit both Bagshaw Museu.....Read more

Around the World Trail

Sat 20 Jul to Sun 01 Sep 2019 (1 month)

Around the World Trail

Collect stamps for your trail passport as you search for the hidden objects in the museum from all six continents! This is a free event, no booking.....Read more

Summer Explorers Trail

Sat 20 Jul to Sun 01 Sep 2019 (1 month)

Summer Explorers Trail

Pick up your seasonal explorer pack from the Visitor Centre Shop to start your adventure. Add new activities to your pack each week that you visit bot.....Read more

Tea & Cake with 'Friends of Tolson & Ravensknowle'

Wed 08 May to Wed 11 Sep 2019 (4 months)

Tea & Cake with 'Friends of Tolson & Ravensknowle'

On the second Wednesday of each month come an join our friendly groups at Tolson Museum for Tea and Cake! 2pm - 3:30pm 8 May: The British Red Cr.....Read more

Sound Events @ the LBT / Jul 2019

Tue 23 Jul 2019

Sound Events @ the LBT / Jul 2019

Come and join Inclusive Sound Events for free improvised music - all instruments and abilities welcome. Sound Events is a regular (every month or s.....Read more

FoWP Butterfly House

Thu 18 Apr to Thu 31 Oct 2019 (6 months)

FoWP Butterfly House

Fridays to Mondays until 31 October. 10am-4pm. Recently re-opened and run by the Friends of Wilton park. Why not call in and try you hand at becom.....Read more

Development of the Comet

Wed 24 Jul 2019

Development of the Comet

Development of the Comet The world's first Jet Airliner A talk by Alistair Hodgson, curator of the de Havilland Museum Wednesday 24th July 7......Read more

1 / 2 / 3 / 4 / 5 / 6 /