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`, "/")), "?view=list&letter=h") 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-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-27", DATEDIFF(`media`.`mediaCreated`, "2019-06-27"), DATEDIFF("2019-06-27", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-27", DATEDIFF(`media`.`mediaUpdated`, "2019-06-27"), DATEDIFF("2019-06-27", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-27", DATEDIFF(`userLastUpdate`, "2019-06-27"), DATEDIFF("2019-06-27", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-04" AND "2019-09-19", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-27", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-27"), DATEDIFF("2019-06-27", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `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`.`mtDate`=0, 1, IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-27" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-27", IF(`media`.`mediaDate`>"2019-06-27", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-27", "2018-06-27") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-26", "2019-06-27")) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 0, 15;
Creative Torbay / directory / Profiles / 1 to 15 of 4633

directory

Profiles / 1 to 15 of 4633

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

Louise Armitage

Art:ful and Gini's Boutique

Art:ful Art workshops for groups of people in care homes, special needs school, hospices, refuges etc Gini's Boutique Online shop selling handmade jewellery and wall hangings. Stalls. Workshops on weaving, dors.....Read more

Mike Stubbs / Art

Mike Stubbs

Art

Mike Stubbs is an independent artist, curator and consultant. Living in Doncaster he is the Creative Producer for Doncaster Creates and developing new artwork for Bedford Creative Arts and Folkestone Trienalle. For 12 y.....Read more

Waterstones Doncaster / Book store

Waterstones Doncaster

Book store

The best place to spend time in Doncaster; browse books, enjoy a coffee and have a chat to our lovely booksellers! This store is set right in the heart of the busy Frenchgate Centre. Whether you are after the lat.....Read more

Doorstep Arts / Participation/Music/Theatre

Doorstep Arts

Participation/Music/Theatre

Doorstep Arts is a non-profit arts education organisation based in Torbay. We run 14 drama groups across Torbay at key doorstep sites – youth clubs, church halls and schools. We are also the creative education company in.....Read more

Christmas By The Sea / 2016

Christmas By The Sea

2016

With FREE events throughout the festive period… you can see, hear, feel and create Christmas. Starting with the Christmas Carnival on Saturday 19th November there will be activities and art throughout the town, with .....Read more

Vanessa

vanessa

Creative producer for Kitmapper..Read more

ParkEvents InspireAll / Park Events

ParkEvents InspireAll

Park Events

COMMUNITY! FAMILY! FUN! In our 6th year now, Park Events with InspireAll brings you great, family friendly events in local parks throughout Hertsmere. From Movies In The Park to Bushey Acoustic Festival, Easter Egg Hun.....Read more

Brixham College Creative & Media

Brixham College Creative & Media

In Development..Read more

Rich Spicer / AADHD creative coach and artist

Rich Spicer

AADHD creative coach and artist

Hi. I'm an artist and life coach living in East Preston Nr Littlehampton. I have worked as an artist for 20 years and became qualified as a transformational life coach in 2016. I'm also credentialed with the ICF I.....Read more

Devon Open Studios / Devon Open Studios

Devon Open Studios

Devon Open Studios

Devon Open Studios takes place for two weeks in early September at venues across the county. Participating artists and makers can choose to open for the whole event or selected days of their own choosing. Devon Open .....Read more

Positive Earth Designs / Artist

Positive Earth Designs

Artist

Hi, I'm Jac - a pyrography artist specifically working with recycled wood. Inspired by nature and organic forms, I use the natural grains and defects in the wood to add character to each piece. I am passionate about re.....Read more

Hestercombe Gallery / Contemporary Art

Hestercombe Gallery

Contemporary Art

Hestercombe Contemporary Art Gallery aims to present the best in contemporary arts practice whilst focusing on the relationship between art and landscape. We aim to be a place where art is not just shown but where artist.....Read more

Imajica Theatre / Imajica Theatre

Imajica Theatre

Imajica Theatre

Imajica Theatre creates original interactive immersive musical productions for the younger audience. We bring stories to life on stage and share topical environnemental and educational messages and promote positive well .....Read more

Martin / Creative Beings CIC

Martin

Creative Beings CIC

Creative Beings CIC: drawing from nature to reconnect with self, community and planet. Creative Beings is an inspiring creative hub in East Devon where we can be curious & connect, learn & laugh, explore & express...Read more

The Craft Workshop / The Craft Workshop

The Craft Workshop

The Craft Workshop

The Craft Workshop is a place to learn and explore new crafts in a variety of disciplines. Lianne Woodward has over 15 years experience as a Community Artist and rubs classes in many art forms including Felt making, silk.....Read more

1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / / 19 / / 29 / / 59 / / 109 / / 159 / / 209 / / 259 / / 309 /