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`, "/")), "?letter=v&view=list&page=4") 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 IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*v" GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 45, 15;
Creative Torbay / directory / Profiles / V / 46 to 60 of 71

directory

Profiles / V / 46 to 60 of 71

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

Villages in Action

Villages in Action

COMMUNITY DEVELOPMENT THROUGH THE ARTS Villages in Action (VIA) is a rural touring scheme based in Crediton, Devon that covers five of the rural Districts of Devon. We help to bring top quality professional performances.....Read more

Vims / 1

Vims

1

I am a freelance artist and therapist. My training is in Graphic Design and Humanistic Counselling among many others. My creative process has been varied, like my art...Read more

Vincent Accounting / Vicki Vincent MAAT

Vincent Accounting

Vicki Vincent MAAT

Vincent Accounting provides Bookkeeping and Accountancy services for the Creative Industry, Small Businesses and Not for Profit Sector. Business owner, Vicki possess a unique mix of skills and "breaks the mould" of th.....Read more

Vineyard and Mud Hut for Events / Land to Hire for workshops /events

Vineyard and Mud Hut for Events

Land to Hire for workshops /events

We have 2 adjoining pieces of land near to Broxbourne woods available for hire. As you will see from the pictures, the vineyard land and mud hut is in it's early stages of development. We hope to increase our events and.....Read more

Vintage and Craft Fair / Vintage and Craft Fair

Vintage and Craft Fair

Vintage and Craft Fair

Our very successful Vintage and Craft Market, held at Rotherfield Village Hall, has been running for almost one year with more and more interest shown from stall holders and our lovely visitors each time our market is on.....Read more

Vintage Mobile Cinema / Vintage Mobile Cinema

Vintage Mobile Cinema

Vintage Mobile Cinema

The Vintage Mobile Cinema is a unique slice of cinema and automotive history, which combines to give the audience an exciting film viewing experience unavailable anywhere else. The 22 seat movie theatre is in the soun.....Read more

vinylimpression / Profile

vinylimpression

Profile

We are a Wall Sticker business based in East Grinstead, West Sussex. We provide brilliant stickers for all ages from babies to adults, for families to businesses. We see blank walls as canvas's with the potential to beco.....Read more

VinylTap / VinylTapLive

VinylTap

VinylTapLive

Vinyl Tap has been in the business of selling music for over twenty years now and in that period have supplied many thousands of collectors around the globe via our website, and now with a large store in Huddersfield Tow.....Read more

VIRSA / HARDEEP SAHOTA

VIRSA

HARDEEP SAHOTA

Hardeep Singh Sahota is a leading authority on Bhangra, and has been one of the prominent forces in the UK delivering high quality Bhangra workshops, lectures and seminars over the last two decades. As a secondary school.....Read more

visartphoto / Visart

visartphoto

Visart

Photographer Andy Sears LSINWP specialising in garden and small product photography. Based in the village of Graveley, Nr Hitchin, Hertfordshire. While garden photography has been my main interest, I have slowly start.....Read more

visionarydictionary.com

visionarydictionary.com - More than just words.

New user generated content site discusses the future. Visionary Dictionary allows people to comment on events as they happen today or that they believe will happen in the future. Users can create discussions and polls .....Read more

Visit Doncaster / Events, Attractions and Accomodation

Visit Doncaster

Events, Attractions and Accomodation

The friendly home of events, attractions & accommodation in Doncaster for residents, visitors, students & business trips, discover what we have on offer!..Read more

Visit South Devon TV / Promoting tourism in Torbay, Teignbridge & South Hams

Visit South Devon TV

Promoting tourism in Torbay, Teignbridge & South Hams

Web based TV channel to support tourism in Torbay, Teignbridge & South Hams. Providing a visual guide for people visiting South Devon, contains short films of events, places to visit, things to do, attractions and activ.....Read more

ViSTA / ViSTA

ViSTA

ViSTA

ViSTA is a learning and development charity working with individuals, communities and organisations to deliver learning opportunities, volunteer programmes and workforce development training...Read more

Visual Statements / Artist

Visual Statements

Artist

Robert Heap-Hammond is the artist and owner of Visual Statements. Robert started painting in his early thirties as a release from a stressful job. After 3 years of training with an illustrator, Visual Statements Ow.....Read more

/ 1 / 2 / 3 / 4 / 5 /