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=23") 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-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-21", DATEDIFF(`media`.`mediaCreated`, "2019-07-21"), DATEDIFF("2019-07-21", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-21", DATEDIFF(`media`.`mediaUpdated`, "2019-07-21"), DATEDIFF("2019-07-21", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-21", DATEDIFF(`userLastUpdate`, "2019-07-21"), DATEDIFF("2019-07-21", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-28" AND "2019-10-13", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-21", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-21"), DATEDIFF("2019-07-21", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-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-07-21" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-21", IF(`media`.`mediaDate`>"2019-07-21", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-07-21", "2018-07-21") AND IF(`mediatypes`.`mtFuture`=1, "2020-07-20", "2019-07-21")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 330, 15;
Creative Torbay / directory / Profiles / 331 to 345 of 1508

directory

Profiles / 331 to 345 of 1508

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

Jo Talbot Bowen

Artist in Residence at Kenton Vineyard

I am a painter (graduated 1st class honours Fine Art, 2006) and a former London psychiatrist. I work on site in studios at Kenton Vineyard near Exeter. My current body of work involves boating and seascapes as well as De.....Read more

The Weaver Twins

The Weaver Twins

well we've sifted through a few ghosts - junked a few old things, y'know? five heavy doses of barbara's electrical black elixir, langoustine noodlings with lashings of iffy ketchup brixham bash outs and live beets twitch.....Read more

Mewstones

What We Do

Mewstones is a consultancy specializing in regeneration and sustainable development initiatives. We work with partnerships in business, the community and local, regional and European government. Mewstones, in partnershi.....Read more

Maya Gordon

Creative Design & Moving Image

I am currently on my second year of Fda Creative Digital Media at South Devon College hoping to complete a third year in Media Production at Bournemouth, Hertfordshire or Plymouth to top-up my degree to a BA Hons. My mai.....Read more

fringe Arts Bath

Fringe arts Bath

Fringe Arts Bath (FAB) is a small not-for-profit organisation that arranges a two-week programme of contemporary art exhibitions, events and workshops during Bath Fringe Festival in May/June each year. We aim to raise th.....Read more

Erin Walcon / Drama Educator

Erin Walcon

Drama Educator

As part of the core team behind Doorstep Arts, Artistic Director for Devon Youth Theatre, and an Associate Research Fellow at the University of Exeter drama department, Erin's work focuses on young people's participatory.....Read more

Luci Coles

Luci Coles -Artist

Luci trained as a sculptor, graduating from Wimbledon School of Art in 2000. Her work demonstrates a unique blend of experimental and traditional techniques, materials and aesthetics; a sense of history in a contemporary.....Read more

The Torbay Bookshop

The Torbay Bookshop

Multi-award winning Torbay Bookshop prides itself on customer service. If you need a book, CD or DVD, we'll probably be able to obtain it for you tomorrow. Have you wanted to replace an old book that you know is out of p.....Read more

Mr Nigel Montgomery

There are no strangers here only friends you haven't meet yet.

life it what we make it...Read more

Delamore Gallery

Art, Sculpture, Photography, Ceramics, Glass, Jewellery & Crafts

Delamore Gallery & Sculpture Courtyard Delamore Park, Cornwood, Devon, PL21 9QP admin@delamore.com, 01752 837719 OPEN: Mon – Sat 10am to 4.30pm, Sun 12pm to 4.30pm This innovative and beautiful space is located within.....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

Joanna Radford / Joanna Radford - Printmaker and Book Artist

Joanna Radford

Joanna Radford - Printmaker and Book Artist

I live on the edge of Dartmoor, breeding Dartmoor ponies and farming Shetland Sheep. I am a printmaker and use Dartmoor and my rural life as my inspiration. I make woodcuts and wood engravings, and use my prints to make .....Read more

ROC CREATIVE

ROC

ROC CREATIVE is a part of the Robert Owen Communities, a registered charity supporting adults with learning disabilities...Read more

Creative Photos

Creative Photographer

Winner of The Master Photographers Association's SW Portrait Photographer of the year 2011 (under 5's). Clients include various cabaret/stage entertainers from within the area, W.A.Shearings Holidays, Torbay Fire & Res.....Read more

Spacex

Spacex

Spacex is a leading contemporary art gallery based in the centre of Exeter. We encourage public engagement with the latest developments in contemporary art through exhibitions, projects, events and activities...Read more

/ 1 / / 10 / / 19 / 20 / 21 / 22 / 23 / 24 / 25 / 26 / 27 / / 51 / / 101 /