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&letter=j&type=individual") 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-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`media`.`mediaCreated`>"2019-07-22", DATEDIFF(`media`.`mediaCreated`, "2019-07-22"), DATEDIFF("2019-07-22", `media`.`mediaCreated`)))))*`weightingCreated`, 0))+(IF(`weightingUpdated`>0 AND `media`.`mediaUpdated`!="0000-00-00" AND `media`.`mediaUpdated` BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`media`.`mediaUpdated`>"2019-07-22", DATEDIFF(`media`.`mediaUpdated`, "2019-07-22"), DATEDIFF("2019-07-22", `media`.`mediaUpdated`)))))*`weightingUpdated`, 0))+(IF(`weightingProfileupdated`>0 AND `userLastUpdate`!="0000-00-00" AND `userLastUpdate` BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(`userLastUpdate`>"2019-07-22", DATEDIFF(`userLastUpdate`, "2019-07-22"), DATEDIFF("2019-07-22", `userLastUpdate`)))))*`weightingProfileupdated`, 0))+(IF(`weightingDate`>0 AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`)))!="0000-00-00" AND IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))) BETWEEN "2019-04-29" AND "2019-10-14", ((1.1904761904762*(84-IF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`)))>"2019-07-22", DATEDIFF(IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `media`.`mediaDate`, `media`.`mediaDateEnd`))), "2019-07-22"), DATEDIFF("2019-07-22", IF(`mediatypes`.`mtDateEnd`=0 OR `media`.`mediaDateEnd`="0000-00-00", `media`.`mediaDate`, IF("2019-07-22" BETWEEN `media`.`mediaDate` AND `media`.`mediaDateEnd`, "2019-07-22", IF(`media`.`mediaDate`>"2019-07-22", `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 `userType`="individual" AND IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) REGEXP "^[^a-z0-9]*j" AND `mrMedia`=`media`.`mediaID` AND `mrRefinement` IN (5) GROUP BY `media`.`mediaID` ORDER BY IF(`mediatypes`.`mtCode`="profiles", CONCAT(`users`.`userDisplayName`, " / ", `media`.`mediaTitle`), `media`.`mediaTitle`) ASC LIMIT 0, 15;
Creative Torbay / directory / Profiles / Individuals / Arts and Crafts / J / 1 to 15 of 67

directory

Profiles / Individuals / Arts and Crafts / J / 1 to 15 of 67

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

J Howroyd / Jane Howroyd

J Howroyd

Jane Howroyd

As a workshop facilitator, I deliver creative, historical, textile, craft and food workshops to a variety of audiences including youth groups, schools, adults and family groups. I have worked with a range of universit.....Read more

Jaan

Jann:Painter: acrylics or oils on various surfaces, also printer

I am Cambodian, from Stung Treng, but trained as sculptor in Australia. Now using hardboard, foamboard, paper, fridge door, and experimenting with movement. Tendancy to work on large pieces upto 6 ft. Use of photoshop. B.....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

Jack Coulthard / Painter

Jack Coulthard

Painter

The world-class artist Jack Coulthard has painted near Taunton for more than 40 years. Now in his eighties, Jack has always worked outside fashionable artistic styles. All kinds of preoccupations and fascinations have.....Read more

JACK TREE / blessed are the cracked for they let in the light

JACK TREE

blessed are the cracked for they let in the light

Arboristic arts & curious crafts from large chainsaw sculpture & furniture to curio creatures, bowls, jewellery & silvarian oddities. performance artist, environmental educator. www.tribeofmog.org..Read more

Jackie Wills / Jackie Wills

Jackie Wills

Jackie Wills

As a child I had a great passion for textiles. I was given a small commission by Charles Hammond, Sloane Street, London in 1984, and was subsequently offered a job with another Interior Designer in Chelsea. My early work.....Read more

Jain McKay

Jain McKay

Freelance artist and event organizer. Saatchi http://www.saatchionline.com/JainMcKay I Left my Hair http://jainmckay.blogspot.com/?spref=tw Facebook Jain-McKays-artwork Twitter http://twitter.com/Jainmckay Wordpress.....Read more

Jan Bennett / artist

Jan Bennett

artist

I paint pictures, create 3-D 'scuptures' using recycled materials, paint faux marble and re-vamp retro furniture. I show some of my art-work in my themed studio windows in Norfolk Road, Littlehampton. Find me on facebook.....Read more

jAN gRIFFITHS / Jan Griffiths

jAN gRIFFITHS

Jan Griffiths

Ceramic Artist..Read more

Jan O'Highway / Jan O'Highway

Jan O'Highway

Jan O'Highway

Mixed media artist, based in Totnes. FaceBook - Jan O'Highway Arts After training in painting and printmaking at Guildford School of Art, I’ve worked in many areas; textiles, ceramics, mosaics, environmental art, an.....Read more

Jan Tricker

Artist

Following a career in graphic design and running my own design studio, I studied at Chelsea College of Art & Design and gained a BA (hons) degree in Textile Design. Since moving to West Somerset in 2004 I have devoted.....Read more

Jane Chitty / Jane Chitty Artworks

Jane Chitty

Jane Chitty Artworks

I run different art classes designed for individual people – ranging from those who have not touched a paintbrush since schooldays to those who paint regularly and want some guidance and input about their work. My begi.....Read more

Jane Galvin / painter

Jane Galvin

painter

Owner of Slawit Studio, Slaithwaite My work is about colour and the application of it on to paper or canvas. In my flower pieces, I am trying to encourage the viewer to really take notice of the flower that per.....Read more

Jane Glynn / Jane Glynn

Jane Glynn

Jane Glynn

Artist/Illustrator/Educator Sculptural diaries, paintings, drawings and animations. Children's books. Forest school/art projects. Collaborations. Fellow of the Digswell Arts Trust...Read more

Jane Keeley / Sculptor

Jane Keeley

Sculptor

I sculpt figures, faces and natural forms in many media, from soft clay and billows of cloth to spiky wire and hard metal. My work captures gesture, posture & expression. Having studied art and design at Brighton Univers.....Read more

1 / 2 / 3 / 4 / 5 /