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`, "/")), "?network%5B0%5D=1&page=32") 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-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-21", DATEDIFF(`media`.`mediaCreated`, "2019-08-21"), DATEDIFF("2019-08-21", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-21", DATEDIFF(`media`.`mediaUpdated`, "2019-08-21"), DATEDIFF("2019-08-21", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-21", DATEDIFF(`userLastUpdate`, "2019-08-21"), DATEDIFF("2019-08-21", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-29" AND "2019-11-13", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-21", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-21"), DATEDIFF("2019-08-21", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `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` 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 `userNetwork` IN (1) AND IF(`mediatypes`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-21", IF(`media`.`mediaDate`>"2019-08-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-21", "2018-08-21") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-20", "2019-08-21")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 465, 15;
Creative Torbay / directory / Profiles / 466 to 480 of 1511

directory

Profiles / 466 to 480 of 1511

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

Sarah Bagnall

Photographer- Little Photographics

Summertime Spectacular photos are ready! 140 Images available. If you would like a disc of the show please e mail me to order one at £9 I have worked as a Portrait Photographer aboard Holland America Cruise Liners. Curre.....Read more

Jackie Juno

Jackie Juno

Stand-up poet, comedian, singer with The Invisible Opera Company of Tibet; also artist and radio presenter. I organise and compere HOOT! Cabarets in various venues in Devon, so am always looking for new acts to entertain.....Read more

Jess Tucker

Jess Tucker

I have loved to paint and draw for as long as I can remember. I graduated from the University of Plymouth in 2003 with a degree in Design: Illustration and have since produced a variety of commissions. I prefer painting .....Read more

Sharyn Baker / Drawing and Applied Arts

Sharyn Baker

Drawing and Applied Arts

I am a BA(Hons) in Drawing and Applied Arts graduate. I live and work in Torbay. I work a lot with drawing and mixed media, basically using whatever I have at hand. My studies led me into a world of altered books whi.....Read more

jo

Jo Thompson

I am an artist who works and lives in the Teignmouth area. I paint landscapes and portraits in mixed media. Love them both equally my website is : www.funkyportrait.com for even more information. I try to convey the feel.....Read more

Graham Gilbert / PhotographicArt

Graham Gilbert

PhotographicArt

Abstract photographs - Unusual images from the natural world........... The natural world is full of surprises and discovering them is only limited by our powers of observation. There is so much more to see than meets.....Read more

Sara Gilbert / Sara Gilbert, painter and print-maker

Sara Gilbert

Sara Gilbert, painter and print-maker

I completed an honours degree in Fine Art as a mature student at Plymouth College of Art & Design (PCAD) in 2007. My work is often described as “energetic and dynamic”. Inspiration comes from my love of the natural la.....Read more

Samba Jam

Samba Jam

Brazil has come to Brixham! Come and join Brixham's very own Samba band. Beginners and experienced welcome. We provide the instruments, you provide the rhythm. Every Monday night at the Edge, Bolton Street, Brixham.....Read more

Janet Sainsbury / Janet Sainsbury visual artist

Janet Sainsbury

Janet Sainsbury visual artist

Painter, printmaker and collage artist...Read more

Louise Bougourd

LOUISE BOUGOURD - Watercolourist/ mixed media

I am inspired by the constantly changing light in the Devon countryside finding inspiration in the most simple of scenes; I find myself excited by reflections and shadow leading to a range of interpretations. I paint in .....Read more

Brixham Society of Art

Brixham society of Art

Brixham Art Society is run by volunteers. The committee is elected by the members. President -Peter Lawrence Chairman - Edward Lovesey Vice Chairman -Treasurer - Sue Harding Membership Sec. - Sue HArding Correspon.....Read more

Mike Atkinson / Cartoonist, illustrator and Satirist ATKINSONFUNNYBIZ

Mike Atkinson

Cartoonist, illustrator and Satirist ATKINSONFUNNYBIZ

Mike finds FUNNY BUSINESS everywhere to cartoon and satirise. He mocks hypocrisy amongst 'Green Collar Workers' and backbiting by political and media luvvies. Gentler fun is poked in his comic strips and corporate .....Read more

Barrie Threadgold

Professional Artist

Originally from London with many years trained experience in all aspects of illustration. I now specialise in realistic commissions for that special person or pet, retaining their individual expression and personality. .....Read more

Hannahlclark

Hannah Cosgrave nee Lindsey-Clark

A flautist based in Plymouth..Read more

Cathie Hewitt

Cathie Hewitt ..... Photography

I am a keen amateur photographer living in Paignton. I enjoy taking macro shots of flora and fauna, as well as capturing images from an unusual angle. I also like to take children's portraits, but in a natural environmen.....Read more

/ 1 / / 20 / / 28 / 29 / 30 / 31 / 32 / 33 / 34 / 35 / 36 / / 51 / / 101 /