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=5&page=84") 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-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-08-19", DATEDIFF(`media`.`mediaCreated`, "2019-08-19"), DATEDIFF("2019-08-19", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-08-19", DATEDIFF(`media`.`mediaUpdated`, "2019-08-19"), DATEDIFF("2019-08-19", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-08-19", DATEDIFF(`userLastUpdate`, "2019-08-19"), DATEDIFF("2019-08-19", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-05-27" AND "2019-11-11", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-08-19", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-08-19"), DATEDIFF("2019-08-19", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `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-08-19" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-08-19", IF(`media`.`mediaDate`>"2019-08-19", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN IF(`mediatypes`.`mtFuture`=1, "2019-08-19", "2018-08-19") AND IF(`mediatypes`.`mtFuture`=1, "2020-08-18", "2019-08-19")) AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (5) GROUP BY `media`.`mediaID` ORDER BY `relevance` DESC LIMIT 1245, 15;
Creative Torbay / directory / Profiles / Arts and Crafts / 1246 to 1260 of 1349

directory

Profiles / Arts and Crafts / 1246 to 1260 of 1349

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

Rhizomatec / Anna J Chapman- Artist and Holistic Designer

Rhizomatec

Anna J Chapman- Artist and Holistic Designer

I am a contemporary artist working in sculpture, using neglected materials to explore emotional and spiritual dimensions to architecture and built form. My work explores how we might use aesthetics and the energy of matt.....Read more

Julia Batten

Julia Batten

Fused glass jewellery and art...Read more

ART @ MG-Mardleybury Gallery / Welcome to ART@MG

ART @ MG-Mardleybury Gallery

Welcome to ART@MG

ART @ MG _Mardleybury Gallery is an eclectic place displaying and selling, original art, limited edition prints, cards, ceramics, sculptures, jewellery, glass, woodwork and photography. We are a permanent gallery exhib.....Read more

Avron House

Watercolour Weekends

Avron House is a relaxed and friendly, licensed guest house providing fine bed and breakfast accommodation between Torquay and Babbacombe. Eight guest rooms all en-suite with free wifi, Cole & Lewis toiletries, Hospital.....Read more

JodieChristine / Jodie Christine Illustrations

JodieChristine

Jodie Christine Illustrations

I am an Illustrator from Hertfordshire, specialising in Children’s books. I like books, games and pretty things, and I am slowly building my own library. When I am not drawing you can find me: at the Swimming Pool, teach.....Read more

North Herts. Museum

North Hertfordshire Museum

North Hertfordshire Museum is an exciting new museum in the centre of HItchin. It combines collections from the old Hitchin and Letchworth Museums, with material previously in store, to tell the story of the North Herts......Read more

Signed by Sam / fused glass artist

Signed by Sam

fused glass artist

Trained at art college many years ago as a graphic designer, I am now based in Stevenage and work mainly with kiln fused glass. My makes are inspired by nature and my love of the coast, although I do allow my quirky s.....Read more

Mr / Alternate Plane Woodcrafts

Mr

Alternate Plane Woodcrafts

Based in Hitchin, Hertfordshire, Alternate Plane Woodcrafts create handmade wooden gifts/toys/ornaments in a variety of shapes and sizes. If you would like to commission an item, we would be delighted to hear from you. P.....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

Blues and Pearls / Handmade silver, pearl and semi-precious gemstones.

Blues and Pearls

Handmade silver, pearl and semi-precious gemstones.

Blues and Pearls is a collection of beautiful jewellery. Each piece is handmade and designed by me. I use only sterling silver for every part of the jewellery along with freshwater pearls and semi precious stones, such a.....Read more

Celtic Art & Design Workshops / Mike Terrett

Celtic Art & Design Workshops

Mike Terrett

From first principles through to advanced design. Regular workshops locally. Customised classes for groups and visitors including 'Cafe Classes'. Original designs. Prints for sale. Commissions and consultation. Classes .....Read more

Sara Evans Pottery / Pottery Classes nr Newton Abbot

Sara Evans Pottery

Pottery Classes nr Newton Abbot

I teach pottery and ceramics to beginners and those with some experience of working with clay at Hannahs at Seale Hayne near Newton Abbot. Sessions are offered on Tuesday mornings and evenings; Wednesday evenings; and Fr.....Read more

English Framing Co / Creative Picture Framers

English Framing Co

Creative Picture Framers

At English Framing Co. we have a wealth of knowledge, experience and creativity, and we tailor our picture frames to your individual style and budget. Each frame is handcrafted by skilled craftsmen at our onsite frame.....Read more

Expressive Explorers / Early Years Storytelling through the arts

Expressive Explorers

Early Years Storytelling through the arts

Expressive Explorers deliver storytelling workshop based training in Private Day Nurseries, Pre-Schools, Playgroups and Schools. Our training not only benefits the children who participate, but also their practitioners/t.....Read more

Carlajayne stampin'up Demo / Independent UK Stampin'up Demonstrator

Carlajayne stampin'up Demo

Independent UK Stampin'up Demonstrator

Hi, I organise classes/workshops, materials and equipment included. Also available to buy from my shop. Inks cardstock and embellishments all coordinate, saving you time by not having to trawl the shops and web! More.....Read more

/ 1 / / 50 / / 80 / 81 / 82 / 83 / 84 / 85 / 86 / 87 / 88 / / 90 /