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=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-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 45, 15;
Creative Torbay / directory / Profiles / Fashion and Textile / 46 to 60 of 119

directory

Profiles / Fashion and Textile / 46 to 60 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

Top Notch Knots / Handmade bracelets

Top Notch Knots

Handmade bracelets

A handmade Shamballa or Friendship style Macrame bracelet handmade with waxed cord. I thread beads throughout the bracelets, to a high standard. Just pull the cords to tighten and pull again to release..Read more

Vicki Boulter FNPS ARPS / Torquay Based Avant Garde Portrait Artist

Vicki Boulter FNPS ARPS

Torquay Based Avant Garde Portrait Artist

Vicki-Lea Boulter FNPS ARPS - Avant-Garde Fashion & Portrait Photographer Nominated 'Photographer of the Year' 2012 & 2013 by the SWPP In August 2013 Vicki-Lea was awarded the PSA Gold Medal (Photographic Society of .....Read more

Bridget Arnold / Silk Painting , Sun Printing and Flag Workshops

Bridget Arnold

Silk Painting , Sun Printing and Flag Workshops

New Workshop Space I have created a new Shaptor Studio garden workshop , for holding flag making, Sun Printing & Silk painting workshops Workshops in my studio run regularly through the year Silk Painting next date.....Read more

LRDesigns / Leonie Richards

LRDesigns

Leonie Richards

I am a textile designer based in Huddersfield. I have been working in the textile design industry for 7+ years designing prints for fashion and home. I have worked for Catwalk designers, Design Studios in New Yor.....Read more

Agatha's Closet / About Us....

Agatha's Closet

About Us....

Agatha’s Closet is a new non profit social enterprise that gets people together to explore all elements of the fashion industry. Agathas Closet builds projects where there’s loads of fun to be had and skills to be l.....Read more

Future Shores / About Us

Future Shores

About Us

Future Shores is a new non profit project and soon to be Community Interest Company looking at collaboration for social change with young people in Torbay. That means we share our skills as professionals with young pe.....Read more

hayleysdream / Hayley Holden Artist

hayleysdream

Hayley Holden Artist

I am a Artist based in totnes, i work mainly with recycled materials creating art and installations that take on natural forms and energy...Read more

used2bee / Recycle Organic Fairtrade

used2bee

Recycle Organic Fairtrade

Come to us to be inspired , excited, delighted by an enlightened range of superb recycled fairtrade and organic products. Clothing, gifts, foods, homeware, all individual and unique. Torbays only ECOshop..Read more

Ione Georgia Grace / Textile and Fashion Designer

Ione Georgia Grace

Textile and Fashion Designer

I am currently in my final year of my FdA in Three Dimensional Design I am focusing on developing screen printed fabrics. My recent work explores surface print and the garment; how the form of the print and the form of t.....Read more

Orchard Learning Studios / Orchard Learning Studios

Orchard Learning Studios

Orchard Learning Studios

Fully equipped Studio on the Devon/Cornwall border, offering a huge range of courses and workshops in Cookery, Craft and Leisure activities. We love to create a family atmosphere, encouraging generations to come and l.....Read more

L & J Fabric / Fabric and sewing supplies

L & J Fabric

Fabric and sewing supplies

We are a fabric and haberdashery shop located in Crossways shopping centre Paignton. We stock a range of fabric for both craft and dressmaking which is increasing all the time. We also have in a stock the mcCalls sewing .....Read more

Vika Nova / Hand Made by Vika Nova

Vika Nova

Hand Made by Vika Nova

Welcome to my enchanted world. We are a family company. In our lab created hand-made items: Gustavian-style furnishings, collectible dolls, baskets and boxes and more interior design elements. So, to our homes for us was.....Read more

Moon hand made / \\\\\

Moon hand made

\\\\\

Hi ,my name is Kate I love making new stuff. This includes; clothing, glass, and accesories. That is my favourite job. Everysingle work that I have done is the one and only, sometimes I can make something simillar. I lov.....Read more

The Crafted Emporium / @ Dartmouth

The Crafted Emporium

@ Dartmouth

The Crafted Emporium opened it's doers on April 5th by Louise Blackburn and Jane Willis. We are situated in the Old Market Square just off Victoria Street in Dartmouth. The ethos behind our little shop is stock and sell .....Read more

D M Hemming / Novelist / Poet / Knitwear Designer / Textile Artist

D M Hemming

Novelist / Poet / Knitwear Designer / Textile Artist

Dawn's unpublished novels have been both short and long-listed for novel awards since 1999. She is currently looking for an agent and publisher for her work, including a children's Fantasy novel; 'Shading Jenny' and a S.....Read more

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