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=7&page=2") 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-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-06-25", DATEDIFF(`media`.`mediaCreated`, "2019-06-25"), DATEDIFF("2019-06-25", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-06-25", DATEDIFF(`media`.`mediaUpdated`, "2019-06-25"), DATEDIFF("2019-06-25", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-06-25", DATEDIFF(`userLastUpdate`, "2019-06-25"), DATEDIFF("2019-06-25", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-02" AND "2019-09-17", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-06-25", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-06-25"), DATEDIFF("2019-06-25", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `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-06-25" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-06-25", IF(`media`.`mediaDate`>"2019-06-25", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-06-25", "2018-06-25") AND IF(`mediatypes`.`mtFuture`=1, "2020-06-24", "2019-06-25")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (7) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 15, 15;
Creative Torbay / directory / Profiles / Fashion and Textile / 16 to 30 of 119

directory

Profiles / Fashion and Textile / 16 to 30 of 119

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

Owls Go Hoot

graphic design, paper goods and textiles

Owls Go Hoot is a small paper goods and textiles business run by me, Natalie Jones. I draw, design and print a selection of greetings cards and postcards as well as my own bags and textile goods. I also work as a graphi.....Read more

Yuli Somme

Yuli Somme, Felt Maker & Bellacouche

I source my wool locally and particularly like the rare breed varieties. I have a number of projects on the go at the moment. Feet Felts is a sort of "direct action" of walking in wool. Wool has this wonderful ability to.....Read more

Karen Dunton

Karen Dunton

Born in Devon I studied Art & Design at North Devon College specializing in 3D Design, following this I went to CCTA in Carmarthen to study Sculpture. My main areas of work are art and craft, I love to paint but also .....Read more

Yvonne Temple / Yvonne Temple -  Sewing, Dressmaking and Textiles

Yvonne Temple

Yvonne Temple - Sewing, Dressmaking and Textiles

Hello ..thanks for stopping by. I am a textile artist who loves to create, stitch, connect with others and eat cake! I live in the beautiful South Hams and have a wonderful studio from where I deliver regular workshops .....Read more

sewdarngood

Plymouth Knitters Social

We meet every Tuesday evening in the Fortescue Pub, Mutley Plain, Plymouth from 7.30pm for craft based fun, real ale and a lovely time. All levels of crafters welcome and there's always spare needles and yarn along with .....Read more

Hamble & Jemima

Handmade Bags

In beautiful Devon, England, Hamble & Jemima create original bags from beautiful fabrics. Through our 3 exclusive brands; ‘Handmade with love’, ‘Recycled with love’ and ‘Designed with love’, we create stunning shoulder b.....Read more

Rachael

Artist / Designer Maker

I have lived in Devon all my life and find it an inspiring place to live; my work is influenced by the fantastic quality of light. I also seek inspiration from the many cities, such as Barcelona that I have travelled to......Read more

Stephanie Buddle Jewellery

Colourful Designer Jewellery for those who love to be noticed

Stephanie designs and produces a complete range of stunning contemporary jewellery, created in colour 'collections' which ensures every piece is unique and exclusive. It can be purchased from selected quality Galleries, .....Read more

Holli Jayne / Varied Artist

Holli Jayne

Varied Artist

I like to express myself in a variety of different ways, depending on mood and what I'm trying to convey. Photography The beauty of photography is you can catch an eternal memory of something that is normally often s.....Read more

Jaccol's Art Emporium / jaccols Art Emporium

Jaccol's Art Emporium

jaccols Art Emporium

I am a self-employed artist that paints anything that moves or stays still. Face-painting and Body painting, Portraits, Landscapes, Signwriting, Murals, Miniatures; big or small I Paint them all. If I'm not painting thin.....Read more

Stephanie Edmonds

Makeup artist

I am a freelance Makeup artist based in Plymouth, I have a passion for art and being creative. I have worked on many photoshoots including a uk calender and theatre productions. Please contact me if you need a makeup art.....Read more

TRAIL WEARABLE ART

Wearable Art Show 2009

WEARABLE ART/ SCULPTURE SHOW Monday 27th July 2009 TRAIL was 5 years old in 2009 and to celebrate, along with the established sculpture trail, launched a new initiative, an exciting extravaganza of wearable art/sculptur.....Read more

Keen Crafty Club

St Cuthbert Mayne Crafty Club

A not for Profit Crafty Business put together by the Students of St Cuthbert Mayne. The Concept was built around using Creative skills and linking these to the Business world. All Students involved have already complet.....Read more

Elizabeth Woods

Artist and Designer-Maker

I am an experienced qualified teacher, workshop leader, and project co-ordinator. Apart from teaching in schools, I have for many years worked with young people in the community, and for other organisations working with .....Read more

Dan Petley

Talented, hard working and ready to take on the world...

I am a multi disciplined artist, who aims to produce work of the highest standard in every medium that I work in. My practice originated in 2005 when the films that I had made whilst working in Cardiff prison became an i.....Read more

/ 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 /