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`, "/")), "?disc%5B0%5D=14&page=7") 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-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-19", DATEDIFF(`media`.`mediaCreated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-19", DATEDIFF(`media`.`mediaUpdated`, "2019-07-19"), DATEDIFF("2019-07-19", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-19", DATEDIFF(`userLastUpdate`, "2019-07-19"), DATEDIFF("2019-07-19", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-26" AND "2019-10-11", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-19", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-19"), DATEDIFF("2019-07-19", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `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`=1 AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-19", IF(`media`.`mediaDate`>"2019-07-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-19", "2018-07-19") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-18", "2019-07-19")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (14) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 90, 15;
Creative Torbay / directory / Profiles / Performing Arts / 91 to 105 of 753

directory

Profiles / Performing Arts / 91 to 105 of 753

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

Hannahlclark

Hannah Cosgrave nee Lindsey-Clark

A flautist based in Plymouth..Read more

Katerina

Katerina - professional belly dancer and dance teacher

Dancer Katerina discovered the benefits of belly dancing some 18 years ago and became totally addicted to this unique form of self expression. Katerina began dancing at the age of five and attended the Jason School of D.....Read more

Lucy Lepchani

poet, writer, educator

I am a versatile writer and engage wholeheartedly in a range of genres and styles. I am available for commissions, readings and performances, to design and run workshops, and to work collaboratively with other individual.....Read more

Brixham Arts & Theatre Society / Brixham Arts & Theatre Society

Brixham Arts & Theatre Society

Brixham Arts & Theatre Society

The Friends of Brixham Theatre was formed in 2008 by a group of like minded individuals who were concerned that Brixham Theatre was under-used and was falling into disrepair. This group later re-named itself as Brixham A.....Read more

Steve Banks

Musician, composer, teacher

I play violin – classical and folk, drums and sing with the Carnival Band (www.carnivalband.com – music in the spirit of carnival from across the centuries and across the globe) and celtic folk band Chanter (www.chanter......Read more

Sandra Smith / Singing teacher/ choir coach and Director of The Lost Sound

Sandra Smith

Singing teacher/ choir coach and Director of The Lost Sound

NEW SINGING WORKSHOPS FOR 2016 AIMED AT SINGERS WITH SOME HARMONY SINGING EXPERIENCE WHO WANT TO IMPROVE THEIR OWN SINGING AND CHOIR SKILLS Sandra on 01364 643105 for more info or www.thelostsoundchorus.co.uk..Read more

Danielle Rose / Live Arts Producer

Danielle Rose

Live Arts Producer

• Live Arts Producer • 10 years’ experience of working in arts organisations • Key skills – artistic programming, project management, communication, and artist liaison LinkedIn: http://uk.linkedin.com/pub/danielle-.....Read more

JJ's Arts Academy / JJ's Music School

JJ's Arts Academy

JJ's Music School

‘ Welcome to JJ’s Arts Academy! Previously known as JJ's Music School set up in September 2006 before its relaunch in January 2015 to JJ's Arts Academy. For many, this will be the start of your musical journey. This can .....Read more

Neil Maya

The Neil Maya Quartet

The Neil Maya Quartet is one of the Southwest’s most exciting and talented bands, whose aim is to find fresh, new sounds within the wide scope of jazz whilst staying accessible to the public at large. As well as playing .....Read more

Lush Life

Lush Life Dinner Jazz

LUSH LIFE play the perfect background music for meals and drinks receptions, but can also play a more prominent role if required. This saxophone led group play a sophisticated selection of jazz and swing standards made f.....Read more

POETSfriday / POETSfriday

POETSfriday

POETSfriday

POETSfriday (formally of Cockington Court) has a new venue! POETSfriday in 2019 will take place at the Little Theatre, St Mark's Road, Torquay TQ1 2EL All poets and poetry lovers are welcome £3 to include afternoon .....Read more

Music with Mummy / Jolly Babies

Music with Mummy

Jolly Babies

Hi to all parents, grandparents, and other carers of babies and young children! My name is Carol Holbrow, I am an experienced early year's practitioner and I run MUSIC with MUMMY classes in our area for babies aged from.....Read more

Shiphay Amateur Dramatic Society / Shiphay Amateur Dramatic Society

Shiphay Amateur Dramatic Society

Shiphay Amateur Dramatic Society

Please find SADS via web search..Read more

The Drat Pack

The Drat Pack

Ladies & Gentlemen we proudly present the coolest band in the land: THE DRAT PACK, performing many of the greatest swing numbers of all time. If you want that classic swing thing made famous by Frank Sinatra, Dean Martin.....Read more

Laura Jury / Laura (actress, sword dancer, drama teacher, writer)

Laura Jury

Laura (actress, sword dancer, drama teacher, writer)

I am a 31 year old, a writer, performer and general creative, as well as being a co-founder of the South Devon Players community theatre company, from Brixham in Southwest England (Devon). I also work as an actress,.....Read more

/ 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10 / 11 / / 21 / / 51 /